public static HORep_ManageResultString SaveHOReplenishment(NameValueCollection querystring, NameValueCollection formdata)
{
int intParser;
decimal decimalParser;
var HORep = new HORep_CVForReplenishment();
HORep.ID = Int32.TryParse(querystring.Get("intIDDisHOReplenishment"), out intParser) ? intParser : 0;
HORep.TransactionDate = querystring.Get("TransactionDate");
HORep.intIDMasPayee = Int32.TryParse(querystring.Get("intIDMasPayee"), out intParser) ? intParser : 0;
HORep.intIDMasCOAIndividualSubsidiaryRF = Int32.TryParse(querystring.Get("intIDMasCOAIndividualSubsidiaryRF"), out intParser) ? intParser : 0;
HORep.intIDMasCOAIndividualSubsidiaryCiB = Int32.TryParse(querystring.Get("intIDMasCOAIndividualSubsidiaryCiB"), out intParser) ? intParser : 0;
HORep.strCheckNo = querystring.Get("strCheckNo");
HORep.CheckDate = querystring.Get("CheckDate");
HORep.curAmount = Decimal.TryParse(querystring.Get("curAmount"), out decimalParser) ? decimalParser : 0;
HORep.strParticulars = querystring.Get("strParticulars");
UserProfile userprofile = WebCommon.GetUserProfile();
HORep.intIDSecUser = int.Parse(userprofile.UserId.ToString());
var HORepDetails = new List <HORep_CVForReplenishmentDetail>();
string strData1 = formdata[0].ToString().Substring(formdata[0].ToString().IndexOf("],[") + 1, formdata[0].Length - formdata[0].ToString().IndexOf("],[") - 1);
HORepDetails = (List <HORep_CVForReplenishmentDetail>)HORepDetails.ToClass(strData1);
DataTable tblHORepDetails = new DataTable();
tblHORepDetails.TableName = "tblHORepDetails";
tblHORepDetails.Columns.Add("tblType", typeof(string));
tblHORepDetails.Columns.Add("intIDtblType", typeof(int));
tblHORepDetails.Columns.Add("ReferenceNo", typeof(int));
tblHORepDetails.Columns.Add("intIDPayee", typeof(int));
tblHORepDetails.Columns.Add("TransactionDate", typeof(DateTime));
tblHORepDetails.Columns.Add("strCheckNo", typeof(string));
tblHORepDetails.Columns.Add("curAmount", typeof(decimal));
tblHORepDetails.Columns.Add("strParticulars", typeof(string));
tblHORepDetails.Columns.Add("sysReferenceNo", typeof(string));
foreach (var item in HORepDetails)
{
tblHORepDetails.Rows.Add(
item.tblType,
item.intIDtblType,
item.ReferenceNo,
item.intIDPayee,
item.TransactionDate,
item.CheckNo,
item.curAmount,
item.Particulars,
item.sysReferenceNo
);
}
return(HOReplenishmentDAL.SaveHOReplenishment(HORep, tblHORepDetails));
}
public static List <HORep_Payee> GetPayee(NameValueCollection querystring)
{
//int branchID = Int32.TryParse(querystring.Get("branchID"), out branchID) ? branchID : 0;
//int liasonID = Int32.TryParse(querystring.Get("liasonID"), out liasonID) ? liasonID : 0;
//string dateFrom = querystring.Get("DateFrom");
//string dateTo = querystring.Get("DateTo");
//int intIDLtoStatus = Int32.TryParse(querystring.Get("intIDLtoStatus"), out intIDLtoStatus) ? intIDLtoStatus : 0;
return(HOReplenishmentDAL.GetPayee());
}
public static List <HORep_CVForReplenishmentDetail> GetPendingForReplenishment(NameValueCollection querystring)
{
return(HOReplenishmentDAL.GetPendingForReplenishment());
}
public static List <HORep_CiBBankAccount> GetCiBBankAccount(NameValueCollection querystring)
{
return(HOReplenishmentDAL.GetCiBBankAccount());
}
public static List <HORep_LedgerEntry> GetHOReplenishmentLedgerEntry(NameValueCollection querystring)
{
int intIDDisHOReplenishment = int.Parse(querystring.Get("intIDDisHOReplenishment"));
return(HOReplenishmentDAL.GetHOReplenishmentLedgerEntry(intIDDisHOReplenishment));
}
public static List <HORep_CVForReplenishmentDetail> GetHOReplenishmentDetail(NameValueCollection querystring)
{
int intIDDisHOReplenishment = int.Parse(querystring.Get("intIDDisHOReplenishment"));
return(HOReplenishmentDAL.GetHOReplenishmentDetail(intIDDisHOReplenishment));
}
public static List <HORep_CVForReplenishment> SearchHOReplenishment(NameValueCollection querystring)
{
string strCriteria = querystring.Get("criteria");
return(HOReplenishmentDAL.SearchHOReplenishment(strCriteria));
}