public List <BLL.DTO.TransactionDto> GetCustomerTransactions(int CustomerId, DateTime ToDate, DateTime Fromdate, int isCust)
{
try
{
string sql = "select CustomerId,FromAccount, ToAccount, MerchantId, Amount from Transaction where CustomerId=@CustomerId and Status=@Status and CONVERT(DATE, CreatedOn) BETWEEN @FromDate AND @ToDate order by CreatedOn desc";
MSQconn c = new MSQconn(ConString);
c.SetSQL(sql);
c.AddParam("@CustomerId", CustomerId);
c.AddParam("@FromDate", Fromdate);
c.AddParam("@ToDate", ToDate);
c.AddParam("@Status", 1);
//for customer Status is 1
//for merchant Status is 0
var ds = c.Select();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
var list = Helper.ConvertDataTable <BLL.DTO.TransactionDto>(ds.Tables[0]);
return(list);
}
else
{
// new ErrorLog("Get Customer error: " + ex.ToString());
List <BLL.DTO.TransactionDto> lt = new List <BLL.DTO.TransactionDto>();
return(lt);
}
}
catch (Exception ex)
{
new ErrorLog("Get trxn Customer error: " + ex.ToString());
List <BLL.DTO.TransactionDto> lt = new List <BLL.DTO.TransactionDto>();
return(lt);
//throw;
}
}
public bool ValidateDuplicateEnrollment(MerchantCreation r)
{
try
{
MSQconn con = new MSQconn(ConString);
string sql = "Select * from Merchant where PhoneNumber=@PhoneNumber or SettlementAccount=@SettlementAccount or EmailAddress=@EmailAddress";
con.SetSQL(sql);
// Dbcon.AddParam("@bvn", r.bvn);
con.AddParam("@PhoneNumber", r.PhoneNumber);
con.AddParam("@SettlementAccount", r.SettlementAccount);
con.AddParam("@EmailAddress", r.EmailAddress);
// Dbcon.AddParam("@HandleUsername", r.HandleUsername);
DataSet ds = con.Select();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
//duplicate
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
new ErrorLog("ValidateDuplicateEnrollment error:" + ex.ToString());
return(false);
}
}
public Tuple <bool, List <MerchantCreation> > GetmerchantAcct(string PhoneNumber)
{
string sql = "select * from Merchant where Username=@Username and Status=@Status";
try
{
MSQconn con = new MSQconn(ConString);
con.SetSQL(sql);
con.AddParam("@PhoneNumber", PhoneNumber);
con.AddParam("@Status", 1);
DataSet ds = con.Select();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
//var list = ds.Tables[0].Select().ToArray();
var list = Helper.ConvertDataTable <MerchantCreation>(ds.Tables[0]);
return(Tuple.Create(true, list));
}
else
{
List <MerchantCreation> lt = new List <MerchantCreation>();
return(Tuple.Create(false, lt));
//DataRow[] lt =null;
//return Tuple.Create(true, lt);
}
}
catch (Exception ex)
{
new ErrorLog("Login merchant error: " + ex.ToString());
List <MerchantCreation> lt = new List <MerchantCreation>();
return(Tuple.Create(false, lt));
}
}
public OtpResponse GetOtp(string Otp)
{
OtpResponse response = new OtpResponse();
DataSet ds = null;
try
{
string sql = "select * FROM Otp WHERE GeneratedOtp=@Otp";
MSQconn c = new MSQconn(ConString);
c.SetSQL(sql);
c.AddParam("@Otp", Otp);
ds = c.Select();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
response.Bvn = ds.Tables[0].Rows[0]["Bvn"].ToString();
response.Otp = ds.Tables[0].Rows[0]["GeneratedOtp"].ToString();
response.IsUsed = Convert.ToInt16(ds.Tables[0].Rows[0]["IsUsed"]);
}
}
catch (Exception ex)
{
return(response);
}
return(response);
}
public bool ValidateDuplicateEnrollment(string bvn)
{
try
{
MSQconn con = new MSQconn(ConString);
string sql = "Select * from Customer where BVN=@BVN";
con.SetSQL(sql);
con.AddParam("@BVN", bvn);
DataSet ds = con.Select();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
//duplicate
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
new ErrorLog("ValidateDuplicateEnrollment error:" + ex.ToString());
return(false);
}
}
public Tuple <bool, List <CustomerCreation> > GetCustomer(string BVN)
{
string sql = "select * from Customer where BVN=@BVN and Status=@Status";
try
{
MSQconn con = new MSQconn(ConString);
con.SetSQL(sql);
con.AddParam("@BVN", BVN);
con.AddParam("@Status", 1);
DataSet ds = con.Select();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
//var list = ds.Tables[0].Select().ToArray();
var list = Helper.ConvertDataTable <CustomerCreation>(ds.Tables[0]);
return(Tuple.Create(true, list));
}
else
{
List <CustomerCreation> lt = new List <CustomerCreation>();
return(Tuple.Create(false, lt));
}
}
catch (Exception ex)
{
new ErrorLog("Get customer details error: " + ex.ToString());
List <CustomerCreation> lt = new List <CustomerCreation>();
return(Tuple.Create(false, lt));
}
}
//public DataSet GetIncident(int EmployerId, string Type, DateTime FromDate, DateTime ToDate)
public DataSet GetIncident()
{
DataSet result = null;
try
{
MSQconn con = new MSQconn(ConString);
string sql = @"select * from [Incident]";
con.SetSQL(sql);
//con.AddParam("@EmployerId", EmployerId);
//con.AddParam("@Type", Type);
//con.AddParam("@FromDate", FromDate);
//con.AddParam("@ToDate", ToDate);
result = con.Select();
}
catch (Exception ex)
{
return(null);
}
return(result);
}
public Tuple <bool, List <BvnSearchResp> > GetVoters(string bvn = "")
{
try
{
MSQconn con = new MSQconn(ConString);
string sql = "";
if (bvn == "")
{
sql = @"SELECT *,[BVN],[RegistrationDate],[FirstName],[MiddleName],[DateOfBirth],[Email],[Gender],[LgaOfOrigin],[LgaOfResidence],[ResidentialAddress],[StateOfOrigin],[StateOfResidence],[Base64Image] FROM InecReg";
}
else
{
sql = "select * from InecReg where BVN=@BVN order by desc ";
}
con.SetSQL(sql);
con.AddParam("@BVN", bvn);
// con.AddParam("@Status", 1);
DataSet ds = con.Select();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
var list = Helper.ConvertDataTable <BvnSearchResp>(ds.Tables[0]);
return(Tuple.Create(true, list));
}
else
{
List <BvnSearchResp> lt = new List <BvnSearchResp>();
return(Tuple.Create(false, lt));
}
}
catch (Exception ex)
{
new ErrorLog(ex);
List <BvnSearchResp> lt = new List <BvnSearchResp>();
return(Tuple.Create(false, lt));
}
}
