public object UpdateSchoolInfo(UpdateSchool school)
{
var httpRequest = HttpContext.Current.Request;
var Logo = System.Web.HttpContext.Current.Request.Files["logo"];
var Banner = System.Web.HttpContext.Current.Request.Files["banner"];
var json1 = System.Web.HttpContext.Current.Request.Form["id"];
var json = System.Web.HttpContext.Current.Request.Form["data"];
UpdateSchool info = Newtonsoft.Json.JsonConvert.DeserializeObject <UpdateSchool>(json);
if (info.SchoolName == null)
{
return(new Error()
{
IsError = true, Message = "Requird Name"
});
}
//var datas = db.TblSchools.FirstOrDefault(r => r.SchoolName == info.SchoolName);
//if (Logo != null)
//{
// return new Error() { IsError = true, Message = "Duplicate Entry Not Allowed" };
//}
var data = db.TblSchools.Where(r => r.SchoolId == info.SchoolId).FirstOrDefault();
TblSchool obj = new TblSchool();
string UploadBaseUrl = ConfigurationManager.AppSettings["UploadBaseURL"];
string fileLogo = string.Empty;
string fileBanner = string.Empty;
var filePath = string.Empty;
var filePathBanner = string.Empty;
var filePathSave = string.Empty;
string savePath = string.Empty;
var Upload = data.SchoolName;
data.SchoolId = info.SchoolId;
data.SchoolName = info.SchoolName;
data.PhoneNo = info.PhoneNo;
data.Address = info.Address;
data.ContactPerson = info.ContactPerson;
data.PayrollTemplateId = info.PayrollTemplateId;
data.FeeTemplateId = info.FeeTemplateId;
data.LoginTemplateId = info.LoginTemplateId;
data.ExamTemplateId = info.ExamTemplateId;
data.ModifiedBy = 1;
data.ModifiedDate = System.DateTime.Today.Date;
data.UserPrefix = info.UserPrefix;
data.UserName = info.UserName;
data.Password = info.Password;
data.Language = info.Language;
data.LandlineNo = info.LandlineNo;
data.EmailId = info.EmailId;
data.Designation = info.Designation;
data.CreatedBy = data.CreatedBy;
data.CreatedDate = data.CreatedDate;
TblBoardDetail board = new TblBoardDetail();
string[] ids = json1.Split(',');
var boarddata = db.TblBoardDetails.Where(r => r.SchoolId == info.SchoolId).FirstOrDefault();
//var getinfo = db.TblBoardDetails.Where(r => r.SchoolId == info.SchoolId && r.BoardId==boarddata.BoardId).FirstOrDefault();
if (boarddata == null)
{
for (int i = 0; i < ids.Length; i++)
{
board.SchoolId = data.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();
}
}
else
{
for (int i = 0; i < ids.Length; i++)
{
board.SchoolId = boarddata.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();
}
}
if (httpRequest.Files.Count == 0)
{
db.SaveChanges();
return(new Result
{
IsSucess = true,
ResultData = "School Updated!"
});
}
else
{
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);
data.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);
data.Banner = UploadBaseUrl + paths + ("/") + Upload.ToString() + ("\\") + GuidsBanner + file.FileName;
//string Banner1 = data.Banner.Replace("~/", "");
//data.Banner = Banner1;
}
}
db.SaveChanges();
return(new Result
{
IsSucess = true,
ResultData = "School Updated!"
});
}
}
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
});
}
}
