public ActionResult getLocationOnId(Model_TransformerFilter filter, int id)
{
try
{
var list = new Dictionary <string, object>();
list.Add("locationid", id);
DataRowCollection userDet = sp.Sp_Generic_Class.GetMultipleRecordByParam("Sp_GetUserDetailsOnId", list);
foreach (DataRow rows in userDet)
{
obj.obj_transformerSuppCode.Add(new Model_TransformerSuppResult
{
locationid = Convert.ToInt32(rows["userid"]),
locationname = Convert.ToString(rows["locationname"]),
//ref_zoneid = Convert.ToInt32(rows["userid"]),
zonename = Convert.ToString(rows["locationname"]),
// ref_circleid = Convert.ToInt32(rows["userid"]),
circlename = Convert.ToString(rows["locationname"]),
// ref_divisionid = Convert.ToInt32(rows["userid"]),
divisionname = Convert.ToString(rows["locationname"]),
});
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
return(Json(new { obj_user = obj.obj_transformerSuppCode }, JsonRequestBehavior.AllowGet));
}
public ActionResult Index(Model_TransformerFilter filter)
{
try
{
string where = null;
if (filter.zone != 0)
{
where += "z.zoneid = " + filter.zone;
obj.obj_location.ref_zoneid = filter.zone;
}
if (filter.circle != 0)
{
where += " AND ";
where += "c.circleid = " + filter.circle;
obj.obj_location.ref_circleid = filter.circle;
}
if (filter.division != 0)
{
where += " AND ";
where += "d.divisionid = " + filter.division;
obj.obj_location.ref_divisionid = filter.division;
}
if (filter.subdivision != 0)
{
where += " AND ";
where += "sb.subdivisionid = " + filter.subdivision;
obj.obj_location.ref_subdivisionid = filter.subdivision;
}
if (filter.section != 0)
{
where += " AND ";
where += "sc.sectionid = " + filter.section;
obj.obj_location.ref_sectionid = filter.section;
}
DataTable dt = sp.Sp_Generic_Class.GetMultipleRecordByStringParam("Sp_GetTransformerSearchFilterData", where);
foreach (DataRow row in dt.Rows)
{
obj.importtoexcel.Add(new Model_ExcelImport
{
zonename = Convert.ToString(row["zonename"]),
circlename = Convert.ToString(row["circlename"]),
divisionname = Convert.ToString(row["divisionname"]),
subdivisionname = Convert.ToString(row["subdivisionname"]),
sectionname = Convert.ToString(row["sectionname"]),
Transformercode = Convert.ToString(row["Transformercode"]),
MakeOfDtr = Convert.ToString(row["MakeOfDtr"]),
dtrcapacity = Convert.ToInt32(row["dtrcapacity"]),
locationname = Convert.ToString(row["locationname"])
});
}
//foreach (DataRow row in dt)
//{
// obj.obj_transformerSuppCode.Add(new Model_TransformerSuppResult
// {
// transformerid = Convert.ToInt32(row["transformerid"]),
// zonename = Convert.ToString(row["zonename"]),
// circlename = Convert.ToString(row["circlename"]),
// divisionname = Convert.ToString(row["divisionname"]),
// subdivisionname = Convert.ToString(row["subdivisionname"]),
// sectionname = Convert.ToString(row["sectionname"]),
// Transformercode = Convert.ToString(row["Transformercode"]),
// MakeOdDtr = Convert.ToString(row["MakeOdDtr"]),
// dtrcapacity = Convert.ToInt32(row["dtrcapacity"])
// });
//}
Session["model"] = obj.importtoexcel;
obj.resultData = dt;
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
obj.obj_zone = _db.Zone.ToList();
return(View(obj));
}