public NormsView GetNormsViewsItem(int idnt) { NormsView view = null; SqlServerConnection conn = new SqlServerConnection(); SqlDataReader dr = conn.SqlServerConnect("SELECT ni_idnt, ni_item, ni_catg, ni_category, ni_type, ni_types, L1, L2, L3, L4, L5, L6 FROM vNormsLevels WHERE ni_idnt=" + idnt); if (dr.Read()) { view = new NormsView(); view.Item.Id = Convert.ToInt16(dr[0]); view.Item.Name = dr[1].ToString(); view.Item.Category.Id = Convert.ToInt16(dr[2]); view.Item.Category.Name = dr[3].ToString(); view.Item.Type.Id = Convert.ToInt16(dr[4]); view.Item.Type.Name = dr[5].ToString(); view.L1Norm = Convert.ToInt16(dr[6]); view.L2Norm = Convert.ToInt16(dr[7]); view.L3Norm = Convert.ToInt16(dr[8]); view.L4Norm = Convert.ToInt16(dr[9]); view.L5Norm = Convert.ToInt16(dr[10]); view.L6Norm = Convert.ToInt16(dr[11]); } return(view); }
public AdminViewModel() { NormsItems = new NormsItems(); Roles = new Roles(); Types = new List <SelectListItem>(); Categories = new List <SelectListItem>(); Role = new List <SelectListItem>(); Counties = new List <SelectListItem>(); Constituencies = new List <SelectListItem>(); Users = new Users(); NormsView = new NormsView(); }
public NormsView SaveNormItems(NormsView view) { SqlServerConnection conn = new SqlServerConnection(); view.Item.Id = conn.SqlServerUpdate("DECLARE @idnt INT=" + view.Item.Id + ", @type INT=" + view.Item.Type.Id + ", @catg INT= " + view.Item.Category.Id + " , @name NVARCHAR(100)='" + view.Item.Name + "'; IF NOT EXISTS(SELECT ni_idnt FROM NormsItems WHERE ni_idnt=@idnt) BEGIN INSERT INTO NormsItems(ni_type, ni_catg, ni_item) output INSERTED.ni_idnt VALUES (@type, @catg, @name) END ELSE BEGIN UPDATE NormsItems SET ni_type=@type, ni_catg=@catg, ni_item=@name output INSERTED.ni_idnt WHERE ni_idnt=@idnt END"); conn = new SqlServerConnection(); SqlDataReader dr = conn.SqlServerConnect("SELECT fctg_idnt, fctg_level FROM FacilityCategory"); if (dr.HasRows) { while (dr.Read()) { NormsTiers tier = new NormsTiers(); tier.Item = new NormsItems(view.Item.Id); tier.Category = new FacilityCategory(Convert.ToInt64(dr[0])); if (Convert.ToInt64(dr[1]) == 1) { tier.Value = view.L1Norm; } else if (Convert.ToInt64(dr[1]) == 2) { tier.Value = view.L2Norm; } else if (Convert.ToInt64(dr[1]) == 3) { tier.Value = view.L3Norm; } else if (Convert.ToInt64(dr[1]) == 4) { tier.Value = view.L4Norm; } else if (Convert.ToInt64(dr[1]) == 5) { tier.Value = view.L5Norm; } else if (Convert.ToInt64(dr[1]) == 6) { tier.Value = view.L6Norm; } tier.Save(); } } return(view); }
public List <NormsView> GetNormsViews(NormsType type) { List <NormsView> views = new List <NormsView>(); string AdditionalQuery = ""; if (type.Id > 0) { AdditionalQuery = "WHERE ni_type=" + type.Id; } SqlServerConnection conn = new SqlServerConnection(); SqlDataReader dr = conn.SqlServerConnect("SELECT ni_idnt, ni_item, ni_catg, ni_category, ni_type, ni_types, L1, L2, L3, L4, L5, L6 FROM vNormsLevels " + AdditionalQuery + " ORDER BY ni_type, ni_catg, ni_idnt"); if (dr.HasRows) { while (dr.Read()) { NormsView view = new NormsView(); view.Item.Id = Convert.ToInt16(dr[0]); view.Item.Name = dr[1].ToString(); view.Item.Category.Id = Convert.ToInt16(dr[2]); view.Item.Category.Name = dr[3].ToString(); view.Item.Type.Id = Convert.ToInt16(dr[4]); view.Item.Type.Name = dr[5].ToString(); view.L1Norm = Convert.ToInt16(dr[6]); view.L2Norm = Convert.ToInt16(dr[7]); view.L3Norm = Convert.ToInt16(dr[8]); view.L4Norm = Convert.ToInt16(dr[9]); view.L5Norm = Convert.ToInt16(dr[10]); view.L6Norm = Convert.ToInt16(dr[11]); views.Add(view); } } return(views); }