public int InsertmEngine(mEngine SiteMaster, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));; ce.mEngines.AddObject(SiteMaster); ce.SaveChanges(); return(1); }
public int updatemEngine(mEngine ObjmEngine, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));; ce.mEngines.Attach(ObjmEngine); ce.ObjectStateManager.ChangeObjectState(ObjmEngine, EntityState.Modified); ce.SaveChanges(); return(1); }
protected void pageSave(Object sender, BrilliantWMS.ToolbarService.iUCToolbarClient e) { try { CustomProfile profile = CustomProfile.GetProfile(); mEngine objEngine = new mEngine(); iEngineMasterClient EngineClient = new iEngineMasterClient(); if (hdnEngineId.Value != "") { v_GetEngineDetails obj = new v_GetEngineDetails(); obj = EngineClient.GetmEngineListByID(Convert.ToInt32(hdnEngineId.Value), profile.DBConnection._constr); objEngine.CreatedBy = obj.CreatedBy; objEngine.CreationDate = obj.CreationDate; } else { objEngine.LastModifiedBy = profile.Personal.UserID.ToString(); objEngine.LastModifiedDate = DateTime.Now; } if (ddlSite.SelectedIndex > 0) { objEngine.SiteID = Convert.ToInt32(ddlSite.SelectedItem.Value); } objEngine.Container = null; if (txtContainer.Text.ToString().Trim() != "") { objEngine.Container = txtContainer.Text.ToString(); } objEngine.GeneratorModel = null; if (txtGenratorModel.Text.ToString().Trim() != "") { objEngine.GeneratorModel = txtGenratorModel.Text.ToString(); } objEngine.GeneratorSerial = null; if (txtGenratorSerialNo.Text.ToString().Trim() != "") { objEngine.GeneratorSerial = txtGenratorSerialNo.Text.ToString(); } objEngine.EngineModel = null; if (txtEngineModel.Text.ToString().Trim() != "") { objEngine.EngineModel = txtEngineModel.Text.ToString(); } objEngine.EngineSerial = null; if (txtEngineSerialNo.Text.ToString().Trim() != "") { objEngine.EngineSerial = txtEngineSerialNo.Text.ToString(); } objEngine.EngineSerial = null; if (txtEngineSerialNo.Text.ToString().Trim() != "") { objEngine.EngineSerial = txtEngineSerialNo.Text.ToString(); } objEngine.TransformerSerial = null; if (txtTransformerSerialNo.Text.ToString().Trim() != "") { objEngine.TransformerSerial = txtTransformerSerialNo.Text.ToString(); } if (UC_DateRecived.Date != null) { objEngine.DateRecevied = Convert.ToDateTime(UC_TrasformerDateRecv.Date); } if (UC_TrasformerDateRecv.Date != null) { objEngine.TransformerDateRecevied = Convert.ToDateTime(UC_DateRecived.Date); } objEngine.Remark = null; if (txtRemark.Text.ToString().Trim() != "") { objEngine.Remark = txtRemark.Text.ToString(); } if (hdnEngineId.Value == string.Empty) { objEngine.CreatedBy = profile.Personal.UserID.ToString(); objEngine.CreationDate = DateTime.Now; int result = EngineClient.InsertmEngine(objEngine, profile.DBConnection._constr); if (result == 1) { WebMsgBox.MsgBox.Show("Record saved successfully"); } } else { objEngine.ID = Convert.ToInt64(hdnEngineId.Value); objEngine.LastModifiedBy = profile.Personal.UserID.ToString(); objEngine.LastModifiedDate = DateTime.Now; int result = EngineClient.updatemEngine(objEngine, profile.DBConnection._constr); if (result == 1) { WebMsgBox.MsgBox.Show("Record Update successfully"); } } BindGrid(); clear(); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "Site Master", "pageSave"); } finally { } }