Object IRecordView4.RecordView(String SiteID, String PropertyID, String OwnerID, String ConsumerID)
{
DAL.CreditControlSearchList Vwdetails = new CreditControlSearchList();
try
{
Vwdetails = DAL.DALSearch.CreditControlSearchRecordView(SiteID,PropertyID, OwnerID, ConsumerID);
}
catch (Exception ex)
{
throw;
}
return Vwdetails;
}
public static CreditControlSearchList CreditControlSearchRecordView(String SiteID,String PropertyID, String OwnerID, String ConsumerID)
{
CreditControlSearchList List = new CreditControlSearchList();
using (var context = new SycousCon())
{
try
{
var pSiteID = new SqlParameter
{
ParameterName = "SiteID",
Value = SiteID,
Direction = ParameterDirection.Input
};
var pPropertyID = new SqlParameter
{
ParameterName = "PropertyID",
Value = PropertyID,
Direction = ParameterDirection.Input
};
var pOwnerID = new SqlParameter
{
ParameterName = "OwnerID",
Value = OwnerID,
Direction = ParameterDirection.Input
};
var pConsumerID = new SqlParameter
{
ParameterName = "ConsumerID",
Value = ConsumerID,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<CreditControlSearchList>("exec [SYCOUS].[GetSearchCreditControlDetails] @SiteID,@PropertyID,@OwnerID,@ConsumerID",pSiteID, pPropertyID, pOwnerID, pConsumerID).FirstOrDefault();
return List;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
public ActionResult GetCreditControl(String consID, String OwnerID, String PropID, String SiteID, String ClientID, String MeterID)
{
if (Session["Login"] != null)
{
try
{
LoginSession loginsession = (LoginSession)Session["Login"];
ViewBag.CompanyLogo = loginsession.CompanyLogo;
ViewBag.Layout1 = BAL.Common.LayoutType(loginsession.UserType);
String actionName = this.ControllerContext.RouteData.Values["action"].ToString();
String controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ViewBag.Menu = BAL.Common.GetActiveMenu(controllerName, BAL.Common.LayoutType(loginsession.UserType));
DAL.CreditControlSearchList Vwobj = new DAL.CreditControlSearchList();
if (PropID != null)
{
String DPropID = BAL.Security.URLDecrypt(PropID);
String _OwnerID = BAL.Security.URLDecrypt(OwnerID);
String _consID = BAL.Security.URLDecrypt(consID);
String _SiteID = BAL.Security.URLDecrypt(SiteID);
if ((DPropID != "0") && (DPropID != null))
{
Vwobj = BAL.SearchModel.CreditControlRecordList(_SiteID, DPropID, _OwnerID, _consID);
ViewBag.DirectDebit = BAL.SearchModel.DirectDebitRecordList(Vwobj.PropertyID, Vwobj.OwnerID, Vwobj.ConsumerID);
ViewBag.BillCreditControl = BAL.SearchModel.BillCreditControlRecordList(Vwobj.PropertyID, Vwobj.OwnerID, Vwobj.ConsumerID);
}
return View(Vwobj);
}
else
{
return RedirectToAction("Index", "Search");
}
}
catch (Exception ex)
{
return Content(ex.Message.ToString());
}
}
else
{ return RedirectToAction("Index", "Home"); }
}
