public static List <GLDetail> GetGLDetail(int branchid, int booktypeid, string dattransactionfrom, string dattransactionto)
{
var dbUtil = new DatabaseManager();
var glDetails = new List <GLDetail>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spAccGLGetData";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@intIDMasLocation", branchid);
cmd.Parameters.AddWithValue("@intIDMasBookType", booktypeid);
cmd.Parameters.AddWithValue("@datTransactionFrom", dattransactionfrom);
cmd.Parameters.AddWithValue("@datTransactionTo", dattransactionto);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var bookType = new GLDetail
{
GLDetailID = ReferenceEquals(reader["intGLDetailID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intGLDetailID"]),
Number = ReferenceEquals(reader["strNumber"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strNumber"]),
BankNameID = ReferenceEquals(reader["intBankNameID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intBankNameID"]), //Not Yet Implemented
BankAccountID = ReferenceEquals(reader["intBankAccountID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intBankAccountID"]), //Not Yet Implemented
TrasactionDate = ReferenceEquals(reader["datTransactionDate"], DBNull.Value) ? string.Empty : Convert.ToString(reader["datTransactionDate"]),
BookTypeCode = ReferenceEquals(reader["strBookTypeCode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strBookTypeCode"]),
FiscalYear = ReferenceEquals(reader["intFiscalYear"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intFiscalYear"]),
Particulars = ReferenceEquals(reader["strParticulars"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strParticulars"]),
Amount = ReferenceEquals(reader["curAmount"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curAmount"]),
ChequeNo = ReferenceEquals(reader["strChequeNo"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strChequeNo"]),
ChequeDate = ReferenceEquals(reader["datChequeDate"], DBNull.Value) ? string.Empty : Convert.ToString(reader["datChequeDate"]), //Not Yet Implemented
PayeeID = ReferenceEquals(reader["intPayeeID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intPayeeID"]), //Not Yet Implemented
Payee = ReferenceEquals(reader["strPayee"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strPayee"]),
BankCode = ReferenceEquals(reader["strBankCode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strBankCode"]),
// ApprovedID = ReferenceEquals(reader["intApprovedID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intApprovedID"]) //Not Yet Implemented
};
glDetails.Add(bookType);
}
return(glDetails);
}
}
}
}
public static string ManageCollection(NameValueCollection querystring)
{
int intParser;
decimal decimalParser;
UserProfile userProfile = WebCommon.GetUserProfile();
var entryLedgers = new List <EntryLedger>();
entryLedgers = (List <EntryLedger>)entryLedgers.ToClass(querystring.Get("data"));
var glDetail = new GLDetail
{
GLDetailID = int.TryParse(querystring.Get("ID"), out intParser) ? intParser : 0,
BranchID = int.TryParse(querystring.Get("BranchID"), out intParser) ? intParser : 0,
Number = querystring.Get("Number"),
DepartmentID = int.TryParse(querystring.Get("DepartmentID"), out intParser) ? intParser : 0,
BankNameID = int.TryParse(querystring.Get("BankNameID"), out intParser) ? intParser : 0,
BankAccountID = int.TryParse(querystring.Get("BankAccountID"), out intParser) ? intParser : 0,
TrasactionDate = querystring.Get("Date"),
BookTypeCode = querystring.Get("BookTypeCode"),
FiscalYear = int.TryParse(querystring.Get("FiscalYear"), out intParser) ? intParser : 0,
Particulars = querystring.Get("Particulars"),
Amount = decimal.TryParse(querystring.Get("Amount"), out decimalParser) ? decimalParser : 0,
ChequeNo = querystring.Get("ChequeNo"),
ChequeDate = querystring.Get("ChequeDate"),
Payee = querystring.Get("Payee"),
BankCode = querystring.Get("BankCode"),
//ApprovedID = int.TryParse(querystring.Get("ApprovedID"), out intParser) ? intParser : 0,
UserID = userProfile.UserId,
EntryLedgers = entryLedgers
};
int booktypeid = int.TryParse(querystring.Get("BookTypeID"), out intParser) ? intParser : 0;
//18 jv
//19 cv
if (booktypeid != 6 && booktypeid != 19)
{
throw new Exception("Only CV and JV are allow to add!");
}
string isInsert = querystring.Get("TransType");
string param = WebCommon.ToXML(glDetail);
return(JVDAL.Manage(param, isInsert, booktypeid));
}
