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