public ActionResult DeleteConfirmTenant(int id) { try { Response response = new Response(); List <TblTenant> objTenantList = tr.GetTenantById(id); TblTenant objTenant = objTenantList[0]; if (ModelState.IsValid) { if (objTenant.IsActive == true) { objTenant.IsActive = false; } else { objTenant.IsActive = true; } int rows = tr.DeleteTenants(objTenant); if (rows != 0) { response.StatusCode = 1; } else { response.StatusCode = 0; } } return(Json(response.StatusCode, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { newException.AddException(ex); return(View()); } }
public ActionResult AddTenant() { try { TblTenant objEditData = new TblTenant(); return(View(objEditData)); } catch (Exception ex) { newException.AddException(ex); return(View()); } }
public ActionResult AddTenant(TblTenant objTenant, HttpPostedFileBase file) { try { if (ModelState.IsValid) { if (objTenant.TenantId == 0) { var result = tr.GetTenantByName(objTenant.TenantName); if (!result) { TempData["Message"] = "Tenant Already Exist"; return(View(objTenant)); } } if (file != null) { var logoURL = System.Configuration.ConfigurationManager.AppSettings["LogoURL"]; var logoPhysicalURL = System.Configuration.ConfigurationManager.AppSettings["logoPhysicalURL"]; string filePhysicalPath = System.IO.Path.Combine(logoPhysicalURL + "\\" + objTenant.TenantName + ".jpg"); string path = System.IO.Path.Combine(logoURL + "\\" + objTenant.TenantName + ".jpg"); file.SaveAs(filePhysicalPath); objTenant.Logo = path; } int rows = 0; if (objTenant.TenantId == 0) { rows = tr.AddTenant(objTenant); } else { rows = tr.EditTenants(objTenant); } if (rows != 0) { return(RedirectToAction("AddTenantUser", new { @id = objTenant.TenantId })); } else { return(View(objTenant)); } } return(View(objTenant)); } catch (Exception ex) { newException.AddException(ex); return(View()); } }
public int DeleteTenants(TblTenant obj) { try { db = new DataRepository(); db.AddParameter("@tenantId", SqlDbType.Int, obj.TenantId); db.AddParameter("@isActive", SqlDbType.Bit, obj.IsActive); return(db.ExecuteQuery("sp_TenantActivateDeactivate")); } catch (Exception) { throw; } }
public ActionResult EditTenant(int id) { try { List <TblTenant> tenantDetails = new List <TblTenant>(); tenantDetails = tr.GetTenantById(id); TblTenant objEditData = new TblTenant(); objEditData = tenantDetails[0]; return(View(objEditData)); } catch (Exception ex) { newException.AddException(ex); return(View()); } }
public int EditTenants(TblTenant obj) { try { db.AddParameter("@tenantId", SqlDbType.Int, obj.TenantId); db.AddParameter("@tenantName", SqlDbType.Text, obj.TenantName); db.AddParameter("@tenantDomain", SqlDbType.Text, obj.TenantDomain); db.AddParameter("@activationFrom", SqlDbType.DateTime, obj.ActivationFrom); db.AddParameter("@activationTo", SqlDbType.DateTime, obj.ActivationTo); //db.AddParameter("@createdBy", SqlDbType.Int, obj.CreatedBy); db.AddParameter("@noOfUserAllowed", SqlDbType.Int, obj.NoOfUserAllowed); db.AddParameter("@logo", SqlDbType.Text, obj.Logo); return(db.ExecuteQuery("sp_TenantUpdate")); } catch (Exception) { throw; } }
public int AddTenant(TblTenant obj) { try { obj.CreatedBy = 1;//hardcoded put loginid here db.AddParameter("@tenantName", SqlDbType.Text, obj.TenantName); db.AddParameter("@tenantDomain", SqlDbType.Text, obj.TenantDomain); db.AddParameter("@activationFrom", SqlDbType.DateTime, obj.ActivationFrom); db.AddParameter("@activationTo", SqlDbType.DateTime, obj.ActivationTo); db.AddParameter("@createdBy", SqlDbType.Int, obj.CreatedBy); db.AddParameter("@noOfUserAllowed", SqlDbType.Int, obj.NoOfUserAllowed); db.AddParameter("@logo", SqlDbType.Text, obj.Logo); return(db.ExecuteQuery("sp_TenantAdd")); } catch (Exception) { throw; } }
public ActionResult EditTenant(TblTenant objTenant) { try { if (ModelState.IsValid) { int rows = tr.EditTenants(objTenant); if (rows != 0) { return(RedirectToAction("AddTenantUser", new { @id = objTenant.TenantId })); } else { return(View(objTenant)); } } return(View(objTenant)); } catch (Exception ex) { newException.AddException(ex); return(View()); } }