public static List <ReceivingHeader> GetReceivingHeader(string criteria, int branchid)
{
var dbUtil = new DatabaseManager();
var receivingHeaders = new List <ReceivingHeader>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spPurGetReceivingHeader";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@strCriteria", criteria);
cmd.Parameters.AddWithValue("@intIDMasLocation", branchid);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var receivingHeader = new ReceivingHeader
{
RRID = ReferenceEquals(reader["intRRID"], DBNull.Value) ? 0 : (int)reader["intRRID"],
RRNo = ReferenceEquals(reader["intRRNo"], DBNull.Value) ? 0 : (int)reader["intRRNo"],
RRDate = ReferenceEquals(reader["datRRDate"], DBNull.Value) ? String.Empty : (string)reader["datRRDate"],
BranchID = ReferenceEquals(reader["intBranchID"], DBNull.Value) ? 0 : (int)reader["intBranchID"],
TransactionTypeID = ReferenceEquals(reader["intTransactionTypeID"], DBNull.Value) ? 0 : (int)reader["intTransactionTypeID"],
SINo = ReferenceEquals(reader["strSINo"], DBNull.Value) ? String.Empty : (string)reader["strSINo"],
SIDate = ReferenceEquals(reader["datSIDate"], DBNull.Value) ? String.Empty : (string)reader["datSIDate"],
PONo = ReferenceEquals(reader["strPONo"], DBNull.Value) ? String.Empty : (string)reader["strPONo"],
PODate = ReferenceEquals(reader["datPODate"], DBNull.Value) ? String.Empty : (string)reader["datPODate"],
VRate = ReferenceEquals(reader["curVRate"], DBNull.Value) ? 0 : (decimal)reader["curVRate"],
EWTRate = ReferenceEquals(reader["curEWTRate"], DBNull.Value) ? 0 : (decimal)reader["curEWTRate"],
GrossAmount = ReferenceEquals(reader["curGrossAmount"], DBNull.Value) ? 0 : (decimal)reader["curGrossAmount"],
Discount = ReferenceEquals(reader["curDiscount"], DBNull.Value) ? 0 : (decimal)reader["curDiscount"],
NetAmount = ReferenceEquals(reader["curNetAmount"], DBNull.Value) ? 0 : (decimal)reader["curNetAmount"],
InputTax = ReferenceEquals(reader["curInputTax"], DBNull.Value) ? 0 : (decimal)reader["curInputTax"],
VatableAmount = ReferenceEquals(reader["curVatableAmount"], DBNull.Value) ? 0 : (decimal)reader["curVatableAmount"],
EWTAmount = ReferenceEquals(reader["curEWTAmount"], DBNull.Value) ? 0 : (decimal)reader["curEWTAmount"],
PODetails = ReferenceEquals(reader["strPODetails"], DBNull.Value) ? String.Empty : (string)reader["strPODetails"],
Particulars = ReferenceEquals(reader["strParticulars"], DBNull.Value) ? String.Empty : (string)reader["strParticulars"],
SupplierID = ReferenceEquals(reader["intSupplierID"], DBNull.Value) ? 0 : (int)reader["intSupplierID"],
Supplier = ReferenceEquals(reader["strSupplier"], DBNull.Value) ? String.Empty : (string)reader["strSupplier"],
SupplierTerm = ReferenceEquals(reader["intSupplierTerm"], DBNull.Value) ? 0 : (int)reader["intSupplierTerm"]
};
receivingHeaders.Add(receivingHeader);
}
return(receivingHeaders);
}
}
}
}
public static string Manage(NameValueCollection querystring, NameValueCollection formdata)
{
string isInsert = querystring.Get("TransType");
int intParser;
decimal decParser;
UserProfile userProfile = WebCommon.GetUserProfile();
var receivingDetails = new List <ReceivingDetail>();
receivingDetails = (List <ReceivingDetail>)receivingDetails.ToClass(formdata["Data"]);
var receivingBTDetails = new List <ReceivingBTDetail>();
receivingBTDetails = (List <ReceivingBTDetail>)receivingBTDetails.ToClass(formdata["BTData"]);
var receivingHeaders = new ReceivingHeader
{
RRID = int.TryParse(querystring.Get("RRID"), out intParser) ? intParser : 0,
RRNo = int.TryParse(querystring.Get("RRNo"), out intParser) ? intParser : 0,
RRDate = querystring.Get("RRDate"),
BranchID = int.TryParse(querystring.Get("BranchID"), out intParser) ? intParser : 0,
TransactionTypeID = int.TryParse(querystring.Get("TransactionTypeID"), out intParser) ? intParser : 0,
SINo = querystring.Get("SINo"),
SIDate = querystring.Get("SIDate"),
PONo = querystring.Get("PONo"),
PODate = querystring.Get("PODate"),
VRate = decimal.TryParse(querystring.Get("VRate"), out decParser) ? decParser : 0,
EWTRate = decimal.TryParse(querystring.Get("EWTRate"), out decParser) ? decParser : 0,
GrossAmount = decimal.TryParse(querystring.Get("GrossAmount"), out decParser) ? decParser : 0,
Discount = decimal.TryParse(querystring.Get("Discount"), out decParser) ? decParser : 0,
NetAmount = decimal.TryParse(querystring.Get("NetAmount"), out decParser) ? decParser : 0,
InputTax = decimal.TryParse(querystring.Get("InputTax"), out decParser) ? decParser : 0,
VatableAmount = decimal.TryParse(querystring.Get("VatableAmount"), out decParser) ? decParser : 0,
EWTAmount = decimal.TryParse(querystring.Get("EWTAmount"), out decParser) ? decParser : 0,
PODetails = querystring.Get("PODetails"),
Particulars = querystring.Get("Particulars"),
SupplierID = int.TryParse(querystring.Get("SupplierID"), out intParser) ? intParser : 0,
SupplierTerm = int.TryParse(querystring.Get("SupplierTerm"), out intParser) ? intParser : 0,
Details = receivingDetails,
BTDetails = receivingBTDetails,
UserID = userProfile.UserId
};
string param = WebCommon.ToXML(receivingHeaders);
return(ReceivingDAL.Manage(param, isInsert));
}
private void Manage()
{
try
{
string result = ReceivingBAL.Manage(Request.QueryString, Request.Form);
var receivingHeader = new ReceivingHeader {
RRID = Convert.ToInt32(result.Split(',')[0]),
RRNo = Convert.ToInt32(result.Split(',')[1]),
};
Response.Write(receivingHeader.ToJSON());
}
catch (Exception ex)
{
var appError = new ApplicationError
{
ErrorMessage = ex.Message
, ErrorCode = 999
};
Response.Write(appError.ToJSON());
}
}
