public List <TransactionModel> GetAllTransactionListOP(long TenantID) { ShomaRMEntities db = new ShomaRMEntities(); List <TransactionModel> lstpr = new List <TransactionModel>(); int userid = ShomaRM.Models.ShomaGroupWebSession.CurrentUser != null ? ShomaRM.Models.ShomaGroupWebSession.CurrentUser.UserID : 0; var appData = db.tbl_Applicant.Where(p => p.UserID == TenantID).FirstOrDefault(); long appid = 0; if (appData != null) { appid = appData.ApplicantID; } try { DataTable dtTable = new DataTable(); using (var cmd = db.Database.Connection.CreateCommand()) { db.Database.Connection.Open(); cmd.CommandText = "usp_GetOnlineTransactionList"; cmd.CommandType = CommandType.StoredProcedure; DbParameter paramTID = cmd.CreateParameter(); paramTID.ParameterName = "TenantID"; paramTID.Value = TenantID; cmd.Parameters.Add(paramTID); DbParameter paramAID = cmd.CreateParameter(); paramAID.ParameterName = "AppID"; paramAID.Value = appid; cmd.Parameters.Add(paramAID); DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter(); da.SelectCommand = cmd; da.Fill(dtTable); db.Database.Connection.Close(); } foreach (DataRow dr in dtTable.Rows) { TransactionModel pr = new TransactionModel(); DateTime?transactiondateString = null; try { transactiondateString = Convert.ToDateTime(dr["Transaction_Date"].ToString()); } catch { } DateTime?createdDateString = null; try { createdDateString = Convert.ToDateTime(dr["CreatedDate"].ToString()); } catch { } DateTime?charge_DateString = null; try { charge_DateString = Convert.ToDateTime(dr["Charge_Date"].ToString()); } catch { } DateTime?accounting_DateString = null; try { accounting_DateString = Convert.ToDateTime(dr["Accounting_Date"].ToString()); } catch { } pr.TransID = Convert.ToInt32(dr["TransID"].ToString()); // pr.TenantIDString = dr["TenantID"].ToString(); pr.Transaction_Type = dr["Transaction_Type"].ToString(); pr.Transaction_DateString = transactiondateString == null ? "" : transactiondateString.ToString(); pr.CreatedDateString = createdDateString == null ? "" : createdDateString.ToString(); pr.Credit_Amount = Convert.ToDecimal(dr["Credit_Amount"].ToString()); pr.Description = dr["Description"].ToString(); pr.Charge_DateString = charge_DateString == null ? "" : charge_DateString.ToString(); pr.Charge_Type = dr["Charge_Type"].ToString(); pr.Charge_Amount = Convert.ToDecimal(dr["Charge_Amount"].ToString()); pr.ApplicantName = dr["ApplicantName"].ToString(); pr.ApplicantType = dr["ApplicantType"].ToString(); lstpr.Add(pr); } db.Dispose(); return(lstpr.ToList()); } catch (Exception ex) { db.Database.Connection.Close(); throw ex; } }
public string SaveUpdateTransaction(TransactionModel model) { ShomaRMEntities db = new ShomaRMEntities(); string msg = ""; int userid = ShomaRM.Models.ShomaGroupWebSession.CurrentUser != null ? ShomaRM.Models.ShomaGroupWebSession.CurrentUser.UserID : 0; string fullname = ShomaRM.Models.ShomaGroupWebSession.CurrentUser != null ? ShomaRM.Models.ShomaGroupWebSession.CurrentUser.FullName : ""; if (model.TransID == 0) { var saveTransaction = new tbl_Transaction() { TenantID = 0, Transaction_Date = DateTime.Now, CreatedDate = DateTime.Now, Credit_Amount = 0, Description = model.Description, Charge_Date = model.Charge_Date, Charge_Type = Convert.ToInt32(model.Charge_Type), Charge_Amount = model.Charge_Amount, Miscellaneous_Amount = model.Miscellaneous_Amount, Accounting_Date = DateTime.Now, Batch = "1", CreatedBy = userid, UserID = userid, }; db.tbl_Transaction.Add(saveTransaction); db.SaveChanges(); msg = "Transaction Saved Successfully"; } else { var getNOdata = db.tbl_Transaction.Where(p => p.TransID == model.TransID).FirstOrDefault(); if (getNOdata != null) { getNOdata.TenantID = model.TenantID; getNOdata.PAID = model.Transaction_Type; getNOdata.Transaction_Date = model.Transaction_Date; getNOdata.CreatedDate = model.CreatedDate; getNOdata.Credit_Amount = model.Credit_Amount; getNOdata.Description = model.Description; getNOdata.Charge_Date = model.Charge_Date; getNOdata.Charge_Type = Convert.ToInt32(model.Charge_Type); getNOdata.Charge_Amount = model.Charge_Amount; getNOdata.Miscellaneous_Amount = model.Miscellaneous_Amount; getNOdata.Accounting_Date = model.Accounting_Date; getNOdata.Batch = model.Batch; } db.SaveChanges(); msg = "Transaction Updated Successfully"; } db.Dispose(); return(msg); }
public List <TransactionModel> GetProspectTransactionList(long ProspectID) { ShomaRMEntities db = new ShomaRMEntities(); List <TransactionModel> lstpr = new List <TransactionModel>(); try { DataTable dtTable = new DataTable(); using (var cmd = db.Database.Connection.CreateCommand()) { db.Database.Connection.Open(); cmd.CommandText = "usp_GetProspectTransactionList"; cmd.CommandType = CommandType.StoredProcedure; DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter(); da.SelectCommand = cmd; da.Fill(dtTable); db.Database.Connection.Close(); } foreach (DataRow dr in dtTable.Rows) { TransactionModel pr = new TransactionModel(); DateTime?transactiondateString = null; try { transactiondateString = Convert.ToDateTime(dr["Transaction_Date"].ToString()); } catch { } DateTime?createdDateString = null; try { createdDateString = Convert.ToDateTime(dr["CreatedDate"].ToString()); } catch { } DateTime?charge_DateString = null; try { charge_DateString = Convert.ToDateTime(dr["Charge_Date"].ToString()); } catch { } DateTime?accounting_DateString = null; try { accounting_DateString = Convert.ToDateTime(dr["Accounting_Date"].ToString()); } catch { } pr.TransID = Convert.ToInt32(dr["TransID"].ToString()); pr.Transaction_Type = dr["Transaction_Type"].ToString(); pr.Transaction_DateString = transactiondateString == null ? "" : transactiondateString.ToString(); pr.CreatedDateString = createdDateString == null ? "" : createdDateString.ToString(); pr.Credit_Amount = Convert.ToDecimal(dr["Credit_Amount"].ToString()); pr.Description = dr["Description"].ToString(); pr.Charge_DateString = charge_DateString == null ? "" : charge_DateString.ToString(); pr.Charge_Type = dr["Charge_Type"].ToString(); pr.Charge_Amount = Convert.ToDecimal(dr["Charge_Amount"].ToString()); lstpr.Add(pr); } db.Dispose(); return(lstpr.ToList()); } catch (Exception ex) { db.Database.Connection.Close(); throw ex; } }