public async Task <bool> UpdateAccount(AccountDetailsModel model, BankDetail bankDetail)
{
try
{
//Confirm the existence of the account number
var checkAccountNumber = await _accountManager.ExistsAccount(model.AccountNumber, model.ID);
if (checkAccountNumber)
{
throw new AccountDetailsAlreadyExistException($"Account number { model.AccountNumber } already exist");
}
AccountDetail accountDetails = await _accountManager.GetAccountById(model.ID);
_log.Warn($"Old account details::: {JsonConvert.SerializeObject(accountDetails)}");
accountDetails.Id = model.ID;
accountDetails.AccountName = model.AccountName;
accountDetails.AccountNumber = model.AccountNumber;
accountDetails.BankDetail = new BankDetail {
Name = bankDetail.Name, Code = bankDetail.Code, Id = model.BankId
};
accountDetails.UpdatedAtUtc = DateTime.Now;
await _accountManager.UpdateAccount(accountDetails);
_log.Warn($"New account details::: {JsonConvert.SerializeObject(accountDetails)}");
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult PutBankDetail(int id, BankDetail bankDetail)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != bankDetail.bank_id)
{
return(BadRequest());
}
db.Entry(bankDetail).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!BankDetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
//public HttpResponseMessage Register(string Email, string password, string Name, string PhoneNumber, string username,
// string Address, string CardType, string BankName, string AccountNumber, string IFSCCode)
public HttpResponseMessage Registertest([FromBody] regandlogin ub)
{
project1Entities db = new project1Entities();
UserTable tabledata = new UserTable();
var emailAlreadyExists = db.UserTables.Find(ub.Email);
if (emailAlreadyExists != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Already Exists!"));
}
tabledata.Email = ub.Email;
tabledata.password = ub.password;
tabledata.Name = ub.Name;
tabledata.PhoneNumber = ub.PhoneNumber;
tabledata.username = ub.username;
tabledata.validation = ub.validation;
tabledata.Address = ub.Address;
tabledata.CardType = ub.CardType;
db.UserTables.Add(tabledata);
db.SaveChanges();
BankDetail data = new BankDetail();
data.Email = ub.Email;
data.BankName = ub.BankName;
data.AccountNumber = ub.AccountNumber;
data.IFSCCode = ub.IFSCCode;
db.BankDetails.Add(data);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, ub));
}
public int AddBankDetails(Guid accountId, string payee_first_name, string payee_last_name, string payee_bank_name, string payee_bank_account, string payee_bank_ifsc, string payee_bank_branch)
{
logic = new GeneralLogics();
BankQueriesCommands BankCQ = new BankQueriesCommands();
BankDetail bd = new BankDetail();
bd.Id = logic.CreateUniqueId();
bd.Account_Id = accountId;
bd.PayeeFirstName = payee_first_name;
bd.PayeeLastName = payee_last_name;
bd.PayeeBankName = payee_bank_name;
bd.PayeeBankAccountNumber = payee_bank_account;
bd.PayeeBankIfscNumber = payee_bank_ifsc;
bd.PayeeBankBranch = payee_bank_branch;
bd.Detail_Submitted_At = logic.CurrentIndianTime();
var result = BankCQ.AddBankDetails(bd);
if (result == 1)
{
//Operation completed successfully
return(1);
}
else
{
//Error occured while adding the data in the database
return(0);
}
}
public ActionResult EditBank(BankDetail bd)
{
using (con)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_EDITBANK", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
cmd.Parameters.AddWithValue("@Empid", bd.Empid);
cmd.Parameters.AddWithValue("@BankName", bd.BankName);
cmd.Parameters.AddWithValue("@AccountNo", bd.AccountNo);
cmd.Parameters.AddWithValue("@BasicSalary", bd.BasicSalary);
cmd.Parameters.AddWithValue("@HRA", bd.HRA);
cmd.Parameters.AddWithValue("@OtherAllowances", bd.OtherAllowances);
cmd.Parameters.AddWithValue("@PF", bd.PF);
cmd.Parameters.AddWithValue("@MedicalPremium", bd.MedicalPremium);
cmd.Parameters.AddWithValue("@TDS", bd.TDS);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
return(RedirectToAction("ListBankDetails"));
}
public ActionResult ToAccount(BankDetail bankDetails)
{
string SenderPhoneNumber = (string)TempData.Peek("PhoneNumber");
var ReceiversDetails = context.CustomerBankDetailsConfidentials.Single(ReceiverConfirmation => ReceiverConfirmation.AccountNumber == bankDetails.AccountNumber && ReceiverConfirmation.IFSC == bankDetails.IFSC);
double PresentBalance = Convert.ToDouble(ReceiversDetails.Balance);
var SendersDetails = context.CustomerBankDetailsConfidentials.Single(SendingUserPhoneNumber => SendingUserPhoneNumber.PhoneNumber == SenderPhoneNumber);
var UPIDetailsofSender = context.UPIs.Single(FetchDetails => FetchDetails.PhoneNumber == SenderPhoneNumber);
if (UPIDetailsofSender.UPIPin == null)
{
return(RedirectToAction("CreateUPIPin", "Home"));
}
else if (SendersDetails.AccountNumber == bankDetails.AccountNumber)
{
ViewBag.Message = "Cannot transfer to self.";
}
else if (bankDetails.Amount > PresentBalance)
{
ViewBag.Message = "Insufficient Balance.";
}
else if (bankDetails.Amount > 20000)
{
ViewBag.Message = "Cannot transfer more than Rs.20000.";
}
else
{
TempData["ReceiversAccNo"] = ReceiversDetails.AccountNumber;
TempData["ReceiversIFSC"] = ReceiversDetails.IFSC;
TempData["AmountToSend"] = bankDetails.Amount;
return(RedirectToAction("ValidateUPIPINForAccount", "Home"));
}
return(View());
}
public async Task <bool> PostBank(BankDetail model)
{
HttpClient client = new HttpClient();
BankDetail details = new BankDetail();
details.user_id = model.user_id;
details.bank_Name = model.bank_Name;
details.branch_no = model.branch_no;
details.acc_no = model.acc_no;
details.acc_Type = model.acc_Type;
details.acc_holder = model.acc_holder;
details.card_no = model.card_no;
details.cvv = model.cvv;
details.exp_Date = model.exp_Date;
details.phone_no = model.phone_no;
var json = JsonConvert.SerializeObject(details);
HttpContent content = new StringContent(json);
content.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue("application/json");
var token = Settings.accessToken;
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue(
"Bearer", token);
var response = await client.PostAsync(APIservices.url + "/api/BankDetails", content);
return(response.IsSuccessStatusCode);
}
public async Task <bool> UpdatePayment(BankDetail bankModel, int id)
{
BankDetail bankObj = new BankDetail();
bankObj.bank_id = bankModel.bank_id;
bankObj.user_id = bankModel.user_id;
bankObj.acc_holder = bankModel.acc_holder;
bankObj.phone_no = bankModel.phone_no;
bankObj.acc_no = bankModel.acc_no;
bankObj.card_no = Convert.ToInt32(bankModel.card_no);
bankObj.acc_Type = bankModel.acc_Type;
bankObj.branch_no = bankModel.branch_no;
bankObj.cvv = bankModel.cvv;
bankObj.exp_Date = bankModel.exp_Date;
bankObj.bank_Name = bankModel.bank_Name;
var json = JsonConvert.SerializeObject(bankObj);
var content = new StringContent(json, Encoding.UTF8, "application/json");
HttpClient client = new HttpClient();
var token = Settings.accessToken;
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue(
"Bearer", token);
var result = await client.PutAsync(string.Concat(APIservices.url + "/api/BankDetails/", bankObj.bank_id), content);
return(result.IsSuccessStatusCode);
}
public ActionResult EditBank(BankDetail bd)
{
using (con)
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_EDITBANK", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
cmd.Parameters.AddWithValue("@Empid", bd.Empid);
// cmd.Parameters.AddWithValue("@EmpName", emp.EmpName);
//cmd.Parameters.AddWithValue("@DeptName", dept.DeptName);
cmd.Parameters.AddWithValue("@BankName", bd.BankName);
cmd.Parameters.AddWithValue("@AccountNo", bd.AccountNo);
cmd.Parameters.AddWithValue("@BasicSalary", bd.BasicSalary);
cmd.Parameters.AddWithValue("@HRA", bd.HRA);
cmd.Parameters.AddWithValue("@OtherAllowances", bd.OtherAllowances);
// cmd.Parameters.AddWithValue("@GrossSalary", bd);
cmd.Parameters.AddWithValue("@PF", bd.PF);
cmd.Parameters.AddWithValue("@MedicalPremium", bd.MedicalPremium);
cmd.Parameters.AddWithValue("@TDS", bd.TDS);
//cmd.Parameters.AddWithValue("@NetSalary", bd.NetSalary);
//bd.Gross();
cmd.ExecuteNonQuery();
}
return(RedirectToAction("ListBankDetails"));
}
public int AddBankDetail(BankDetail detail)
{
_context.BankDetails.Add(detail);
_context.SaveChanges();
return(detail.Id);
}
public List <BankDetail> GetFeedBackBankDetails(string referenceNumber)
{
BankDetail searchModel = new BankDetail {
FilterReferenceNumber = referenceNumber.Trim()
};
List <BankDetail> result = new List <BankDetail>();
try
{
result = Shared.da.ExecuteQuery <BankDetail>("sp_SpotsAccountType", searchModel);
}
catch (SqlException sqlexp)
{
if (log.IsErrorEnabled)
{
log.Error(sqlexp.ToString());
}
}
catch (Exception exp)
{
if (log.IsErrorEnabled)
{
log.Error(exp.ToString());
}
}
return(result);
}
public ActionResult DeleteConfirmed(int id)
{
BankDetail bankDetail = db.BankDetails.Find(id);
db.BankDetails.Remove(bankDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult SaveBank(BankDetail bankDetail)
{
using (ManagerEntities5 db = new ManagerEntities5())
{
db.BankDetails.Add(bankDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
BankDetail bankDetail = await _db.BankDetails.FindAsync(id);
_db.BankDetails.Remove(bankDetail);
await _db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult Edit(BankDetail objBankDetail)
{
if (ModelState.IsValid)
{
BankDetailBLL objBankDetailBLL = new BankDetailBLL();
objBankDetailBLL.UpdateBankDetail(objBankDetail);
}
return(RedirectToAction("Index", "BankDetail"));
}
public ActionResult EditTransactionPassword(string OldTransactionPassword, string NewTransactionPassword, string ConfirmTransactionNewPassword)
{
ViewBag.Title = "Admin: Change Password";
ViewBag.ErrorMessage = false;
try
{
if (NewTransactionPassword == ConfirmTransactionNewPassword)
{
BankDetail bankDetail = _valleyDreamsIndiaDBEntities.BankDetails.First(x => x.UsersDetailsId == CurrentUser.CurrentUserId && x.Deleted == 0);
if (bankDetail.TransactionPassword == OldTransactionPassword)
{
bankDetail.TransactionPassword = NewTransactionPassword;
bankDetail.UpdatedOn = DateTime.Now;
_valleyDreamsIndiaDBEntities.Entry(bankDetail).State = EntityState.Modified;
_valleyDreamsIndiaDBEntities.SaveChanges();
ViewBag.TransactionErrorMessage = true;
string phoneNumber = (_valleyDreamsIndiaDBEntities.PersonalDetails.Where(x => x.UsersDetailsId == CurrentUser.CurrentUserId).FirstOrDefault()).PhoneNumber1;
string textMessage = String.Format("Your new transaction password is {0}", NewTransactionPassword);
string smsStatus = SmsProvider.SendSms(phoneNumber, textMessage);
if (smsStatus == "Success")
{
ViewBag.SmsStatus = "New Transaction Password Sent To Your Registered Mobile Number Successfully";
}
else
{
ViewBag.SmsStatus = "Sended Sms Failed";
}
ViewBag.TransactionError = "Transaction Password Updated";
return(View("~/Views/Members/User/Edit.cshtml"));
}
else
{
ViewBag.TransactionErrorMessage = true;
ViewBag.TransactionError = "Transaction Old Password Mismatched";
return(View("~/Views/Members/User/Edit.cshtml"));
}
}
else
{
ViewBag.TransactionErrorMessage = true;
ViewBag.TransactionError = "New And Confirm Transaction New Password Mismatched";
return(View("~/Views/Members/User/Edit.cshtml"));
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <ActionResult> Edit([Bind(Include = "BankDetailId,UserId,AccountName,AccountNumber,BankName,AccountType,IsPrimary")] BankDetail bankDetail)
{
if (ModelState.IsValid)
{
_db.Entry(bankDetail).State = EntityState.Modified;
await _db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(bankDetail));
}
public void UpdateBank(BankBO bank)
{
var bankDetails = new BankDetail
{
Name = bank.Name,
Code = bank.Code
};
_unitOfWork.BankTable.UpdateSingle(bank.Id, bankDetails);
_unitOfWork.Commit();
}
public async Task <ActionResult> Create([Bind(Include = "BankDetailId,UserId,AccountName,AccountNumber,BankName,AccountType,IsPrimary")] BankDetail bankDetail)
{
if (ModelState.IsValid)
{
_db.BankDetails.Add(bankDetail);
await _db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(bankDetail));
}
public IHttpActionResult PostBankDetail(BankDetail bankDetail)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.BankDetails.Add(bankDetail);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = bankDetail.bank_id }, bankDetail));
}
public bool RemoveBankDetail(int Id)
{
BankDetail bank = GetBankDetailById(Id);
if (bank == null)
{
return(false);
}
_context.Remove(bank);
_context.SaveChanges();
return(true);
}
public ActionResult Edit()
{
ViewBag.Title = "Admin: Bank Info";
ViewBag.Message = "";
try
{
BankDetail bankDetail = _valleyDreamsIndiaDBEntities.BankDetails.First(x => x.UsersDetailsId == CurrentUser.CurrentUserId && x.Deleted == 0);
return(View("~/Views/Members/Bank/Edit.cshtml", bankDetail));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult DeleteBank(BankDetail bd)
{
using (con)
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_Delete_Bank", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
cmd.Parameters.AddWithValue("@Empid", bd.Empid);
// return RedirectToAction("ListBankDetails");
cmd.ExecuteNonQuery();
}
return(RedirectToAction("ListBankDetails"));
}
public async Task <bool> updateBankDetails(int id, BankDetail details)
{
var client = new HttpClient();
var json = JsonConvert.SerializeObject(details);
HttpContent content = new StringContent(json);
content.Headers.ContentType = new MediaTypeHeaderValue("application/json");
var response = await client.PutAsync(url + "/api/BankDetails/" + id, content);
return(response.IsSuccessStatusCode);
}
// GET: BankDetails/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BankDetail bankDetail = await _db.BankDetails.FindAsync(id);
if (bankDetail == null)
{
return(HttpNotFound());
}
return(View(bankDetail));
}
public IHttpActionResult DeleteBankDetail(int id)
{
BankDetail bankDetail = db.BankDetails.Find(id);
if (bankDetail == null)
{
return(NotFound());
}
db.BankDetails.Remove(bankDetail);
db.SaveChanges();
return(Ok(bankDetail));
}
public ActionResult Edit(UsersPersonalModelView usersPersonalModelView, HttpPostedFileBase memberImage)
{
ViewBag.Title = "Admin: Profile Settings";
try
{
PersonalDetail personalDetails = _valleyDreamsIndiaDBEntities.PersonalDetails
.Where(x => x.UsersDetailsId == usersPersonalModelView.UserDetails.Id).FirstOrDefault();
BankDetail bankDetails = _valleyDreamsIndiaDBEntities.BankDetails
.Where(x => x.UsersDetailsId == usersPersonalModelView.UserDetails.Id).FirstOrDefault();
if (memberImage != null)
{
string randomImageName = Guid.NewGuid().ToString().Substring(0, 5) + memberImage.FileName;
personalDetails.ProfilePic = "/UploadedTeamImages/" + randomImageName;
memberImage.SaveAs(Server.MapPath("~/UploadedTeamImages/") + randomImageName);
}
personalDetails.BirthDate = usersPersonalModelView.PersonalDetails.BirthDate;
personalDetails.PhoneNumber2 = usersPersonalModelView.PersonalDetails.PhoneNumber2;
personalDetails.Email = usersPersonalModelView.PersonalDetails.Email;
personalDetails.State = usersPersonalModelView.PersonalDetails.State;
personalDetails.District = usersPersonalModelView.PersonalDetails.District;
personalDetails.City = usersPersonalModelView.PersonalDetails.City;
personalDetails.PinCode = usersPersonalModelView.PersonalDetails.PinCode;
personalDetails.UpdatedOn = DateTime.Now;
_valleyDreamsIndiaDBEntities.Entry(personalDetails).State = EntityState.Modified;
bankDetails.NomineeName = usersPersonalModelView.BankDetails.NomineeName;
bankDetails.NomineeRelation = usersPersonalModelView.BankDetails.NomineeRelation;
bankDetails.BankName = usersPersonalModelView.BankDetails.BankName;
bankDetails.AccountHolderName = usersPersonalModelView.BankDetails.AccountHolderName;
bankDetails.AccountNumber = usersPersonalModelView.BankDetails.AccountNumber;
bankDetails.IFSCCode = usersPersonalModelView.BankDetails.IFSCCode;
bankDetails.PANNumber = usersPersonalModelView.BankDetails.PANNumber;
bankDetails.UpdatedOn = DateTime.Now;
_valleyDreamsIndiaDBEntities.Entry(bankDetails).State = EntityState.Modified;
_valleyDreamsIndiaDBEntities.SaveChanges();
return(RedirectToAction("ViewProfile", new { currentId = usersPersonalModelView.UserDetails.Id }));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult ContributionPost(string transactionPassword)
{
try
{
BankDetail bankDetail = _valleyDreamsIndiaDBEntities.BankDetails.First(x => x.UsersDetailsId == CurrentUser.CurrentUserId && x.Deleted == 0);
if (bankDetail.TransactionPassword == transactionPassword)
{
ContributionDetail ContributionDetails = _valleyDreamsIndiaDBEntities.ContributionDetails
.Where(x => x.UserDetailsId == CurrentUser.CurrentUserId)
.OrderByDescending(x => x.NextContribNumber).FirstOrDefault();
ContributionDetail contributionDetails = new ContributionDetail();
contributionDetails.ContribNumber = ContributionDetails.NextContribNumber;
contributionDetails.ContribDate = DateTime.Now;
contributionDetails.ContribAmount = 1000;
contributionDetails.NextContribNumber = ContributionDetails.NextContribNumber + 1;
contributionDetails.NextContribDate = new DateTime(DateTime.Now.AddMonths(1).Year, DateTime.Now.AddMonths(1).Month, 20);
contributionDetails.RemainingContrib = 15 - ContributionDetails.NextContribNumber;
contributionDetails.UserDetailsId = CurrentUser.CurrentUserId;
contributionDetails.SponsoredId = bankDetail.UsersDetail.SponsoredId;
contributionDetails.PayedBy = "SELF";
contributionDetails.IsCompleted = (contributionDetails.ContribNumber != 15) ? 0 : 1;
_valleyDreamsIndiaDBEntities.ContributionDetails.Add(contributionDetails);
_valleyDreamsIndiaDBEntities.SaveChanges();
RenewalPinDetail renewalPinDetail = _valleyDreamsIndiaDBEntities.RenewalPinDetails.Where(x => x.SponsoredId == CurrentUser.CurrentUserId &&
x.IsPinUsed == 0).OrderBy(x => x.PinCreatedOn).FirstOrDefault();
renewalPinDetail.IsPinUsed = 1;
_valleyDreamsIndiaDBEntities.Entry(renewalPinDetail).State = System.Data.Entity.EntityState.Modified;
_valleyDreamsIndiaDBEntities.SaveChanges();
ViewBag.OwnRenewalMessage = "Renewal Transfer Successfully ";
UsersPersonalModelView usersPersonalModelView = GetContributionData();
return(View("~/Views/Members/Renewal/Contribution.cshtml", usersPersonalModelView));
}
ViewBag.OwnRenewalMessage = "Mismatched Transaction Password";
UsersPersonalModelView usersPersonalModelView1 = GetContributionData();
return(View("~/Views/Members/Renewal/Contribution.cshtml", usersPersonalModelView1));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public bool UpdateBankDetail(int Id, BankDetail detail)
{
BankDetail existbank = GetBankDetailById(Id);
if (existbank == null)
{
return(false);
}
existbank.Name = detail.Name;
existbank.AccountNumber = detail.AccountNumber;
existbank.AccountTreeId = detail.AccountTreeId;
_context.Update(existbank);
_context.SaveChanges();
return(true);
}
public ActionResult Edit([Bind(Include = "BankDetailsId,VendorId,AccountHolderName,AccountNumber,ConfirmAccountNumber,IFSC,BankName,State,City,CreatedBy,CreatedOn,UpdatedBy,UpdatedOn")] BankDetailsVendor bankDetailsVendor, int id)
{
if (ModelState.IsValid)
{
BankDetail bankDetail = db.BankDetails.Find(id);
bankDetail.BankName = bankDetailsVendor.BankName;
bankDetail.AccountHolderName = bankDetailsVendor.AccountHolderName;
bankDetail.AccountNumber = bankDetailsVendor.AccountNumber;
bankDetail.IFSC = bankDetailsVendor.IFSC;
db.Entry(bankDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
// ViewBag.VendorId = new SelectList(db.Vendors, "VendorId", "FirstName", bankDetail.VendorId);
return(View(bankDetailsVendor));
}
