public object DeleteTemplateMaster(TemplateMasterParam TP)
{
try
{
TblTemplatesMaster objTemplate = db.TblTemplatesMasters.Where(r => r.TemplateId == TP.TemplateId).FirstOrDefault();
if (objTemplate.Status == 1)
{
objTemplate.Status = 0;
}
else
{
objTemplate.Status = 1;
}
db.SaveChanges();
if (objTemplate.Status == 1)
{
return(new Result()
{
IsSucess = true, ResultData = "Template Master Activated Successfully!"
});
}
else
{
return(new Result()
{
IsSucess = true, ResultData = "Template Master De-Activated Successfully!"
});
}
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public object SaveTemplateMaster(TemplateMasterParam TP)
{
try
{
TblTemplatesMaster objTemplate = new TblTemplatesMaster();
string msg = "";
if (TP.BtnStatus == "Save")
{
var usercode = db.TblTemplatesMasters.Where(r => r.Name == TP.Name.ToUpper()).FirstOrDefault();
if (usercode != null)
{
return(new Error()
{
IsError = true, Message = "Template Name Already Exists!"
});
}
objTemplate.Name = TP.Name.ToUpper();
objTemplate.TemplateTypeId = TP.TemplateTypeId;
objTemplate.CreatedBy = TP.CreatedBy;
objTemplate.CreatedDate = DateTime.Now;
objTemplate.Status = 1;
db.TblTemplatesMasters.Add(objTemplate);
db.SaveChanges();
TblTemplateModule objTemplateModule = new TblTemplateModule();
string MenuIds = TP.MenuListIds.Trim(',');
string[] ids = MenuIds.Split(',');
for (int i = 0; i < ids.Length; i++)
{
objTemplateModule.TemplateId = objTemplate.TemplateId;
objTemplateModule.ModuleId = Convert.ToInt32(ids[i]);
objTemplateModule.CreatedBy = TP.CreatedBy;
objTemplateModule.CreatedDate = DateTime.Now;
objTemplateModule.Status = 1;
db.TblTemplateModules.Add(objTemplateModule);
db.SaveChanges();
}
msg = "Template Master Saved Successfully!";
}
else
{
TblTemplatesMaster objTempalte = db.TblTemplatesMasters.Where(r => r.TemplateId == TP.TemplateId).FirstOrDefault();
objTempalte.Name = TP.Name.ToUpper();
objTempalte.TemplateId = TP.TemplateId;
objTempalte.ModifiedBy = TP.ModifiedBy;
objTempalte.ModifiedDate = DateTime.Now;
objTempalte.TemplateTypeId = TP.TemplateTypeId;
db.SaveChanges();
db.TblTemplateModules.RemoveRange(db.TblTemplateModules.Where(c => c.TemplateId == TP.TemplateId));
db.SaveChanges();
TblTemplateModule objTemplateModule = new TblTemplateModule();
string MenuIds = TP.MenuListIds.Trim(',');
string[] ids = MenuIds.Split(',');
for (int i = 0; i < ids.Length; i++)
{
objTemplateModule.TemplateId = TP.TemplateId;
objTemplateModule.ModuleId = Convert.ToInt32(ids[i]);
objTemplateModule.CreatedBy = TP.CreatedBy;
objTemplateModule.CreatedDate = DateTime.Now;
objTemplateModule.Status = 1;
db.TblTemplateModules.Add(objTemplateModule);
db.SaveChanges();
}
msg = "Template Master Updated Successfully!";
}
return(new Result()
{
IsSucess = true, ResultData = msg
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
