public bool DeletUnitCode(string operCode, string nextAction, ref string message) { DDUNIT_MAST ddUnitMaster = (from c in DB.DDUNIT_MAST where c.UNIT_CODE == operCode //&& ((Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false) || (c.DELETE_FLAG == null)) select c).SingleOrDefault <DDUNIT_MAST>(); try { if (nextAction == "DELETE") { if (ddUnitMaster != null) { if (ddUnitMaster.DELETE_FLAG == true) { ddUnitMaster.DELETE_FLAG = false; } else { ddUnitMaster.DELETE_FLAG = true; } // ddUnitMaster.DELETE_FLAG = true; ddUnitMaster.UPDATED_DATE = DateTime.Now; ddUnitMaster.UPDATED_BY = userInformation.UserName; DB.SubmitChanges(); // ddUnitMaster.UNIT_CODE = operCode; // DB.DDUNIT_MAST.DeleteOnSubmit(ddUnitMaster); DB.SubmitChanges(); message = PDMsg.DeletedSuccessfully; } else if (ddUnitMaster == null) { message = PDMsg.NoRecordFound; } } } catch (Exception ex) { ex.LogException(); DB.DDUNIT_MAST.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, ddUnitMaster); } return(true); }
public bool CheckUnitEsxistsDesc(string operCode, string operDesc) { try { DDUNIT_MAST ddUnitMaster = (from c in DB.DDUNIT_MAST where c.UNIT_CODE != operCode && c.UNIT_OF_MEAS == operDesc // && ((Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false) || (c.DELETE_FLAG == null)) select c).FirstOrDefault <DDUNIT_MAST>(); if (ddUnitMaster != null) { return(true); } else { return(false); } } catch (Exception ex) { ex.LogException(); return(false); } }
public bool AddNewUnitMaster(bool isActive, string operCode, string operDesc, string showInCost, string nextAction, ref string message) { bool _status = false; DDUNIT_MAST dduUnitMaster = (from c in DB.DDUNIT_MAST where (c.UNIT_CODE == operCode || operDesc.ToUpper() == c.UNIT_OF_MEAS.ToUpper()) // where c.UNIT_CODE == operCode // && ((Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false) || (c.DELETE_FLAG == null)) select c).FirstOrDefault <DDUNIT_MAST>(); try { if (nextAction == "DELETE") { nextAction = "EDIT"; } if (nextAction == "ADD") { if (dduUnitMaster == null) { dduUnitMaster = new DDUNIT_MAST(); dduUnitMaster.UNIT_CODE = (string)operCode; dduUnitMaster.UNIT_OF_MEAS = (string)operDesc; dduUnitMaster.DELETE_FLAG = isActive; dduUnitMaster.ENTERED_DATE = DateTime.Now; dduUnitMaster.ENTERED_BY = userInformation.UserName; dduUnitMaster.ROWID = Guid.NewGuid(); DB.DDUNIT_MAST.InsertOnSubmit(dduUnitMaster); DB.SubmitChanges(); message = PDMsg.SavedSuccessfully; } else { if (CheckUnitEsxists(operCode) == true) { message = PDMsg.AlreadyExists("Unit Code"); return(false); } else { message = PDMsg.AlreadyExists("Unit Desc"); return(false); } //if (dduUnitMaster.DELETE_FLAG != true) //{ // dduUnitMaster.UNIT_OF_MEAS = (string)operDesc; // dduUnitMaster.UPDATED_DATE = DateTime.Now; // dduUnitMaster.DELETE_FLAG = isActive; // dduUnitMaster.UPDATED_BY = userInformation.UserName; // DB.SubmitChanges(); // message = PDMsg.SavedSuccessfully; //} //else //{ // if (CheckUnitEsxists(operCode) == true) // { // message = PDMsg.AlreadyExists("Unit Code"); // return false; // } // else // { // message = PDMsg.AlreadyExists("Unit Desc"); // return false; // } //} // message = "Finish Code already Exists"; // return false; } } else if (nextAction == "EDIT") { if (CheckUnitEsxistsDesc(operCode, operDesc) == true) { message = PDMsg.AlreadyExists("Unit Desc"); return(false); } dduUnitMaster.UNIT_OF_MEAS = (string)operDesc; dduUnitMaster.UPDATED_DATE = DateTime.Now; dduUnitMaster.DELETE_FLAG = isActive; dduUnitMaster.UPDATED_BY = userInformation.UserName; DB.SubmitChanges(); message = PDMsg.UpdatedSuccessfully; } _status = true; } catch (Exception ex) { ex.LogException(); if (nextAction == "ADD") { DB.DDUNIT_MAST.DeleteOnSubmit(dduUnitMaster); } else if (nextAction == "EDIT") { DB.DDUNIT_MAST.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, dduUnitMaster); } } return(_status); }