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);
        }
Пример #3
0
        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
            {
            }
        }