public void UpdateHistory(decimal operCode)
{
DDOPER_MAST ddOperMast = (from c in DB.DDOPER_MAST
where c.OPER_CODE == operCode &&
((Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false) || (c.DELETE_FLAG == null))
select c).SingleOrDefault <DDOPER_MAST>();
try
{
REPL_DDOPER_MAST ddReplHistory = new REPL_DDOPER_MAST();
if (ddOperMast != null)
{
ddReplHistory.OPER_CODE = ddOperMast.OPER_CODE;
ddReplHistory.OPER_DESC = ddOperMast.OPER_DESC;
ddReplHistory.OPTIONAL_OPER = ddOperMast.OPTIONAL_OPER;
ddReplHistory.TAG_APPREVIATION = ddOperMast.TAG_APPREVIATION;
ddReplHistory.SHOW_IN_COST = ddOperMast.SHOW_IN_COST;
ddReplHistory.FLAG = "D";
ddReplHistory.UPDATEON = DateTime.Now;
DB.REPL_DDOPER_MAST.InsertOnSubmit(ddReplHistory);
}
}
catch (Exception ex)
{
ex.LogException();
DB.DDOPER_MAST.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, ddOperMast);
}
}
public bool DeletOperCode(decimal operCode, string nextAction, ref string message)
{
DDOPER_MAST ddOperMast = (from c in DB.DDOPER_MAST
where c.OPER_CODE == operCode
// && ((Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false) || (c.DELETE_FLAG == null))
select c).SingleOrDefault <DDOPER_MAST>();
try
{
// UpdateHistory(operCode);
if (nextAction == "DELETE")
{
if (ddOperMast != null)
{
if (ddOperMast.DELETE_FLAG == true)
{
ddOperMast.DELETE_FLAG = false;
}
else
{
ddOperMast.DELETE_FLAG = true;
}
ddOperMast.UPDATED_DATE = DateTime.Now;
ddOperMast.UPDATED_BY = userInformation.UserName;
DB.SubmitChanges();
//DB.Refresh(System.Data.Linq.RefreshMode.KeepChanges, ddOperMast);
DB.DDOPER_MAST.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, ddOperMast);
//ddOperMast.OPER_CODE = operCode;
//DB.DDOPER_MAST.DeleteOnSubmit(ddOperMast);
//DB.SubmitChanges();
message = PDMsg.DeletedSuccessfully;
}
else if (ddOperMast == null)
{
message = PDMsg.NoRecordFound;
}
}
}
catch (System.Data.Linq.ChangeConflictException)
{
DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.KeepChanges);
}
catch (Exception ex)
{
ex.LogException();
DB.DDOPER_MAST.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, ddOperMast);
}
return(true);
}
public bool CheckOperCodeEsxists(decimal operCode)
{
try
{
DDOPER_MAST ddOperMast = (from c in DB.DDOPER_MAST
where c.OPER_CODE == operCode &&
((Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false) || (c.DELETE_FLAG == null))
select c).SingleOrDefault <DDOPER_MAST>();
if (ddOperMast != null)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
// throw ex.LogException();
ex.LogException();
return(false);
}
}
public bool AddNewOperationMaster(bool isActive, decimal operCode, string operDesc, string showInCost, string nextAction, ref string message)
{
bool _status = false;
DDOPER_MAST ddOperMast = (from c in DB.DDOPER_MAST
//where (c.OPER_CODE == operCode || operDesc.ToUpper().Replace(" ", "") == c.OPER_DESC.ToUpper().Replace(" ", ""))
where (c.OPER_CODE == operCode)
// && ((Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false) || (c.DELETE_FLAG == null))
select c).FirstOrDefault <DDOPER_MAST>();
try
{
string mode = "";
if (nextAction == "DELETE")
{
nextAction = "EDIT";
}
if (nextAction == "ADD")
{
if (ddOperMast == null)
{
ddOperMast = new DDOPER_MAST();
mode = "New";
ddOperMast.OPER_CODE = (decimal)operCode;
ddOperMast.OPER_DESC = (string)operDesc;
ddOperMast.DELETE_FLAG = isActive;
ddOperMast.ENTERED_DATE = DateTime.Now;
ddOperMast.ENTERED_BY = userInformation.UserName;
if (string.IsNullOrEmpty(showInCost))
{
ddOperMast.SHOW_IN_COST = "0";
}
else
{
ddOperMast.SHOW_IN_COST = showInCost;
}
ddOperMast.ROWID = Guid.NewGuid();
DB.DDOPER_MAST.InsertOnSubmit(ddOperMast);
DB.SubmitChanges();
message = PDMsg.SavedSuccessfully;
}
else
{
message = PDMsg.AlreadyExists("Operation Code");
return(false);
////----- Check Delete Flag
//if (ddOperMast.DELETE_FLAG != true)
//{
// ddOperMast.OPER_DESC = operDesc;
// ddOperMast.SHOW_IN_COST = showInCost;
// ddOperMast.DELETE_FLAG = isActive;
// ddOperMast.UPDATED_DATE = DateTime.Now;
// ddOperMast.UPDATED_BY = userInformation.UserName;
// DB.SubmitChanges();
// message = PDMsg.SavedSuccessfully;
//}
//else
//{
// //if (CheckOperCodeEsxists(operCode) == true)
// //{
// // message = PDMsg.AlreadyExists("Operation Code");
// // return false;
// //}
// //else
// //{
// message = PDMsg.AlreadyExists("Operation Code");
// return false;
// // }
//}
//
}
}
else if (nextAction == "EDIT")
{
ddOperMast.OPER_DESC = operDesc;
ddOperMast.SHOW_IN_COST = showInCost;
ddOperMast.DELETE_FLAG = isActive;
ddOperMast.UPDATED_DATE = DateTime.Now;
ddOperMast.UPDATED_BY = userInformation.UserName;
DB.SubmitChanges();
message = PDMsg.UpdatedSuccessfully;
}
_status = true;
}
catch (Exception ex)
{
if (nextAction == "ADD")
{
DB.DDOPER_MAST.DeleteOnSubmit(ddOperMast);
}
else if (nextAction == "EDIT")
{
DB.DDOPER_MAST.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, ddOperMast);
}
ex.LogException();
}
return(_status);
}
