public ActionResult New_SCK()
{
model = new TypeASPX();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
using (DataTable dt = db.Select("SELECT [id_SC],[SCName]FROM[tbl_Product_SubCategory] WHERE ISDESABLED=0 AND ISDelete=0"))
{
for (int i = 0; i < dt.Rows.Count; i++)
{
data_Sub = new SubCategory();
data_Sub.id_SC = dt.Rows[i]["id_SC"].ToString();
data_Sub.SCName = dt.Rows[i]["SCName"].ToString();
list_Sub.Add(data_Sub);
}
ViewBag.SCK = list_Sub;
};
if (Session["edit_SCK"] != null)
{
model = (TypeASPX)Session["edit_SCK"];
ViewBag.model = model;
}
else
{
ViewBag.model = model;
}
return(View());
}
public ActionResult New_Cat()
{
model = new TypeASPX();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
using (DataTable dt = db.Select("SELECT [id_PT],[PTname] FROM [tbl_Product_Type]WHERE ISDelete=0 AND ISDESABLED=0"))
{
for (int i = 0; i < dt.Rows.Count; i++)
{
data_type = new type();
data_type.id_PT = dt.Rows[i]["id_PT"].ToString();
data_type.PTname = dt.Rows[i]["PTname"].ToString();
list_dat.Add(data_type);
}
ViewBag.Cat = list_dat;
};
if (Session["edit_cat"] != null)
{
model = (TypeASPX)Session["edit_cat"];
ViewBag.model = model;
}
else
{
ViewBag.model = model;
}
return(View());
}
public ActionResult New_type()
{
model = new TypeASPX();
if (Session["edit"] != null)
{
model = (TypeASPX)Session["edit"];
ViewBag.model = model;
}
else
{
ViewBag.model = model;
}
return(View());
}
public ActionResult SCK_Switch(string action, string id)
{
string str = " ", query;
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
List <ExcParameters> paramss = new List <ExcParameters>();
ExcParameters parameters = new ExcParameters();
parameters = new ExcParameters()
{
_KEY = "@id_SCOK",
_VALUE = id
};
paramss.Add(parameters);
if (action == "edit")
{
using (DataTable dt = db.Select($"SELECT [id_SCOK],[SCOKName] FROM [tbl_Product_SubCategoryOptionKey] where [id_SCOK]= '{id}'"))
{
model = new TypeASPX()
{
ChangeID = dt.Rows[0]["id_SCOK"].ToString(),
HasChange = true,
ChangeValue = dt.Rows[0]["SCOKName"].ToString()
};
Session["edit_SCK"] = model;
return(RedirectToAction("New_SCK"));
};
}
else if (action == "delete")
{
parameters = new ExcParameters()
{
_KEY = "@value",
_VALUE = "1"
};
paramss.Add(parameters);
query = "UPDATE [tbl_Product_SubCategoryOptionKey] SET [ISDelete] = @value , [DateDeleted] = GETDATE() WHERE id_SCOK= @id_SCOK";
str = db.Script(query, paramss);
}
else if (action == "off")
{
parameters = new ExcParameters()
{
_KEY = "@value",
_VALUE = "1"
};
paramss.Add(parameters);
query = "UPDATE [tbl_Product_SubCategoryOptionKey] SET [ISDESABLED] = @value , [DateDesabled] = GETDATE() WHERE id_SCOK= @id_SCOK";
str = db.Script(query, paramss);
}
else if (action == "on")
{
parameters = new ExcParameters()
{
_KEY = "@value",
_VALUE = "0"
};
paramss.Add(parameters);
query = "UPDATE [tbl_Product_SubCategoryOptionKey] SET [ISDESABLED] = @value , [DateDesabled] = GETDATE() WHERE id_SCOK= @id_SCOK";
str = db.Script(query, paramss);
}
return(RedirectToAction("table_SCK"));
}
public ActionResult Cat_Switch(string action, string id)
{
string str = " ", query;
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
List <ExcParameters> paramss = new List <ExcParameters>();
ExcParameters parameters = new ExcParameters();
parameters = new ExcParameters()
{
_KEY = "@id_MC",
_VALUE = id
};
paramss.Add(parameters);
if (action == "edit")
{
using (DataTable dt = db.Select($"SELECT [id_MC],[MCName]FROM [tbl_Product_MainCategory] where id_MC= '{id}'"))
{
model = new TypeASPX()
{
ChangeID = dt.Rows[0]["id_MC"].ToString(),
HasChange = true,
ChangeValue = dt.Rows[0]["MCName"].ToString()
};
Session["edit_cat"] = model;
return(RedirectToAction("New_Cat"));
};
}
else if (action == "delete")
{
parameters = new ExcParameters()
{
_KEY = "@value",
_VALUE = "1"
};
paramss.Add(parameters);
query = "UPDATE [tbl_Product_MainCategory] SET [ISDelete] = @value , [DateDeleted] = GETDATE() WHERE id_MC = @id_MC";
str = db.Script(query, paramss);
db.Script("UPDATE [tbl_Product]SET[ISDELETE] = 1 WHERE [id_MainCategory]=" + id);
db.Script("UPDATE[tbl_Product_SubCategory] SET[ISDelete] = 1,[DateDeleted] = GETDATE() WHERE [id_MC]=" + id);
db.Script("UPDATE R SET R.ISDelete=1,R.DateDeleted= GETDATE() FROM[tbl_Product_SubCategoryOptionKey]AS R inner Join [tbl_Product_SubCategory] AS P On R.id_SC=P.id_SC where P.id_MC=" + id);
}
else if (action == "off")
{
parameters = new ExcParameters()
{
_KEY = "@value",
_VALUE = "1"
};
paramss.Add(parameters);
query = "UPDATE [dbo].[tbl_Product_MainCategory] SET [ISDESABLED] = @value , [DateDesabled] = GETDATE() WHERE id_MC= @id_MC";
str = db.Script(query, paramss);
db.Script("UPDATE [tbl_Product]SET[IS_AVAILABEL] = 0 WHERE [id_MainCategory]=" + id);
db.Script("UPDATE[tbl_Product_SubCategory] SET[ISDESABLED] = 1,[DateDesabled] = GETDATE() WHERE [id_MC]=" + id);
db.Script("UPDATE R SET R.ISDESABLED=1,R.DateDesabled= GETDATE() FROM[tbl_Product_SubCategoryOptionKey]AS R inner Join [tbl_Product_SubCategory] AS P On R.id_SC=P.id_SC where P.id_MC=" + id);
}
else if (action == "on")
{
parameters = new ExcParameters()
{
_KEY = "@value",
_VALUE = "0"
};
paramss.Add(parameters);
query = "UPDATE [dbo].[tbl_Product_MainCategory] SET [ISDESABLED] = @value , [DateDesabled] = GETDATE() WHERE id_MC= @id_MC";
str = db.Script(query, paramss);
db.Script("UPDATE [tbl_Product]SET[IS_AVAILABEL] = 1 WHERE [id_MainCategory]=" + id);
db.Script("UPDATE[tbl_Product_SubCategory] SET[ISDESABLED] = 0 WHERE [id_MC]=" + id);
db.Script("UPDATE R SET R.DateDesabled=0 FROM[tbl_Product_SubCategoryOptionKey]AS R inner Join [tbl_Product_SubCategory] AS P On R.id_SC=P.id_SC where P.id_MC=" + id);
}
return(RedirectToAction("table_Cat"));
}
public ActionResult Type_Switch(string action, string id)
{
string str = " ", query;
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
List <ExcParameters> paramss = new List <ExcParameters>();
ExcParameters parameters = new ExcParameters();
parameters = new ExcParameters()
{
_KEY = "@id_PT",
_VALUE = id
};
paramss.Add(parameters);
if (action == "edit")
{
using (DataTable dt = db.Select($"SELECT [id_PT],[PTname] FROM [dbo].[tbl_Product_Type] where id_PT= '{id}'"))
{
model = new TypeASPX()
{
ChangeID = dt.Rows[0]["id_PT"].ToString(),
HasChange = true,
ChangeValue = dt.Rows[0]["PTname"].ToString()
};
Session["edit"] = model;
return(RedirectToAction("New_type"));
};
}
else if (action == "delete")
{
parameters = new ExcParameters()
{
_KEY = "@value",
_VALUE = "1"
};
paramss.Add(parameters);
query = "UPDATE [dbo].[tbl_Product_Type] SET [ISDelete] = @value ,[DateDeleted] = GETDATE() WHERE id_PT = @id_PT";
str = db.Script(query, paramss);
db.Script("UPDATE [tbl_Product]SET[ISDELETE] = 1 WHERE [id_Type]=" + id);
}
else if (action == "off")
{
parameters = new ExcParameters()
{
_KEY = "@value",
_VALUE = "1"
};
paramss.Add(parameters);
query = "UPDATE[tbl_Product_Type] SET [ISDESABLED] = @value ,[DateDesabled] = GETDATE() WHERE id_PT = @id_PT";
str = db.Script(query, paramss);
db.Script("UPDATE [tbl_Product]SET[IS_AVAILABEL] = 0 WHERE [id_Type]=" + id);
}
else if (action == "on")
{
parameters = new ExcParameters()
{
_KEY = "@value",
_VALUE = "0"
};
paramss.Add(parameters);
query = "UPDATE[tbl_Product_Type] SET [ISDESABLED] = @value ,[DateDesabled] = GETDATE() WHERE id_PT = @id_PT";
str = db.Script(query, paramss);
db.Script("UPDATE [tbl_Product]SET[IS_AVAILABEL] = 1 WHERE [id_Type]=" + id);
}
return(RedirectToAction("table_Type"));
}
