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);
}
