C# - Defining Status Of Data Via Enum Or A Relation Table?
Aug 20, 2010
I have an application which has rows of data in a relation database the table needs a status which will always be either Not Submitted, Awaiting Approval, Approved, Rejected Now since these will never change I was trying to decide the best way to implement them I can either think of a Status enum with the values and an int assigned where the int is placed into the status column on the table row.
Or a status table that linked to the table and the user select one of these as the current status.
I can't decide which is the better option as I currently have a enum in place with these values for the approval pages to populate the dropdown etc and setup the sql (as it currently using to Approved and submitted for approval but this is dirty for various reasons and needs changed).
Wondering what your thought on this were and whether I should go for one or the other.
If it makes any difference I am using Entity framework.
View 3 Replies
Similar Messages:
Mar 5, 2011
On one of our tables, a default clustered index is defined on the primary key by sql server 2005. The table also contains forign key columns and has got over 2 million rows. There are very frequent INSERT, UPDATE and DELETE functions on this table. Recently some of the SELECT queries which primary operate on the forign keys have become very slow (resulting in application timeout). To fix the problem, I defined an index on one of the primary keys which gave me very quick results. I don't know much about indexes.
1. Since I defined a new index (on the forign key) in addition to the existing default index, what kind of index (clustered or non-clustered) have I defined?
2. What performance impact does it have on the rest of the system? Is it going to break something else?
3. I read about fill factor. What is this and how does it effect the system?
4. Is the new index physically going to make any changes?
5. In case I delete this index later on, will the database return to the existing state or it will be a different state from now?
View 1 Replies
Nov 14, 2010
I need to get across relation table on linq quiry..
Table A
Column A.id
Column A.SomeValue
Table B (relation table)
Column A.id
Column C.id
Table C
Column C.id
Column C.SomeValue
Now i need to get a table with A.SomeValue and C.SomeValue
How do I linq it?
[Code]....
View 1 Replies
Mar 4, 2011
how to bind treeview in web from table having ParenId relation?
my table structure... Id, Name, ParentID.
I want to show Name as Node Text.
View 1 Replies
Sep 28, 2010
whats wrong with this code, i try also Enum.Parse but didnt work.
public enum RoleNames
{
Administrator,
[code]...
View 1 Replies
Apr 14, 2010
My requirement is to create an Enum based on values present in a table from DB. I am using ADO.NET Entity Framework model (.edmx file),
View 2 Replies
Sep 24, 2010
Defined RegisterModel class - with some validation rules for creating new users, and this works fine.
Then I get this class, strip few properties and wanted to reuse it as UserInfo_Form_Model, for editing user properites.
No changes, just deleted few items, renamed and reused in strongly typed View for editing.
And result of validation is: -
[DisplayName("Name")] works fine, showing correct
[StringLength(20, ErrorMessage = "xxxx...")] - not working, no message showed when suppose to be one
[Required(ErrorMessage = "xxxx.")] - not working, not showing messages when delete required values?
but (ModelState.IsValid) is false when I checked it in controller (it had to be because required value is missing)?
Is it this only partially correct and how this can be?
Well this is a bit frustrating because it cant be simpler than this and I cant make this simple code reuse.
View 3 Replies
Feb 25, 2010
I need to defining the Series parameters for an MS Chart.
Using the sample data below is it possible to set the X & Y value types for a graph with all days for the month on the X axis and the total number of visits for each day on the Y. Are MS Charts capable of auto generating the X axis based on the extents of the data dates as well a counting the daily instances?
[code]....
View 1 Replies
Mar 27, 2011
I have a C# assembly that loads external files. This assembly is used by asp.net website. The following is the code that loads the data files
string dataDirectory = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location),"data"); filePath = Path.Combine(dataDirectory,_fileName);
The component works fine in a windows app, but when I tried to use it in an asp.net website, it fails as the site could not find the data files. And it gives me the following error:
C:WindowsMicrosoft.NETFrameworkv4.0.30319Temporary ASP.NET Filescmictranslatorsite20a8eddd864b2575assemblydl35bd4a35e8c6f79b6_98eccb01datafile.txt
View 1 Replies
Aug 14, 2010
I would like bind grid view with 2 different tables that has no relation.
View 2 Replies
Aug 12, 2010
when i create my entity data model i have a situation in the DB like this :
TableFirst : [Id,IdTableSecond,IdTableSecondAgain];TableSecond[Id]
Created data model is: TableFirst.TableSecond and TableFirst.TableSecond1
Question is: Every time when i create my entity TableFirst.TableSecond will have same relation in behind (IdTableSecond) and TableFirst.TableSecond1 (IdTableSecondAgain)
or they may change?
View 1 Replies
Feb 6, 2011
I have 3 tables: People, Fruits and a table named People_Fruit which connects People to Fruit tables. in table People_Fruit we enter records which determine who loves which fruit. People_Fruit is at "Many" side of both People and Fruits table. at this link you see this in a WinForms project: [URL]
I want to show people in a ASP grid. when the user click on a person's record he sees all record of fruits table regardless of whether the person loves it or not. there is a CheckBox column which its value determines if the person loves the fruit or not. user can check or uncheck the checkbox. If user checks the checlbox PersonId and FruitID must be entered to the People_Fruit table and if the user uncheck the checkbox the correspond record must be deleted.
View 2 Replies
Oct 14, 2010
I need to insert data into two relation tables, the parent table have an ind colum, which is an auto inser number , how can I get this auto number and insert it into the child table , in asp I see somthing like MyId = ExecuteIdentity(Mysql ), How Is in asp net 1.1 with Vb
View 9 Replies
Mar 17, 2011
I have a linqdatasource and I want to use an enum for Type as below:
<asp:linqdatasource id="GridDataSource" runat="server" enabledelete="true" Where="Type == @Type">
<whereparameters>
<asp:dynamiccontrolparameter controlid="FilterRepeater" />
<asp:QueryStringParameter QueryStringField="Type" Name="Type" ConvertEmptyStringToNull="false" />
</whereparameters>
</asp:linqdatasource>
It keeps throwing an error:
Operator '==' incompatible with operand types 'ProductType' and 'String' ProductType is my Enum, and String is my input type. I don't seem to be able to convert one to the other.
View 2 Replies
May 19, 2010
I have a data object named Usertype. The Database table is also called Usertype. I need to have an enum representing Usertypes also. What would proper naming convention be for the Usertype Enum? It can't be Usertype. But I can't append an E or "Enum" to it anywhere. What would be the proper name for the Enum?
View 3 Replies
Jul 26, 2010
How I will create the scheduling system. I have 3 tables related namely employees, schedule and shift. How will I show the data using the relation shift of the table on gridview by this: It will be filtered by datefrom and dateto: Select via calendar ex Datefrom: August 1 Dateto: August15
Then It will show:
EmployeeID Name
1 2 3 4 5 and up to 15
EP9112 Lastname, firstname, Middlename shift shift shift shift shift
with edit when I press EmployeeID their shift.
How can I also format the shift and date by: ex TimeIn: 7:00:00 AM TimeOut: 3:00:00 PM Date: 8/1/2010
When I add it, it will be TimeIn: 8/1/2010 7:00:00AM TimeOut: 8/1/2010 3:00:00 PM.
Do I need to edit my database.
View 5 Replies
Mar 1, 2011
I have a enum
[Code].....
This I have to bind in my dropdown so how can I achieve this.
View 10 Replies
May 7, 2015
i have a enum class and i want get value and description from enum and bind to dropdownlist but i can get name from enum how do this ?
public enum UniqeGroupId{
[Description("x")]
Group = 1,
[Description("b")]
Run = 2,
[Description("c")]
shopping =3
}
View 1 Replies
Mar 6, 2010
I,am trying to create a self association relation for an organization chart data tree in Entity Framework,after trying different ways for prevention of exceptions like 3007 and etc. I found that when I put my foreign key in my POCO near Parent and Items navigation properties its work.but I think this is not correct that we have both ParentID scalar property and Parent navigation property. review this and tell me is it correct or not.I'm using VS 2010 RC and ofcource .net framework 4.0 RC
[Code]....
View 2 Replies
Sep 11, 2010
I'm trying to bind custom object to details view.
The problem is that enum property fields are not show.
Is there any way to show enum property fields in details view ?
I put some example code below (I do not specify any rows mappings, they are generated dynamically because different kind of objects are bound to details view):
[Code]....
View 1 Replies
Jan 9, 2011
I'm writing an HTTP handler in ASP.NET 4.0 and IIS7 and I need to generate a file-not-found condition.
I copied the following code from Mathew McDonald's new book, Pro ASP.Net 4 in C# 2010. (The response variable is an instance of the current HttpResponse.)
response.Status = "File not found";
response.StatusCode = 404;
However, I found that the first line generates the run-time error HTTP status string is not valid.
If, instead of the lines above, I use the following:
response.Status = "404 Not found";
Then everything seems to work fine. In fact, I even see that response.StatusCode is set to 404 automatically.
My problem is that I don't want this to fail on the production server. So I'd feel much better if I could understand the "correct" way to accomplish this. Why did the first approach work for Mathew McDonald but not for me? And is the second approach always going to be reliable?
View 1 Replies
Mar 28, 2011
having trouble defining bindings using ninject.I am in a standard ASP.NET WebForms application. I have defined an http handler to Inject dependencies in pages and controls (Property injection).Here is what I am trying to do:I am creating a custom combobox usercontrol. Based on the value of an enum on that combobox, I want to be able to Inject a different object in a property (What I am trying to do is a bit more involved than that, but answer to this should be enough to get me going).
View 1 Replies
Feb 26, 2010
I recently upgraded from VS2005 to VS2008. I did a full install of VS2008, then opened my existing project in it. This launched the conversion wizard which successfully converted my VS2005 project to VS2008 and it opened in VS2008 owever, when I first tried to build the solution in VS2008, I got an error on a page defining a web service saying
View 6 Replies
Sep 4, 2010
My following sql query giving me the following error, What does it mean. Am i defining the alias fir column in wring way. Please help me out with this. My error is this and i am putting query just below the error. Error in SELECT clause: expression near 'Year'. Missing FROM clause. Unable to parse query text.
SELECT [tbl_students].passing_year as Passing Year,[tbl_branch].branch_name as Branch_Name FROM [tbl_students], [tbl_course], [tbl_branch] WHERE [tbl_students].course_id=@courseId
AND [tbl_students].branch_id IN(64)
AND [tbl_students].course_id=[tbl_course].course_id AND [tbl_students].branch_id=[tbl_branch].branch_id
AND (@firstYrPercent is null OR [tbl_students].first_year_percent>=@firstYrPercent)
AND (@secondYrpercent is null OR [tbl_students].second_year_percent>=@secondYrPercent)
AND (@thirdYrPercent is null OR[tbl_students].third_year_percent>=@thirdYrPercent)
AND (@finalYearpercent is null OR [tbl_students].final_year_percent>=@finalYearpercent)
AND (@currentDegeePercentage is null OR [tbl_students].current_degree_percent>=@currentDegeePercentage)
AND (@passoutYear is null OR [tbl_students].passing_year>=@passoutYear)
AND (@currentBacklog is null OR [tbl_students].current_backlog=@currentBacklog)
AND (@sex is null OR [tbl_students].gender=@sex)
AND (@eGap is null OR [tbl_students].gapin_education<=@eGap)
AND (@highSchoolPercentge is null OR [tbl_students].highschool_percentage>=@highSchoolPercentge)
AND (@higherSchoolPercentage is null OR [tbl_students].ssc_percentage>=@higherSchoolPercentage)
AND (@grauationPercentage is null OR [tbl_students].graduation_percentage>=@grauationPercentage)
AND (@diplomaPercentage is null OR [tbl_students].diploma_percentage>=@diplomaPercentage)
AND (@noOfAtkt is null OR [tbl_students].number_of_ATKT<=@noOfAtkt)
AND (@validDate is null OR [tbl_students].DOB>=@validDate)
View 1 Replies
Jan 26, 2010
[code]....
I am going to return an Object depending on the Class and Year params. I want to remove the where condition when the Class and Year parames are null or zero.
View 2 Replies
