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());
}
}
