public static List <DeliveryChallanReportModel> GetDeliveryChallanReport(string dbName, string LRNO)
{
var deliveryChallanReports = new List <DeliveryChallanReportModel>();
try
{
string connectionString = ConfigurationManager.ConnectionStrings["TranDBEntities"].ToString().Replace("XXXX", dbName);
var _LRNO = new SqlParameter {
ParameterName = "LRNo", Value = LRNO
};
using (var dbContext = new TranDBContext(connectionString))
{
var results = dbContext
.MultipleResults("[dbo].[PROC_DeliveryChallanDelhiWeb]")
.With <DeliveryChallanReportModel>()
.Execute(_LRNO);
if (results != null && results.Count > 0)
{
deliveryChallanReports = ((List <DeliveryChallanReportModel>)results[0]).ToList();
}
}
}
catch (Exception ex)
{
Common.LogError("Report", "GetDeliveryChallanReport", "GetDeliveryChallanReport", ex.Message.ToString(), "", "", "");
return(deliveryChallanReports);
}
return(deliveryChallanReports);
}
public static TrackLRNoModel TrackLRStatus(string LRNo)
{
var trackLRNO = new TrackLRNoModel();
try
{
var _LRNo = new SqlParameter {
ParameterName = "LRNo", Value = LRNo
};
string connectionString = ConfigurationManager.ConnectionStrings["TrackDBEntities"].ToString();
using (var dbContext = new TranDBContext(connectionString))
{
var results = dbContext
.MultipleResults("[dbo].[Sp_WebBookingFormReport]")
.With <TrackLRNoModel>()
.Execute(_LRNo);
if (results != null && results.Count > 0)
{
trackLRNO = ((List <TrackLRNoModel>)results[0]).SingleOrDefault();
}
}
}
catch (Exception ex)
{
Common.LogError("Login", "TrackLRStatus", "TrackLRStatus", ex.Message.ToString(), ex.StackTrace.ToString(), "", "");
}
return(trackLRNO);
}
public static List <PartyWiseClosingModel> GetPartyMasterReport(string dbName)
{
var partyMaster = new List <PartyWiseClosingModel>();
try
{
string connectionString = ConfigurationManager.ConnectionStrings["TranDBEntities"].ToString().Replace("XXXX", dbName);
using (var dbContext = new TranDBContext(connectionString))
{
var results = dbContext
.MultipleResults("[dbo].[Sp_PartywiseClosingBalance]")
.With <PartyWiseClosingModel>()
.Execute();
if (results != null && results.Count > 0)
{
partyMaster = ((List <PartyWiseClosingModel>)results[0]).ToList();
}
}
}
catch (Exception ex)
{
Common.LogError("Report", "GetPartyMasterReport", "GetPartyMasterReport", ex.Message.ToString(), "", "", "");
return(partyMaster);
}
return(partyMaster);
}