public object SaveTemplateType(TemplateTypeParam TP)
{
try
{
string msg = "";
if (TP.BtnStatus == "Save")
{
var usercode = db.TblTemplateTypeMasters.Where(r => r.TemplateType == TP.TemplateType.ToUpper()).FirstOrDefault();
if (usercode != null)
{
return(new Error()
{
IsError = true, Message = "Template Type Name is Already Exists!"
});
}
TblTemplateTypeMaster objTemplate = new TblTemplateTypeMaster();
objTemplate.TemplateType = TP.TemplateType.ToUpper();
objTemplate.CreatedBy = TP.CreatedBy;
objTemplate.CreatedDate = DateTime.Now;
objTemplate.Status = 1;
db.TblTemplateTypeMasters.Add(objTemplate);
db.SaveChanges();
msg = "Template Type Saved Successfully!";
}
else
{
TblTemplateTypeMaster objTempalte = db.TblTemplateTypeMasters.Where(r => r.TemplateTypeId == TP.TemplateTypeId).FirstOrDefault();
var Data = db.TblTemplateTypeMasters.Where(r => r.TemplateType == TP.TemplateType && r.TemplateTypeId == TP.TemplateTypeId).FirstOrDefault();
if (Data == null)
{
return(new Error()
{
IsError = true, Message = "Duplicate Entry Not Allowed"
});
}
objTempalte.TemplateType = TP.TemplateType.ToUpper();
objTempalte.ModifiedBy = TP.ModifiedBy;
objTempalte.ModifiedDate = DateTime.Now;
objTempalte.TemplateTypeId = TP.TemplateTypeId;
db.SaveChanges();
msg = "Template Type Updated Successfully!";
}
return(new Result()
{
IsSucess = true, ResultData = msg
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public object SaveModule(ModuleParam MP)
{
try
{
string msg = "";
if (MP.BtnStatus == "Save")
{
var usercode = db.TblModuleMasters.Where(r => r.ModuleName == MP.ModuleName.ToUpper()).FirstOrDefault();
if (usercode != null)
{
return(new Error()
{
IsError = true, Message = "Module Name Already Exists!"
});
}
TblModuleMaster objModule = new TblModuleMaster();
objModule.ModuleName = MP.ModuleName.ToUpper();
objModule.ModuleOrder = MP.ModuleOrder;
objModule.CreatedBy = MP.CreatedBy;
objModule.CreatedDate = DateTime.Now;
objModule.ParentModuleId = 0;
objModule.Status = 1;
db.TblModuleMasters.Add(objModule);
db.SaveChanges();
msg = "Module Saved Successfully!";
}
else
{
TblModuleMaster objModule = db.TblModuleMasters.Where(r => r.ModuleId == MP.ModuleId).FirstOrDefault();
objModule.ModuleName = MP.ModuleName.ToUpper();
objModule.ModuleOrder = MP.ModuleOrder;
objModule.ModifiedDate = DateTime.Now;
objModule.ModuleId = MP.ModuleId;
db.SaveChanges();
msg = "Module Updated Successfully!";
}
return(new Result()
{
IsSucess = true, ResultData = msg
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public object SaveDivision(DivisionParam DivParam)
{
Tbl_Division_Master obj = new Tbl_Division_Master();
obj.DivisionName = DivParam.DivisionName;
obj.CreatedBy = 1;
obj.CreatedDate = DateTime.Now;
obj.ModifiedBy = null;
obj.ModifiedDate = null;
obj.Status = 1;
db.Tbl_Division_Master.Add(obj);
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Division Save Successfully"
});
}
public object AddStandard(StandardParam StdParam)
{
Tbl_StandardMaster obj = new Tbl_StandardMaster();
obj.StandardName = StdParam.StandardName;
obj.Status = 1;
obj.CreatedBy = 1;
obj.CreatedDate = System.DateTime.Today.Date;
obj.ModifiedBy = null;
obj.ModifiedDate = null;
db.Tbl_StandardMaster.Add(obj);
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Standard Save Successfully"
});
}
public object SaveWidget(WidgetParam b)
{
if (b.WidgetName == null)
{
return(new Error()
{
IsError = true, Message = "Required WidgetName"
});
}
var data = db.Tbl_Widget_Master.FirstOrDefault(r => r.WidgetName == b.WidgetName);
if (data != null)
{
return(new Error()
{
IsError = true, Message = "Duplicate Entry Not Allowed"
});
}
try
{
Tbl_Widget_Master obj = new Tbl_Widget_Master();
obj.WidgetName = b.WidgetName;
obj.ActionName = b.ActionName;
obj.Status = 1;
obj.CreatedBy = 1;
obj.CreatedDate = System.DateTime.Today.Date;
obj.ModifiedBy = null;
obj.ModifiedDate = System.DateTime.Today.Date;
db.Tbl_Widget_Master.Add(obj);
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Widget Created Successfully!"
});
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object SaveSubject(SubjectParam ObjParam)
{
try
{
var Duplicate = db.Tbl_Subject_Master.SingleOrDefault(r => r.SubjectName == ObjParam.SubjectName && r.SubjectCode == ObjParam.SubjectCode);
if (Duplicate != null)
{
return(new Result()
{
IsSucess = true, ResultData = "Duplicate Entry Not Allowed"
});
}
else
{
Tbl_Subject_Master obj = new Tbl_Subject_Master();
obj.SubjectName = ObjParam.SubjectName;
obj.SubjectCode = ObjParam.SubjectCode;
obj.Status = 1;
obj.CreatedBy = 1;
obj.ModifiedBy = null;
obj.ModifiedDate = null;
obj.CreatedDate = DateTime.Now;
db.Tbl_Subject_Master.Add(obj);
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Subject Save Successfully"
});
}
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = "Error"
});
}
}
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
});
}
}
public object SaveSchool(School school)
{
if (school.UserName == null)
{
return(new Error()
{
IsError = true, Message = "Required Username"
});
}
TblSchool obj = new TblSchool();
var httpRequest = HttpContext.Current.Request;
if (httpRequest.Files.Count > 0)
{
string UploadBaseUrl = ConfigurationManager.AppSettings["UploadBaseURL"];
string fileName = string.Empty;
var filePath = string.Empty;
string savePath = string.Empty;
foreach (string file in httpRequest.Files)
{
var postedFile = httpRequest.Files[file];
fileName = postedFile.FileName;
filePath = ConfigurationManager.AppSettings["UploadDir"] + Guid.NewGuid() + fileName;
savePath = HttpContext.Current.Server.MapPath(filePath); postedFile.SaveAs(savePath);
obj.SchoolName = school.SchoolName;
obj.PhoneNo = school.PhoneNo;
obj.Address = school.Address;
obj.ContactPerson = school.ContactPerson;
obj.LandlineNo = school.LandlineNo;
obj.EmailId = school.EmailId;
obj.Designation = school.Designation;
obj.ValidityStartDate = school.ValidityStartDate;
obj.ValidityEndDate = school.ValidityEndDate;
obj.PayrollTemplateId = school.PayrollTemplateId;
obj.FeeTemplateId = school.FeeTemplateId;
obj.LoginTemplateId = school.LoginTemplateId;
obj.ExamTemplateId = school.ExamTemplateId;
obj.CreatedBy = 1;
obj.CreatedDate = school.CreatedDate;
obj.ModifiedBy = 1;
obj.ModifiedDate = school.ModifiedDate;
obj.UserPrefix = school.UserPrefix;
obj.UserName = school.UserName;
obj.Password = school.Password;
obj.BoardId = school.BoardId;
obj.Language = school.Language;
obj.Logo = UploadBaseUrl + filePath.Replace("~/", "");
obj.Banner = school.Banner;
obj.Status = 1;
db.TblSchools.Add(obj);
db.SaveChanges();
}
}
//user.code = Convert.ToInt32(HttpContext.Current.Session["Code"]);
return(new Result
{
IsSucess = true,
ResultData = "School Created!"
});
}
public object SaveMenu(ModuleParam PM)
{
try
{
if (PM.BtnStatus == "Save")
{
if (PM.ModuleName == null)
{
return(new Error()
{
IsError = true, Message = "Please Enter Menu Name !!"
});
}
TblModuleMaster objuser = new TblModuleMaster();
var result = db.TblModuleMasters.FirstOrDefault(r => r.ModuleName == PM.ModuleName.ToUpper());
if (result != null)
{
return(new Error()
{
IsError = true, Message = "Menu with Same Name Already Exists !!"
});
}
if (PM.ParentMenuId == 0)
{
objuser.ParentModuleId = PM.ModuleId;
}
else
{
objuser.ParentModuleId = PM.ParentMenuId;
}
objuser.ModuleName = PM.ModuleName.ToUpper();
objuser.ModuleOrder = Convert.ToInt64(PM.ModuleOrder);
objuser.Status = 1;
objuser.ActionName = PM.ActionName;
objuser.CreatedDate = DateTime.Now;
db.TblModuleMasters.Add(objuser);
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Menu Added Successfully."
});
}
else
{
TblModuleMaster obGR = db.TblModuleMasters.Where(r => r.ModuleId == PM.ModuleId).FirstOrDefault();
obGR.ModuleName = PM.ModuleName;
obGR.ParentModuleId = PM.ParentMenuId;
obGR.ModuleOrder = Convert.ToInt64(PM.ModuleOrder);
obGR.ActionName = PM.ActionName;
obGR.ModifiedBy = PM.ModifiedBy;
obGR.ModifiedDate = DateTime.Now;
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Menu Updated Successfully."
});
}
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object SaveSchool(School s)
{
try
{
var Logo = System.Web.HttpContext.Current.Request.Files["file"];
var Banner = System.Web.HttpContext.Current.Request.Files["file1"];
var json1 = System.Web.HttpContext.Current.Request.Form["id"];
var json = System.Web.HttpContext.Current.Request.Form["data"];
School school = Newtonsoft.Json.JsonConvert.DeserializeObject <School>(json);
//var boardid = json1.Replace(",", "");
if (school.UserName == null)
{
return(new Error()
{
IsError = true, Message = "Required Username"
});
}
var info = db.TblSchools.FirstOrDefault(r => r.SchoolName == school.SchoolName);
if (info != null)
{
return(new Error()
{
IsError = true, Message = "Duplicate Entry Not Allowed"
});
}
TblSchool obj = new TblSchool();
var httpRequest = HttpContext.Current.Request;
string UploadBaseUrl = ConfigurationManager.AppSettings["UploadBaseURL"];
string fileLogo = string.Empty;
string fileBanner = string.Empty;
var filePath = string.Empty;
string savePath = string.Empty;
var filePathBanner = string.Empty;
var filePathSave = string.Empty;
var Upload = school.SchoolName;
obj.SchoolName = school.SchoolName;
obj.PhoneNo = school.PhoneNo;
obj.Address = school.Address;
obj.ContactPerson = school.ContactPerson;
obj.LandlineNo = school.LandlineNo;
obj.EmailId = school.EmailId;
obj.Designation = school.Designation;
obj.ValidityStartDate = school.ValidityStartDate;
obj.ValidityEndDate = school.ValidityEndDate;
obj.PayrollTemplateId = school.PayrollTemplateId;
obj.FeeTemplateId = school.FeeTemplateId;
obj.LoginTemplateId = school.LoginTemplateId;
obj.ExamTemplateId = school.ExamTemplateId;
obj.CreatedBy = 1;
obj.CreatedDate = System.DateTime.Today.Date;
obj.ModifiedBy = 1;
obj.ModifiedDate = System.DateTime.Today.Date;
obj.UserPrefix = school.UserPrefix;
obj.UserName = school.UserName;
obj.Password = school.Password;
obj.Language = school.Language;
obj.Status = 1;
var uploaddirc = Path.Combine(HttpContext.Current.Server.MapPath("/"), "SchoolUpload" + ("\\"));
if (!Directory.Exists(uploaddirc))
{
DirectoryInfo di = Directory.CreateDirectory(uploaddirc);
}
string paths = "SchoolUpload";
for (int i = 0; i < httpRequest.Files.Count; i++)
{
var uploadpath = Path.Combine(HttpContext.Current.Server.MapPath("/"), paths, Upload.ToString() + ("\\"));
if (!Directory.Exists(uploadpath))
{
DirectoryInfo di = Directory.CreateDirectory(uploadpath);
}
if (i == 0 && Logo != null)
{
var file = httpRequest.Files[i];
var Guids = Guid.NewGuid();
filePathSave = uploadpath + Guids;
filePath = filePathSave + file.FileName;
savePath = uploadpath;
file.SaveAs(filePath);
obj.Logo = UploadBaseUrl + paths + ("/") + Upload.ToString() + ("/") + Guids + file.FileName;
//string Logo1 = data.Logo.Replace("~/", "");
//data.Logo = Logo1;
}
else
{
var file = httpRequest.Files[i];
var GuidsBanner = Guid.NewGuid();
filePathSave = uploadpath + GuidsBanner;
filePathBanner = filePathSave + file.FileName;
savePath = uploadpath;
file.SaveAs(filePathBanner);
obj.Banner = UploadBaseUrl + paths + ("/") + Upload.ToString() + ("\\") + GuidsBanner + file.FileName;
//string Banner1 = data.Banner.Replace("~/", "");
//data.Banner = Banner1;
}
}
db.TblSchools.Add(obj);
db.SaveChanges();
CopyDB objDB = new CopyDB();
string name = school.SchoolName.Replace(" ", "") + "DB";
objDB.Copydata(name.ToUpper());
var details = db.TblSchools.FirstOrDefault(r => r.SchoolName == school.SchoolName);
TblBoardDetail board = new TblBoardDetail();
string[] ids = json1.Split(',');
for (int i = 0; i < ids.Length; i++)
{
board.SchoolId = details.SchoolId;
board.BoardId = Convert.ToInt64(ids[i].Replace("[", "").Replace("]", ""));
board.CreatedBy = 1;
board.CreatedDate = System.DateTime.Today.Date;
board.ModifiedBy = null;
board.ModifiedDate = System.DateTime.Today.Date;
db.TblBoardDetails.Add(board);
db.SaveChanges();
}
//user.code = Convert.ToInt32(HttpContext.Current.Session["Code"]);
return(new Result
{
IsSucess = true,
ResultData = "School Created!"
});
}
catch (Exception e)
{
return(new Error {
IsError = true, Message = e.Message
});
}
}
public object SaveStdWiseDiv(StdWiseDivParam objParam)
{
try
{
objParam.DivisionID = objParam.DivisionID.Trim(',');
string[] division = objParam.DivisionID.Split(',');
int count = 0;
String DivisionName = "";
string StandardName = "";
for (int i = 0; i < division.Length; i++)
{
var divid = Convert.ToInt32(division[i]);
var duplicate = db.View_Display_StandardWiseDivision.SingleOrDefault(r => r.DivisionID == divid && r.StandardID == objParam.StandardID && r.Status == 1);
if (duplicate != null)
{
DivisionName = DivisionName + duplicate.DivisionName + ",";
StandardName = duplicate.StandardName;
count = 1;
}
if (i == division.Length - 1)
{
if (count == 0)
{
Tbl_StandardWiseDivision obj = new Tbl_StandardWiseDivision();
obj.BoardID = objParam.BoardId;
obj.DivisionID = Convert.ToInt64(division[i].ToString());
obj.StandardID = objParam.StandardID;
obj.Status = 1;
obj.CreatedBy = 1;
obj.CreatedDate = DateTime.Now;
obj.ModifiedBy = null;
obj.ModifiedDate = null;
db.Tbl_StandardWiseDivision.Add(obj);
db.SaveChanges();
}
else
{
DivisionName = DivisionName.Trim(',');
StandardName = StandardName.Trim(',');
return(new Result {
IsSucess = true, ResultData = "Division " + DivisionName + " Already Assign to Standard " + StandardName
});
}
}
}
return(new Result {
IsSucess = true, ResultData = "Division Assign Successfully"
});
}
catch (Exception ex)
{
return(new Result {
IsSucess = false, ResultData = "Error"
});
}
}