public bool AddEditCategory(CategoryMaterModel catemodel, ref string mode)
{
bool _status = false;
DDCATE_MAST cate = new DDCATE_MAST();
try
{
cate = (from c in DB.DDCATE_MAST
where c.CATE_CODE == catemodel.CateCode.ToValueAsString()
select c).FirstOrDefault <DDCATE_MAST>();
if (cate == null)
{
try
{
cate = new DDCATE_MAST();
cate.CATE_CODE = catemodel.CateCode.ToString();
cate.CATEGORY = catemodel.Category;
cate.ENTERED_DATE = DateTime.Now;
cate.ENTERED_BY = userInformation.UserName;
cate.DELETE_FLAG = catemodel.Active;
cate.ROWID = Guid.NewGuid();
DB.DDCATE_MAST.InsertOnSubmit(cate);
DB.SubmitChanges();
mode = "Add";
return(true);
}
catch (Exception e)
{
e.LogException();
DB.DDCATE_MAST.DeleteOnSubmit(cate);
}
}
else
{
try
{
cate.CATEGORY = catemodel.Category;
cate.UPDATED_DATE = DateTime.Now;
cate.UPDATED_BY = userInformation.UserName;
cate.DELETE_FLAG = catemodel.Active;
DB.SubmitChanges();
mode = "Update";
return(true);
}
catch (Exception e)
{
e.LogException();
DB.DDCATE_MAST.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, cate);
}
}
}
catch (Exception e)
{
throw e.LogException();
}
return(_status);
}
public bool DeletePswApplication(string category)
{
DDCATE_MAST cate = new DDCATE_MAST();
try
{
cate = (from c in DB.DDCATE_MAST
where c.CATEGORY == category// && ((Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false) || (c.DELETE_FLAG == null))
select c).FirstOrDefault <DDCATE_MAST>();
if (cate != null)
{
if (cate.DELETE_FLAG == true)
{
cate.DELETE_FLAG = false;
}
else
{
cate.DELETE_FLAG = true;
}
//ddPswTitle.DELETE_FLAG = true;
cate.UPDATED_DATE = DateTime.Now;
cate.UPDATED_BY = userInformation.UserName;
DB.SubmitChanges();
return(true);
}
else if (cate == null)
{
return(false);
}
}
catch (System.Data.Linq.ChangeConflictException)
{
// DB.PSW_WAR_TITLE.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, ddPswTitle);
DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.KeepChanges);
}
catch (Exception ex)
{
ex.LogException();
DB.DDCATE_MAST.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, cate);
}
return(true);
}
