public static string Manage(NameValueCollection querystring, NameValueCollection formdata) { int intParser; decimal decimalParser; UserProfile userProfile = WebCommon.GetUserProfile(); var rfunddetails = new List <RFundDetail>(); rfunddetails = (List <RFundDetail>)rfunddetails.ToClass(formdata["Data"]); var rFund = new RFund { RFundID = int.TryParse(querystring.Get("RFundID"), out intParser) ? intParser : 0, BranchID = int.TryParse(querystring.Get("BranchID"), out intParser) ? intParser : 0, //BranchForReplenishID = int.TryParse(querystring.Get("BranchForReplenishID"), out intParser) ? intParser : 0, Number = int.TryParse(querystring.Get("Number"), out intParser) ? intParser : 0, Date = querystring.Get("Date"), CheckNo = querystring.Get("CheckNo"), CheckDate = querystring.Get("CheckDate"), Amount = decimal.TryParse(querystring.Get("Amount"), out decimalParser) ? decimalParser : 0, PayeeID = int.TryParse(querystring.Get("PayeeID"), out intParser) ? intParser : 0, Particulars = querystring.Get("Particulars"), Details = rfunddetails, UserID = userProfile.UserId, COAIndSubID = int.TryParse(querystring.Get("COAIndSubID"), out intParser) ? intParser : 0 }; string isInsert = querystring.Get("TransType"); string param = WebCommon.ToXML(rFund); return(RFundDAL.Manage(param, isInsert)); }
public static List <RFund> GetRFund(int branchid, string criteria) { var dbUtil = new DatabaseManager(); var rfunds = new List <RFund>(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spDisGetRFund"; cmd.CommandTimeout = 180; cmd.Parameters.AddWithValue("@intBranchID", branchid); cmd.Parameters.AddWithValue("@strCriteria", criteria); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var rfund = new RFund { RFundID = ReferenceEquals(reader["intRFundID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intRFundID"]), BranchID = ReferenceEquals(reader["intBranchID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intBranchID"]), Number = ReferenceEquals(reader["intNumber"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intNumber"]), Date = ReferenceEquals(reader["datDate"], DBNull.Value) ? string.Empty : Convert.ToString(reader["datDate"]), CheckNo = ReferenceEquals(reader["strCheckNo"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCheckNo"]), CheckDate = ReferenceEquals(reader["datCheckDate"], DBNull.Value) ? string.Empty : Convert.ToString(reader["datCheckDate"]), Amount = ReferenceEquals(reader["curAmount"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curAmount"]), PayeeID = ReferenceEquals(reader["intPayeeID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intPayeeID"]), Payee = ReferenceEquals(reader["strPayee"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strPayee"]), Particulars = ReferenceEquals(reader["strParticulars"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strParticulars"]), IsPosted = !ReferenceEquals(reader["blnIsPosted"], DBNull.Value) && Convert.ToBoolean(reader["blnIsPosted"]), IsFinalPosted = !ReferenceEquals(reader["blnIsFinalPosted"], DBNull.Value) && Convert.ToBoolean(reader["blnIsFinalPosted"]), COAIndSubID = ReferenceEquals(reader["intCOAIndSubID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intCOAIndSubID"]), COAIndSub = ReferenceEquals(reader["strCOAIndSub"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCOAIndSub"]), }; rfunds.Add(rfund); } } } } return(rfunds); }
private void Manage() { try { string result = RFundBAL.Manage(Request.QueryString, Request.Form); var rfund = new RFund { RFundID = Convert.ToInt32(result.Split(',')[0]), Number = Convert.ToInt32(result.Split(',')[1]) }; Response.Write(rfund.ToJSON()); } catch (Exception ex) { var appError = new ApplicationError { ErrorMessage = ex.Message, ErrorCode = 999 }; Response.Write(appError.ToJSON()); } }