public ActionResult SpecialityEdit()
{
if (!string.IsNullOrEmpty(Session["username"] as string))
{
if (Session["roleid"].ToString() == "1" || Session["roleid"].ToString() == "8")
{
try
{
SpecialityLeasingData sld = new SpecialityLeasingData();
SpecialityLeasingModel specialityLeasingModel = sld.GetSpecialityLeasingData();
return(View(specialityLeasingModel));
}
catch (Exception ex)
{
return(View("Error", ex));
}
}
else
{
return(View("Accessdenied"));
}
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
public string Print()
{
SpecialityLeasingData sld = new SpecialityLeasingData();
SpecialityLeasingModel specialityLeasingModel = sld.GetSpecialityLeasingData();
return(new PageOrientations().RenderRazorViewToString(this, "Print", specialityLeasingModel));
}
public SpecialityLeasingModel GetSpecialityLeasingData()
{
SpecialityLeasingModel specialityLeasingModel = new SpecialityLeasingModel();
List <SpecialityLeasing> specialityLeasings = new List <SpecialityLeasing>();
List <SpecialProject> specialProjects = new List <SpecialProject>();
DataSet data = DBConnection.GetData("GetSpecialityLeasing");
foreach (DataRow row in data.Tables[0].Rows)
{
SpecialityLeasing obj = new SpecialityLeasing();
obj.Tenant = !String.IsNullOrEmpty(row["Tenant"].ToString()) ? row["Tenant"].ToString() : string.Empty;
obj.SpecialityLeasingId = new Guid(row["SpecialityLeasingId"].ToString());
obj.Sector = !String.IsNullOrEmpty(row["Sector"].ToString()) ? row["Sector"].ToString() : string.Empty;
obj.UnitNo = !String.IsNullOrEmpty(row["UnitNo"].ToString()) ? row["UnitNo"].ToString() : string.Empty;
obj.Gla = !String.IsNullOrEmpty(row["Gla"].ToString()) ? row["Gla"].ToString() : string.Empty;
obj.Term = !String.IsNullOrEmpty(row["Term"].ToString()) ? row["Term"].ToString() : string.Empty;
obj.GrossRentBudget = !String.IsNullOrEmpty(row["GrossRentBudget"].ToString()) ? row["GrossRentBudget"].ToString() : string.Empty;
obj.GrossRentActual = !String.IsNullOrEmpty(row["GrossRentActual"].ToString()) ? row["GrossRentActual"].ToString() : string.Empty;
obj.SalesPercentage = !String.IsNullOrEmpty(row["SalesPercentage"].ToString()) ? row["SalesPercentage"].ToString() : string.Empty;
obj.Comments = !String.IsNullOrEmpty(row["Comments"].ToString()) ? row["Comments"].ToString() : string.Empty;
specialityLeasings.Add(obj);
}
foreach (DataRow row in data.Tables[1].Rows)
{
SpecialProject obj = new SpecialProject();
obj.ProjectId = new Guid(row["ProjectId"].ToString());
obj.Title = !String.IsNullOrEmpty(row["Title"].ToString()) ? row["Title"].ToString() : string.Empty;
obj.Content = !String.IsNullOrEmpty(row["Content"].ToString()) ? row["Content"].ToString() : string.Empty;
specialProjects.Add(obj);
}
specialityLeasingModel.specialityLeasings = specialityLeasings;
specialityLeasingModel.specialProjects = specialProjects;
return(specialityLeasingModel);
}
public void UpdateSpeciality(SpecialityLeasingModel obj)
{
using (SqlConnection con = new SqlConnection(DBConnection.GetConnectionString()))
{
var datatableLeasing = DBConnection.ToDataTable <SpecialityLeasing>(obj.specialityLeasings);
var datatableProject = DBConnection.ToDataTable <SpecialProject>(obj.specialProjects);
using (SqlCommand cmd = new SqlCommand("UpdateSpeciality", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@LeasingData", datatableLeasing);
cmd.Parameters.AddWithValue("@ProjectData", datatableProject);
con.Open();
cmd.ExecuteNonQuery();
}
}
}
public ActionResult SpecialityEdit(FormCollection form)
{
if (!string.IsNullOrEmpty(Session["username"] as string))
{
try
{
SpecialityLeasingModel specialityLeasingModel = new SpecialityLeasingModel();
List <SpecialityLeasing> lstleasing = new List <SpecialityLeasing>();
List <SpecialProject> lstprojects = new List <SpecialProject>();
for (int i = 1; i <= 6; i++)
{
SpecialityLeasing obj = new SpecialityLeasing();
obj.Tenant = form["Tenant" + i];
obj.Sector = form["Sector" + i];
obj.UnitNo = form["UnitNo" + i];
obj.Gla = form["Gla" + i];
obj.Term = form["Term" + i];
obj.GrossRentBudget = form["GrossRentBudget" + i];
obj.GrossRentActual = form["GrossRentActual" + i];
obj.SalesPercentage = form["SalesPercentage" + i];
obj.Comments = form["comment" + i];
lstleasing.Add(obj);
}
for (int i = 1; i <= 4; i++)
{
SpecialProject obj = new SpecialProject();
obj.Title = form["Title" + i];
obj.Content = form["Content" + i];
lstprojects.Add(obj);
}
specialityLeasingModel.specialityLeasings = lstleasing;
specialityLeasingModel.specialProjects = lstprojects;
SpecialityLeasingData sdl = new SpecialityLeasingData();
sdl.UpdateSpeciality(specialityLeasingModel);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(View("Error", ex));
}
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
// GET: SpecialtyLeasing
public ActionResult Index()
{
if (!string.IsNullOrEmpty(Session["username"] as string))
{
try
{
SpecialityLeasingData sld = new SpecialityLeasingData();
SpecialityLeasingModel specialityLeasingModel = sld.GetSpecialityLeasingData();
return(View(specialityLeasingModel));
}
catch (Exception ex)
{
return(View("Error", ex));
}
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
