public bool DeleteCpmTitle(string dept, string member)
{
CONTROL_PLAN_MEMBER ddCpmMaster = new CONTROL_PLAN_MEMBER();
try
{
ddCpmMaster = (from c in DB.CONTROL_PLAN_MEMBER
where c.DEPT == dept && c.MEMBER == member
// && ((Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false) || (c.DELETE_FLAG == null))
select c).FirstOrDefault <CONTROL_PLAN_MEMBER>();
if (ddCpmMaster != null)
{
if (ddCpmMaster.DELETE_FLAG == true)
{
ddCpmMaster.DELETE_FLAG = false;
}
else
{
ddCpmMaster.DELETE_FLAG = true;
}
ddCpmMaster.UPDATED_DATE = DateTime.Now;
ddCpmMaster.UPDATED_BY = userInformation.UserName;
DB.SubmitChanges();
return(true);
}
else if (ddCpmMaster == null)
{
return(false);
}
}
catch (System.Data.Linq.ChangeConflictException)
{
DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.KeepChanges);
}
catch (Exception ex)
{
throw ex.LogException();
}
return(true);
}
public bool SaveCpmMaster(CPMMasterModel cpm, string dept, string member, decimal sno, ref string typ)
{
CONTROL_PLAN_MEMBER ddCpm = new CONTROL_PLAN_MEMBER();
bool _status = false;
try
{
ddCpm = (from c in DB.CONTROL_PLAN_MEMBER
where c.DEPT == dept && c.SNO == sno
// && ((Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false) || (c.DELETE_FLAG == null))
select c).FirstOrDefault <CONTROL_PLAN_MEMBER>();
if (ddCpm == null)
{
try
{
ddCpm = new CONTROL_PLAN_MEMBER();
ddCpm.DEPT = dept;
ddCpm.MEMBER = member;
ddCpm.LOCATION = string.Empty;
ddCpm.SNO = sno;
ddCpm.DELETE_FLAG = cpm.IsActive;
ddCpm.ENTERED_DATE = DateTime.Now;
ddCpm.ENTERED_BY = userInformation.UserName;
ddCpm.ROWID = Guid.NewGuid();
DB.CONTROL_PLAN_MEMBER.InsertOnSubmit(ddCpm);
DB.SubmitChanges();
typ = "INS";
return(true);
}
catch (Exception ex)
{
ex.LogException();
DB.CONTROL_PLAN_MEMBER.DeleteOnSubmit(ddCpm);
}
}
else
{
try
{
ddCpm.DEPT = dept;
ddCpm.MEMBER = member;
ddCpm.LOCATION = string.Empty;
ddCpm.DELETE_FLAG = cpm.IsActive;
ddCpm.UPDATED_DATE = DateTime.Now;
ddCpm.UPDATED_BY = userInformation.UserName;
DB.SubmitChanges();
typ = "UPD";
return(true);
}
catch (Exception ex)
{
ex.LogException();
DB.CONTROL_PLAN_MEMBER.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, ddCpm);
}
}
}
catch (System.Data.Linq.ChangeConflictException)
{
DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.KeepChanges);
}
catch (Exception ex)
{
ex.LogException();
DB.CONTROL_PLAN_MEMBER.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, ddCpm);
}
return(_status);
}