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());
}
}
