internal List<MaintenancesModel> MaintenanceList(MaintenancesModel maintenance) { AddParameter("@communityid", maintenance.CommunityID); DataTable Dt_MaintenancesList = this.GetDataTable("usp_GetMaintenancesList"); maintenancesList = new List<MaintenancesModel>(); if (Dt_MaintenancesList.Rows.Count > 0) { foreach (DataRow dr in Dt_MaintenancesList.Rows) { maintenanceObj = new MaintenancesModel(); maintenanceObj.MaintenanceID = Convert.ToInt64(dr["MaintenanceID"].ToString()); maintenanceObj.CommunityID = Convert.ToInt16(dr["CommunityID"].ToString()); maintenanceObj.Request = dr["Request"].ToString(); maintenanceObj.Contact = dr["Contact"].ToString(); maintenanceObj.EmailID = dr["EmailID"].ToString(); maintenanceObj.CreatedUserID = Convert.ToInt64(dr["CreatedUserID"].ToString()); maintenanceObj.CreatedRoleID = Convert.ToByte(dr["CreatedRoleID"].ToString()); maintenanceObj.CreatedOn = Convert.ToDateTime(dr["CreatedOn"].ToString()); if (!String.IsNullOrEmpty(dr["ModifiedOn"].ToString())) { maintenanceObj.ModifiedUserID = Convert.ToInt64(dr["ModifiedUserID"].ToString()); maintenanceObj.ModifiedRoleID = Convert.ToByte(dr["ModifiedRoleID"].ToString()); maintenanceObj.ModifiedOn = Convert.ToDateTime(dr["ModifiedOn"].ToString()); } maintenancesList.Add(maintenanceObj); } } return maintenancesList; }
internal MaintenancesModel MaintenanceDetails(MaintenancesModel maintenance) { AddParameter("@maintenanceid", maintenance.MaintenanceID); DataTable Dt_MaintenanceDetails = this.GetDataTable("usp_GetMaintenanceDetails"); if (Dt_MaintenanceDetails.Rows.Count > 0) { foreach (DataRow dr in Dt_MaintenanceDetails.Rows) { maintenanceDetails = new MaintenancesModel(); maintenanceDetails.MaintenanceID = Convert.ToInt64(dr["MaintenanceID"].ToString()); maintenanceDetails.CommunityID = Convert.ToInt16(dr["CommunityID"].ToString()); maintenanceDetails.Request = dr["Request"].ToString(); maintenanceDetails.FullText = dr["FullText"].ToString(); maintenanceDetails.Contact = dr["Contact"].ToString(); maintenanceDetails.EmailID = dr["EmailID"].ToString(); maintenanceDetails.CreatedUserID = Convert.ToInt64(dr["CreatedUserID"].ToString()); maintenanceDetails.CreatedRoleID = Convert.ToByte(dr["CreatedRoleID"].ToString()); maintenanceDetails.CreatedOn = Convert.ToDateTime(dr["CreatedOn"].ToString()); if (!String.IsNullOrEmpty(dr["ModifiedOn"].ToString())) { maintenanceDetails.ModifiedUserID = Convert.ToInt64(dr["ModifiedUserID"].ToString()); maintenanceDetails.ModifiedRoleID = Convert.ToByte(dr["ModifiedRoleID"].ToString()); maintenanceDetails.ModifiedOn = Convert.ToDateTime(dr["ModifiedOn"].ToString()); } } } return maintenanceDetails; }
internal Object DeleteMaintenance(MaintenancesModel maintenance) { AddParameter("@maintenanceid", maintenance.MaintenanceID); AddParameter("@modifieduserid", maintenance.ModifiedUserID); AddParameter("@modifiedroleid", maintenance.ModifiedRoleID); AddParameter("@modifiedon", maintenance.ModifiedOn); return ExecuteScalar("usp_DeleteMaintenance"); }
internal object AddMaintenance(MaintenancesModel maintenance) { AddParameter("@communityid", maintenance.CommunityID); AddParameter("@request", maintenance.Request); AddParameter("@fulltext", maintenance.FullText); AddParameter("@contact", maintenance.Contact); AddParameter("@emailid", maintenance.EmailID); AddParameter("@createduserid", maintenance.CreatedUserID); AddParameter("@createdroleid", maintenance.CreatedRoleID); AddParameter("@createdon", maintenance.CreatedOn); return this.ExecuteScalar("usp_AddMaintenance"); }
public ActionResult NewMaintenance(MaintenancesModel maintenance) { if (this.ModelState.IsValid) { maintenance.CreatedUserID = Convert.ToInt64(useMyCookie["UserID"].ToString()); maintenance.CreatedRoleID = Convert.ToByte(useMyCookie["RoleID"].ToString()); maintenance.CreatedOn = Convert.ToDateTime(DateTime.Now.ToShortDateString()); return Json(maintenancesDAL.AddMaintenance(maintenance).ToString()); } else return AjaxDataError("Maintenance"); }
public ActionResult NewMaintenance() { maintenance = new MaintenancesModel(); maintenance.CommunityID = myCommunityID; return PartialView("Partials/Maintenances/NewMaintenance", maintenance); }
public ActionResult MaintenancesListTable() { maintenance = new MaintenancesModel(); maintenance.CommunityID = myCommunityID; return PartialView("Partials/Maintenances/MaintenancesListTable", maintenancesDAL.MaintenanceList(maintenance)); }
public ActionResult MaintenanceDetails(String maintenanceid) { if (MaintenanceIDSanctityCheck(maintenanceid)) { maintenance = new MaintenancesModel(); maintenance.CommunityID = myCommunityID; maintenance.MaintenanceID = Convert.ToInt64(maintenanceid.ToString()); return PartialView("Partials/Maintenances/MaintenanceDetails", maintenancesDAL.MaintenanceDetails(maintenance)); } else return AjaxParamError("Maintenance"); }
internal MaintenancesModel EditMaintenance(MaintenancesModel maintenance) { return this.MaintenanceDetails(maintenance); }
public ActionResult MaintenancesListTable(String communityid) { if (CommunityIDSanctityCheck(communityid)) { maintenance = new MaintenancesModel(); maintenance.CommunityID = outCommunityID; return PartialView("Partials/Maintenances/MaintenancesListTable", maintenancesDAL.MaintenanceList(maintenance)); } else return AjaxParamError("Community"); }
public ActionResult EditMaintenance(String maintenanceid, String communityid) { if (CommunityIDSanctityCheck(communityid)) { if (MaintenanceIDSanctityCheck(maintenanceid)) { maintenance = new MaintenancesModel(); maintenance.CommunityID = outCommunityID; maintenance.MaintenanceID = Convert.ToInt64(maintenanceid.ToString()); return PartialView("Partials/Maintenances/EditMaintenance", maintenancesDAL.EditMaintenance(maintenance)); } else return AjaxParamError("Maintenance"); } else return AjaxParamError("Community"); }
public ActionResult UpdateMaintenance(MaintenancesModel maintenance) { if (ModelState.IsValid) { maintenance.ModifiedUserID = Convert.ToInt64(useMyCookie["UserID"].ToString()); maintenance.ModifiedOn = Convert.ToDateTime(DateTime.Now.ToShortDateString()); return Json(maintenancesDAL.UpdateMaintenance(maintenance)); } else return AjaxDataError("Maitenance"); }