public static List <BankReconHdr> GetPR(string criteria, int branchID)
{
var dbUtil = new DatabaseManager();
var brHeader = new List <BankReconHdr>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spBankReconGetHdr";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@strCriteria", criteria);
cmd.Parameters.AddWithValue("@intBranchID", branchID);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var brhdr = new BankReconHdr
{
ID = ReferenceEquals(reader["ID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["ID"]),
intIDMasLocation = ReferenceEquals(reader["intIDMasLocation"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasLocation"]),
datAsOf = ReferenceEquals(reader["datAsOf"], DBNull.Value) ? String.Empty : Convert.ToString(reader["datAsOf"]),
strCOAName = ReferenceEquals(reader["strCOAName"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strCOAName"]),
strCOASubName = ReferenceEquals(reader["strCOASubName"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strCOASubName"]),
strCOAIndividualName = ReferenceEquals(reader["strCOAIndividualName"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strCOAIndividualName"]),
intIDMasCOA = ReferenceEquals(reader["intIDMasCOA"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasCOA"]),
intIDMasCOASubsidiary = ReferenceEquals(reader["intIDMasCOASubsidiary"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasCOASubsidiary"]),
intIDMasCOAIndividualSubsidiary = ReferenceEquals(reader["intIDMasCOAIndividualSubsidiary"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasCOAIndividualSubsidiary"]),
curBalancePerBank = ReferenceEquals(reader["curBalancePerBank"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curBalancePerBank"]),
curBalancePerBook = ReferenceEquals(reader["curBalancePerBook"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curBalancePerBook"]),
Remarks = ReferenceEquals(reader["Remarks"], DBNull.Value) ? String.Empty : Convert.ToString(reader["Remarks"]),
Particulars = ReferenceEquals(reader["Particulars"], DBNull.Value) ? String.Empty : Convert.ToString(reader["Particulars"]),
curFundTransfer = ReferenceEquals(reader["curFundTransfer"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curFundTransfer"]),
bolLock = ReferenceEquals(reader["bolLock"], DBNull.Value) ? false : Convert.ToBoolean(reader["bolLock"])
};
brHeader.Add(brhdr);
}
return(brHeader);
}
}
}
}
public static string Manage(NameValueCollection querystring, NameValueCollection formdata)
{
int intParser;
decimal decimalParser;
UserProfile userProfile = WebCommon.GetUserProfile();
var cvfgls = new List <BankReconDetail>();
string isInsert = querystring.Get("transType");
cvfgls = (List <BankReconDetail>)cvfgls.ToClass(formdata["Data"]);
bool lck;
var BnkRecon = new BankReconHdr
{
ID = int.TryParse(querystring.Get("BankReconID"), out intParser) ? intParser : 0,
intIDMasLocation = int.TryParse(querystring.Get("BranchID"), out intParser) ? intParser : 0,
intIDMasCOA = int.TryParse(querystring.Get("COAID"), out intParser) ? intParser : 0,
intIDMasCOASubsidiary = int.TryParse(querystring.Get("COASubsi"), out intParser) ? intParser : 0,
intIDMasCOAIndividualSubsidiary = int.TryParse(querystring.Get("COAIndividual"), out intParser) ? intParser : 0,
datAsOf = querystring.Get("Date"),
curBalancePerBook = decimal.TryParse(querystring.Get("BalPerBook"), out decimalParser) ? decimalParser : 0,
curBalancePerBank = decimal.TryParse(querystring.Get("BalPerBank"), out decimalParser) ? decimalParser : 0,
Remarks = querystring.Get("BalRemarks"),
Particulars = querystring.Get("Particulars"),
curFundTransfer = decimal.TryParse(querystring.Get("FundTransfer"), out decimalParser) ? decimalParser : 0,
intIDSecUser = userProfile.UserId,
bolLock = bool.TryParse(querystring.Get("bolLock"), out lck) ? lck : false,
BankDetails = cvfgls
};
string param = WebCommon.ToXML(BnkRecon);
return(BankReconDAL.Manage(param, isInsert));
}
