private void Manage()
{
string result = BillingPurchaseVoucherBAL.Manage(Request.QueryString, Request.Form);
var billingPurchaseVoucher = new BillingPurchaseVoucher {
BPRID = Convert.ToInt32(result.Split(',')[0]),
BPRNo = Convert.ToInt32(result.Split(',')[1])
};
Response.Write(billingPurchaseVoucher.ToJSON());
}
public static List <BillingPurchaseVoucher> GetBillingPurchaseVoucher(string criteria, int branchid)
{
var dbUtil = new DatabaseManager();
var bprs = new List <BillingPurchaseVoucher>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spDISGetBPRHeader";
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 bpr = new BillingPurchaseVoucher
{
BPRID = ReferenceEquals(reader["intBPRID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intBPRID"]),
BPRNo = ReferenceEquals(reader["intBPRNo"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intBPRNo"]),
BPRDate = ReferenceEquals(reader["datBPRDate"], DBNull.Value) ? String.Empty : Convert.ToString(reader["datBPRDate"]),
SupplierID = ReferenceEquals(reader["intSupplierID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSupplierID"]),
SupplierCode = ReferenceEquals(reader["strSupplierCode"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strSupplierCode"]),
Supplier = ReferenceEquals(reader["strSupplier"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strSupplier"]),
VRate = ReferenceEquals(reader["intVRate"], DBNull.Value) ? String.Empty : Convert.ToString(reader["intVRate"]),
EWTRate = ReferenceEquals(reader["intEWTRate"], DBNull.Value) ? String.Empty : Convert.ToString(reader["intEWTRate"]),
Particulars = ReferenceEquals(reader["strParticulars"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strParticulars"]),
TotalGrossAmount = ReferenceEquals(reader["curTotalGrossAmount"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curTotalGrossAmount"]),
TotalDiscount = ReferenceEquals(reader["curTotalDiscount"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curTotalDiscount"]),
TotalNetAmount = ReferenceEquals(reader["curTotalNetAmount"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curTotalNetAmount"]),
TotalVAT = ReferenceEquals(reader["curTotalVAT"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curTotalVAT"]),
TotalVatableAmount = ReferenceEquals(reader["curTotalVatableAmount"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curTotalVatableAmount"]),
TotalEWT = ReferenceEquals(reader["curTotalEWT"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curTotalEWT"]),
AutoEntry = ReferenceEquals(reader["intAutoEntry"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intAutoEntry"])
};
bprs.Add(bpr);
}
return(bprs);
}
}
}
}
public static string Manage(NameValueCollection querystring, NameValueCollection formdata)
{
string isInsert = querystring.Get("TransType");
int intParser;
decimal decParser;
UserProfile userProfile = WebCommon.GetUserProfile();
var bprDetails = new List <BPRDetail>();
bprDetails = (List <BPRDetail>)bprDetails.ToClass(formdata["DetailData"]);
var bprEntryLedgers = new List <BPREntryLedger>();
bprEntryLedgers = (List <BPREntryLedger>)bprEntryLedgers.ToClass(formdata["EntryData"]);
var billingPurchaseVoucher = new BillingPurchaseVoucher
{
BPRID = int.TryParse(querystring.Get("BPRID"), out intParser) ? intParser : 0,
BPRNo = int.TryParse(querystring.Get("BPRNo"), out intParser) ? intParser : 0,
BranchID = int.TryParse(querystring.Get("BranchID"), out intParser) ? intParser : 0,
BPRDate = querystring.Get("BPRDate"),
SupplierID = int.TryParse(querystring.Get("SupplierID"), out intParser) ? intParser : 0,
VRate = querystring.Get("VRate"),
EWTRate = querystring.Get("EWTRate"),
Particulars = querystring.Get("Particulars"),
TotalGrossAmount = decimal.TryParse(querystring.Get("TotalGrossAmount"), out decParser) ? decParser : 0,
TotalDiscount = decimal.TryParse(querystring.Get("TotalDiscount"), out decParser) ? decParser : 0,
TotalNetAmount = decimal.TryParse(querystring.Get("TotalNetAmount"), out decParser) ? decParser : 0,
TotalVAT = decimal.TryParse(querystring.Get("TotalVAT"), out decParser) ? decParser : 0,
TotalVatableAmount = decimal.TryParse(querystring.Get("TotalVatableAmount"), out decParser) ? decParser : 0,
TotalEWT = decimal.TryParse(querystring.Get("TotalEWT"), out decParser) ? decParser : 0,
AutoEntry = int.TryParse(querystring.Get("AutoEntry"), out intParser) ? intParser : 0,
BPRDetails = bprDetails,
BPREntryLedgers = bprEntryLedgers,
UserID = userProfile.UserId
};
string param = WebCommon.ToXML(billingPurchaseVoucher);
return(BillingPurchaseVoucherDAL.Manage(param, isInsert));
}
