public object DeleteSchoolRegistrationDetail(SchoolMasterCustomModel objSchoolRegistrationModel)
{
using (objDAL = new SchoolMasterRepo())
{
return(objDAL.DeleteSchoolRegistrationDetail(objSchoolRegistrationModel));
}
}
public Response SaveSchoolMasterDetails(SchoolMasterCustomModel objModel)
{
using (objDAL = new SchoolMasterRepo())
{
return(objDAL.SaveSchoolMasterDetails(objModel));
}
}
/// <summary>
/// This method is used to fetch All Kisan Market
/// </summary>
/// <returns></returns>
///
public object GetSchoolMasterListing(SchoolMasterCustomModel objSchoolRegistrationModel)
{
using (objDAL = new SchoolMasterRepo())
{
return(objDAL.GetSchoolMasterListing(objSchoolRegistrationModel));
}
}
public ActionResult Create(SchoolMasterCustomModel objModel)
{
objBDC = new SchoolMasterBusiness();
objBDC.SaveSchoolMasterDetails(objModel);
return(View());
}
// GET: School
public ActionResult Index()
{
SchoolMasterCustomModel objModel = new SchoolMasterCustomModel();
objBDC = new SchoolMasterBusiness();
objBDC.GetSchoolMasterListing(objModel);
return(View());
}
public Response DeleteSchoolRegistrationDetail(SchoolMasterCustomModel objSchoolRegistrationModel)
{
_response = new Response();
try
{
_response.responseData = objBDC.DeleteSchoolRegistrationDetail(objSchoolRegistrationModel);
_response.message = "Record Deleted Successfully !!";
_response.success = true;
}
catch (Exception ex)
{
_response.success = false;
_response.message = ex.Message.ToString();
}
finally
{
objBDC.Dispose();
}
return(_response);
}
/// <summary>
/// This method is used to delete particular farmer detail
/// </summary>
/// <param name="AssetId">Unique id of asset</param>
/// <returns>Response</returns>
public object DeleteSchoolRegistrationDetail(SchoolMasterCustomModel objSchoolRegistrationModel)
{
object objSchoolResult = new object();
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
var rs = dbcontext.tblSchools.FirstOrDefault(x => x.SchoolId == objSchoolRegistrationModel.SchoolId);
if (rs != null)
{
rs.IsDeleted = true;
rs.ModifiedDate = DateTime.Now;
rs.ModifiedBy = objSchoolRegistrationModel.ModifiedBy;
dbcontext.SaveChanges();
objSchoolResult = true;
}
else
{
objSchoolResult = false;
}
}
catch (Exception ex)
{
dbcontext.Dispose();
objSchoolResult = null;
throw ex;
}
}
return(objSchoolResult);
}
}
public object GetSchoolMasterListing(SchoolMasterCustomModel objSchoolRegistrationModel)
{
IList <SchoolMasterCustomModel> SchoolListModel = new List <SchoolMasterCustomModel>();
IQueryable <SchoolMasterCustomModel> SchoolListDetail = null;
int TotalRec = 0;
int CurrentPageSize = 0;
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
SchoolListDetail = dbcontext.tblSchools.Where(x => x.IsDeleted == false)
.Select(x => new SchoolMasterCustomModel
{
SchoolId = x.SchoolId,
Name = x.Name,
MobileNo = x.MobileNo,
Address = x.Address,
Address2 = x.Address2,
City = x.City,
State = x.State,
Country = x.Country,
DDate = x.DDate,
//DistrictId = x.VillageMaster != null ? x.VillageMaster.CityMaster.DistrictId : 0,
//DistrictName = x.VillageMaster != null ? x.VillageMaster.CityMaster.DistrictMaster.DistrictName : "",
//StateId = x.VillageMaster != null ? x.VillageMaster.CityMaster.DistrictMaster.StateId : 0,
//StateName = x.VillageMaster != null ? x.VillageMaster.CityMaster.DistrictMaster.StateMaster.StateName : "",
ShortDescription = x.ShortDescription,
EmailId = x.EmailId,
TagLine = x.TagLine,
IsActive = x.IsActive,
IsDeleted = x.IsDeleted,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate
}).OrderByDescending(x => x.SchoolId);
if (objSchoolRegistrationModel.pageModel != null)
{
if (objSchoolRegistrationModel.pageModel.SerachTerm != null && objSchoolRegistrationModel.pageModel.SerachTerm != "")
{
SchoolListDetail = SchoolListDetail.Where(x =>
(x.Name.ToLower().Trim().Contains(objSchoolRegistrationModel.pageModel.SerachTerm.ToLower().Trim()) || objSchoolRegistrationModel.pageModel.SerachTerm.Trim() == String.Empty) ||
(x.EmailId.ToLower().Trim().Contains(objSchoolRegistrationModel.pageModel.SerachTerm.ToLower().Trim()) || objSchoolRegistrationModel.pageModel.SerachTerm.Trim() == String.Empty) ||
(x.MobileNo.ToLower().Trim().Contains(objSchoolRegistrationModel.pageModel.SerachTerm.ToLower().Trim()) || objSchoolRegistrationModel.pageModel.SerachTerm.Trim() == String.Empty) ||
(x.Address.ToLower().Trim().Contains(objSchoolRegistrationModel.pageModel.SerachTerm.ToLower().Trim()) || objSchoolRegistrationModel.pageModel.SerachTerm.Trim() == String.Empty)
);
}
if (!String.IsNullOrEmpty(objSchoolRegistrationModel.pageModel.SortBy))
{
//SchoolListDetail= objSchoolRegistrationModel.pageModel.SortDir.ToLower() == "desc" ? SchoolListDetail.OrderByDescending(objSchoolRegistrationModel.pageModel.SortBy)
// : SchoolListDetail.OrderBy(objSchoolRegistrationModel.pageModel.SortBy);
}
TotalRec = SchoolListDetail.Count();
if (objSchoolRegistrationModel.pageModel.PageSize > 0)
{
SchoolListDetail = SchoolListDetail.Skip(objSchoolRegistrationModel.pageModel.Skip);
SchoolListDetail = SchoolListDetail.Take(objSchoolRegistrationModel.pageModel.PageSize);
}
SchoolListModel = SchoolListDetail.ToList() as IList <SchoolMasterCustomModel>;
}
else
{
TotalRec = SchoolListDetail.Count();
SchoolListModel = SchoolListDetail.ToList() as IList <SchoolMasterCustomModel>;
}
//CurrentPageSize = objSchoolRegistrationModel.pageModel.PageSize;
//if (SchoolListModel.Count() > 0 && CurrentPageSize > 0)
//{
// SchoolListModel[0].pageModel = new PagingViewModel();
// SchoolListModel[0].pageModel.TotalRecords = TotalRec;
// if ((TotalRec % CurrentPageSize) == 0)
// {
// SchoolListModel[0].pageModel.TotalPages = TotalRec / CurrentPageSize;
// }
// else
// {
// SchoolListModel[0].pageModel.TotalPages = (TotalRec / CurrentPageSize) + 1;
// }
//}
return(SchoolListModel);
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
return(response);
}
}
}
}
public Response SaveSchoolMasterDetails(SchoolMasterCustomModel objModel)
{
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
if (objModel.SchoolId == 0)
{
var rs = dbcontext.tblSchools.FirstOrDefault(x => x.IsDeleted == false && x.Name == objModel.Name);
if (rs == null)
{
tblSchool objAddNew = new tblSchool
{
Name = objModel.Name,
MobileNo = objModel.MobileNo,
ShortDescription = objModel.ShortDescription,
EmailId = objModel.EmailId,
Address = objModel.Address,
Address2 = objModel.Address2,
City = objModel.City,
Country = objModel.Country,
Image = objModel.Image,
Logo = objModel.Logo,
State = objModel.State,
TagLine = objModel.TagLine,
DDate = DateTime.Now,
IsActive = true,
IsDeleted = false,
CreatedBy = objModel.CreatedBy,
CreatedDate = DateTime.Now,
ModifiedBy = objModel.ModifiedBy,
ModifiedDate = DateTime.Now
};
dbcontext.tblSchools.Add(objAddNew);
dbcontext.SaveChanges();
response.responseData = new { SchoolId = objAddNew.SchoolId, Name = objAddNew.Name };
response.message = "Record Added Successfully!";
}
else
{
response.success = false;
response.message = "Record Already Exists!";
}
}
else
{
var rs = dbcontext.tblSchools.FirstOrDefault(x => x.IsDeleted == false && x.Name == objModel.Name && x.SchoolId != objModel.SchoolId);
if (rs == null)
{
var objUpdate = dbcontext.tblSchools.FirstOrDefault(m => m.SchoolId == objModel.SchoolId);
if (objUpdate != null)
{
objUpdate.Name = objModel.Name;
objUpdate.ShortDescription = objModel.ShortDescription;
objUpdate.MobileNo = objModel.MobileNo;
objUpdate.EmailId = objModel.EmailId;
objUpdate.Address = objModel.Address;
objUpdate.Address2 = objModel.Address2;
objUpdate.City = objModel.City;
objUpdate.Country = objModel.Country;
objUpdate.Image = objModel.Image;
objUpdate.Logo = objModel.Logo;
objUpdate.State = objModel.State;
objUpdate.TagLine = objModel.TagLine;
objUpdate.ModifiedBy = objModel.ModifiedBy;
objUpdate.ModifiedDate = DateTime.Now;
dbcontext.SaveChanges();
response.responseData = new { SchoolId = objUpdate.SchoolId, Name = objUpdate.Name };
response.message = "Record Updated Successfully!";
}
}
else
{
response.success = false;
response.message = "Record Already Exists!";
}
}
return(response);
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
return(response);
}
}
}
}
