public bool InsertBK_Product(BK_ProductInfo pinfo)
{
try
{
using (RMSDataContext db = new RMSDataContext())
{
BK_Product tbl = new BK_Product();
Guid pid = Guid.NewGuid();
tbl.BK_ProductID = pid.ToString();
tbl.BK_ProductName = pinfo.BK_ProductName;
tbl.CategoryID = pinfo.CategoryID;
tbl.UMID = "48ec165d-d28e-4354-94d7-40636daa7d4f";
tbl.BK_Price = 100.00m;
tbl.InsertedDate = DateTime.UtcNow.AddMinutes(390).Date;
tbl.UpdatedDate = DateTime.UtcNow.AddMinutes(390).Date;
db.BK_Products.InsertOnSubmit(tbl);
db.SubmitChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public List <BK_ProductInfo> SelectallBKProductinfo()
{
try
{
List <BK_ProductInfo> lstpinfo = new List <BK_ProductInfo>();
using (RMSDataContext db = new RMSDataContext())
{
BK_ProductInfo pinfo;
var b = (from c in db.BK_Products select c).ToList();
foreach (var obj in b)
{
pinfo = new BK_ProductInfo();
pinfo.BK_ProductID = obj.BK_ProductID;
pinfo.BK_ProductName = obj.BK_ProductName;
pinfo.BK_Price = obj.BK_Price;
pinfo.CategoryID = obj.CategoryID;
pinfo.UMID = obj.UMID;
//pinfo.InsertedDate = obj.InsertedDate;
//pinfo.UpdatedDate = obj.UpdatedDate;
lstpinfo.Add(pinfo);
}
return(lstpinfo);
}
}
catch (Exception ex)
{
return(new List <BK_ProductInfo>());
}
}
public void productInsertbyList()
{
BK_ProductController bcon = new BK_ProductController();
List <BK_ProductInfo> blist = new List <BK_ProductInfo>();
BK_ProductInfo bin;
List <string> slist = new List <string>();
for (int i = 0; i < TextBoxCountSec; i++)
{
//HtmlGenericControl g = new HtmlGenericControl();
var g = (HtmlInputText)appendtextbox1.FindControl("txtDynamicSec" + i.ToString());
if (!string.IsNullOrEmpty(g.Value))
{
bin = new BK_ProductInfo();
bin.BK_ProductName = g.Value;
bin.CategoryID = lblCategory.Text;
blist.Add(bin);
}
}
if (blist.Count > 0)
{
bcon.InsertBK_ProductByList(blist);
string msg = "if (Notification.permission === 'granted') { var notify = new Notification('New Category Items' , { body: '" + blist.Count + "',icon: '',} )}" +
"else {" +
"Notification.requestPermission().then(function (p) {" +
" if (p === 'granted') {" +
" var notify = new Notification('New Category Items'+ Msg, {" +
" body: '" + blist.Count + " Category Items Added !'," +
" icon: ''," +
" });" +
" } else {" +
" console.log('User blocked notifications.');" +
" }" +
" }).catch(function (err) {" +
" console.error(err);" +
" });" +
"};";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Alert Message", msg, true);
removecontrol1();
//rptMainList.DataSource = con.SelectAllCategoryInfo();
//rptMainList.DataBind();
}
removecontrol1();
}
public bool InsertBK_Product(BK_ProductInfo pinfo)
{
dao = new BK_ProductDAO();
return(dao.InsertBK_Product(pinfo));
}
