public int InsertmProductUOM(mUOM prdUOM, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.mUOMs.AddObject(prdUOM);
ce.SaveChanges();
return(1);
}
public int updatemProductUOM(mUOM updatePrdUOM, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.mUOMs.Attach(updatePrdUOM);
ce.ObjectStateManager.ChangeObjectState(updatePrdUOM, EntityState.Modified);
ce.SaveChanges();
return(1);
}
public mUOM GetProductUOMListByID(int prdUOMId, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
mUOM ProductUOMID = new mUOM();
ProductUOMID = (from p in ce.mUOMs
where p.ID == prdUOMId
select p).FirstOrDefault();
ce.Detach(ProductUOMID);
return(ProductUOMID);
}
protected void pageSave(Object sender, BrilliantWMS.ToolbarService.iUCToolbarClient e)
{
try
{
CustomProfile profile = CustomProfile.GetProfile();
if (checkDuplicate() == "")
{
mUOM ObjPrdUOM = new mUOM();
if (hdnPrdUOMID.Value == string.Empty)
{
ObjPrdUOM.Name = TxtUOM.Text.Trim();
if (TxtSequence.Text != string.Empty)
{
ObjPrdUOM.Sequence = Convert.ToInt64(TxtSequence.Text);
}
else
{
ObjPrdUOM.Sequence = 0;
}
if (rbtnYes.Checked == true)
{
ObjPrdUOM.Active = "Y";
}
else
{
ObjPrdUOM.Active = "N";
}
ObjPrdUOM.CreatedBy = profile.Personal.UserID.ToString();
ObjPrdUOM.CreationDate = DateTime.Now;
ObjPrdUOM.CompanyID = profile.Personal.CompanyID;
int result = ProductUOMClient.InsertmProductUOM(ObjPrdUOM, profile.DBConnection._constr);
if (result == 1)
{
WebMsgBox.MsgBox.Show("Record saved successfully");
}
BindGrid();
clear();
}
else
{
ObjPrdUOM = ProductUOMClient.GetProductUOMListByID(Convert.ToInt32(hdnPrdUOMID.Value), profile.DBConnection._constr);
ObjPrdUOM.Name = TxtUOM.Text.Trim();
if (TxtSequence.Text != string.Empty)
{
ObjPrdUOM.Sequence = Convert.ToInt64(TxtSequence.Text);
}
else
{
ObjPrdUOM.Sequence = 0;
}
if (rbtnYes.Checked == true)
{
ObjPrdUOM.Active = "Y";
}
else
{
ObjPrdUOM.Active = "N";
}
ObjPrdUOM.LastModifiedBy = profile.Personal.UserID.ToString();
ObjPrdUOM.LastModifiedDate = DateTime.Now;
int result = ProductUOMClient.updatemProductUOM(ObjPrdUOM, profile.DBConnection._constr);
if (result == 1)
{
WebMsgBox.MsgBox.Show("Record updated successfully");
}
BindGrid();
clear();
}
}
}
catch (System.Exception ex)
{
Login.Profile.ErrorHandling(ex, this, "Product UOM Master", "pageSave");
}
finally
{
}
}
