public void LogInecRegistration(BvnSearchResp RegDetails)
{
try
{
string sql = "insert into InecReg (BVN,RegistrationDate, FirstName, MiddleName, DateOfBirth, Email,Gender,LgaOfOrigin,LgaOfResidence,ResidentialAddress,StateOfOrigin,StateOfResidence,Base64Image) values (@BVN,@RegistrationDate, @FirstName, @MiddleName, @DateOfBirth, @Email,@Gender,@LgaOfOrigin,@LgaOfResidence,@ResidentialAddress,@StateOfOrigin,@StateOfResidence,@Base64Image) ";
MSQconn c = new MSQconn(ConString);
c.SetSQL(sql);
c.AddParam("@BVN", RegDetails.BVN);
c.AddParam("@RegistrationDate", RegDetails.RegistrationDate);
c.AddParam("@FirstName", RegDetails.FirstName);
c.AddParam("@MiddleName", RegDetails.MiddleName);
c.AddParam("@DateOfBirth", RegDetails.DateOfBirth);
c.AddParam("@Email", RegDetails.Email);
c.AddParam("@Gender", RegDetails.Gender);
c.AddParam("@LgaOfOrigin", RegDetails.LgaOfOrigin);
c.AddParam("@LgaOfResidence", RegDetails.LgaOfResidence);
c.AddParam("@ResidentialAddress", RegDetails.ResidentialAddress);
c.AddParam("@StateOfOrigin", RegDetails.StateOfOrigin);
c.AddParam("@StateOfResidence", RegDetails.StateOfResidence);
c.AddParam("@Base64Image", RegDetails.Base64Image);
var resp = c.Insert();
int respo = Convert.ToInt32(resp);
}
catch (Exception ex)
{
new ErrorLog(ex.ToString());
//throw;
}
}
public int CreateMerchant(MerchantCreation merchant)
{
//validate duplicate
//insert merchant
try
{
bool duplicated = ValidateDuplicateEnrollment(merchant);
if (duplicated)
{
return(99); //duplicate exists code
}
MSQconn con = new MSQconn(ConString);
string sql = "insert into Merchant (Name,SettlementAccount,PhoneNumber,EmailAddress,Username,Password,CreatedOn,CreatedBy,Status) values (@Name,@SettlementAccount,@PhoneNumber,@EmailAddress,@Username,@Password,@CreatedOn,@CreatedBy,@Status)";
con.SetSQL(sql);
merchant.Password = Helper.Encrypt(merchant.Password);
con.AddParam("@Name", merchant.Name);
con.AddParam("@SettlementAccount", merchant.SettlementAccount);
con.AddParam("@PhoneNumber", merchant.PhoneNumber);
con.AddParam("@EmailAddress", merchant.EmailAddress);
con.AddParam("@Username", merchant.Username);
con.AddParam("@Password", merchant.Password);
con.AddParam("@CreatedOn", merchant.CreatedOn);
con.AddParam("@Status", merchant.Status);
var resp = con.Insert();
int r = Convert.ToInt16(resp);
return(r);
}
catch (Exception ex)
{
new ErrorLog("merchant creation error:" + ex.ToString());
return(99); //error occored
}
}
public Tuple <bool, List <CustomerCreation> > CreateCustomer(CustomerCreation Customer)
{
try
{
//var duplicate = ValidateDuplicateEnrollment(Customer.BVN);
//if (duplicate)
//{
// List<CustomerCreation> lt = new List<CustomerCreation>();
// return Tuple.Create(false, lt);
//}
MSQconn con = new MSQconn(ConString);
if (Customer.MaxAmount < 0)
{
Customer.MaxAmount = Convert.ToDecimal(ConfigurationManager.AppSettings["DefaultMaxAmount"]);
}
Customer.CreatedBy = "TeamDaze Admin";
string sql = @"insert into Customer (FirstName,LastName,BVN,PhoneNumber,EmailAddress,PanicFinger,CreatedBy,Status,
CreatedOn, EnrollmentType, CardType, CardToken) values (@FirstName,@LastName,@BVN,@PhoneNumber,@EmailAddress,@PanicFinger,@CreatedBy,@Status,
@CreatedOn, @EnrollmentType, @CardType, @CardToken)";
con.SetSQL(sql);
con.AddParam("@FirstName", Customer.FirstName);
con.AddParam("@LastName", Customer.LastName);
con.AddParam("@BVN", Customer.BVN);
con.AddParam("@PhoneNumber", Customer.PhoneNumber);
con.AddParam("@EmailAddress", Customer.EmailAddress);
con.AddParam("@PanicFinger", Customer.PanicFinger);
con.AddParam("@CreatedBy", Customer.CreatedBy);
con.AddParam("@MaxAmount", Customer.MaxAmount);
con.AddParam("@Status", 1);
con.AddParam("@CreatedOn", DateTime.Now);
con.AddParam("@EnrollmentType", Customer.EnrollmentType);
con.AddParam("@CardType", Customer.CardType);
con.AddParam("@CardToken", Customer.CardToken);
var resp = con.Insert();
int r = Convert.ToInt16(resp);
if (r == 1)
{
List <CustomerCreation> lt = new List <CustomerCreation>();
lt.Add(Customer);
return(Tuple.Create(true, lt));
}
else
{
List <CustomerCreation> lt = new List <CustomerCreation>();
return(Tuple.Create(false, lt));
}
}
catch (Exception ex)
{
new ErrorLog("Customer creation error:" + ex.ToString());
List <CustomerCreation> lt = new List <CustomerCreation>();
return(Tuple.Create(false, lt));
}
}
public int Insert(string bvn, string otp)
{
int result = 0;
try
{
string sql = "insert into Otp(Bvn,GeneratedOtp) values (@Bvn,@GeneratedOtp)";
MSQconn c = new MSQconn(ConString);
c.SetSQL(sql);
c.AddParam("@Bvn", bvn);
c.AddParam("@GeneratedOtp", otp);
result = Convert.ToInt32(c.Insert());
}
catch (Exception ex)
{
//new ErrorLog(ex.ToString());
//throw;
}
return(result);
}
public long ProfileStaff(int EmployerId, string BVN)
{
int result = 0;
try
{
MSQconn con = new MSQconn(ConString);
string sql = @"insert into Staff (EmployerId,BVN) values (@EmployerId,@BVN)";
con.SetSQL(sql);
con.AddParam("@EmployerId", EmployerId);
con.AddParam("@BVN", BVN);
var resp = con.Insert();
result = Convert.ToInt16(resp);
}
catch (Exception ex)
{
return(0);
}
return(result);
}
public long InsertIncident(int EmployerId, string BVN, string Type)
{
int result = 0;
try
{
MSQconn con = new MSQconn(ConString);
string sql = @"insert into Incident (EmployerId,BVN,Type) values (@EmployerId,@BVN,@Type)";
con.SetSQL(sql);
con.AddParam("@EmployerId", EmployerId);
con.AddParam("@BVN", BVN);
con.AddParam("@Type", Type);
var resp = con.Insert();
result = Convert.ToInt16(resp);
}
catch (Exception ex)
{
return(0);
}
return(result);
}
public void LogTrxn(string CustomerId, string FromAccount, string ToAccount, int MerchantId, string Amount, string Status)
{
try
{
string sql = "insert into Transaction(CustomerId,FromAccount, ToAccount, MerchantId, Amount, Status) values (@CustomerId,@FromAccount, @ToAccount,@MerchantId, @Amount, @Status) ";
MSQconn c = new MSQconn(ConString);
c.SetSQL(sql);
c.AddParam("@CustomerId", CustomerId);
c.AddParam("@FromAccount", FromAccount);
c.AddParam("@ToAccount", ToAccount);
c.AddParam("@MerchantId", MerchantId);
c.AddParam("@Amount", Convert.ToDecimal(Amount));
c.AddParam("@Amount", Amount);
c.AddParam("@Status", Status);
var resp = c.Insert();
int respo = Convert.ToInt32(resp);
}
catch (Exception ex)
{
new ErrorLog(ex.ToString());
//throw;
}
}
public long ProfileEmployer(string Name, string BVN, string Address, string Type)
{
int result = 0;
try
{
MSQconn con = new MSQconn(ConString);
string sql = @"insert into Employer (Name,BVN,Address,Type) values (@Name,@BVN,@Address,@Type)";
con.SetSQL(sql);
con.AddParam("@Name", Name);
con.AddParam("@BVN", BVN);
con.AddParam("@Address", Address);
con.AddParam("@Type", Type);
var resp = con.Insert();
result = Convert.ToInt16(resp);
}
catch (Exception ex)
{
return(0);
}
return(result);
}
