sql server - Storing SQL Table Data -
i using mvc entity framework , have table tracks daily events in hotel atmosphere. these events change daily such cleans room , time of cleaning. table fine save copy of table on daily basis. have read in forum serializing list of table entries not idea (how store list in column of database table). how go saving table data on daily basis if not using list of table entries?
this units class/table
public class units { [key] [required] public int unitid { get; set; } public int unitnumber { get; set; } public string unittype { get; set; } public string status { get; set; } public bool checkout { get; set; } public bool isempty { get; set; } public employees housekeeper { get; set; } public datetime? cleanstart { get; set; } public datetime? cleanend { get; set; } public bool isclean { get; set; } public employees laundry { get; set; } public datetime? laundrytime { get; set; } public bool islaundry { get; set; } public employees qualitycontrol { get; set; } public datetime? qcstart { get; set; } public datetime? qcend { get; set; } public bool isqc { get; set; } public employees maintenance { get; set; } public datetime? maintstart { get; set; } public datetime? maintend { get; set; } public bool ismaint { get; set; } public string comments { get; set; } public string color { get; set; } }
Comments
Post a Comment