public ActionResult CreateNewAccount(NewAccountRequestView model, HttpPostedFileBase Image)
{
CustomerDAL customerDALobject = new CustomerDAL();
// ModelState.Clear();
CommonDAL obj = new CommonDAL();
ViewBag.cityList = obj.GetCityList();
if (Image == null)
{
ViewBag.message = "Please upload image first ! ";
return View(model);
}
if (customerDALobject.AddNewAccountRequest(model))
{
ViewBag.message = "Request Submitted. Thank You !";
return View(model);
}
else
{
ViewBag.message = "Oops... Error in submitting request.";
return View(model);
}
}
public bool AddNewAccountRequest(NewAccountRequestView request)
{
bool result = false;
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Database1ConnectionString"].ToString()))
{
int requestID;
SqlCommand command = new SqlCommand("SELECT COUNT(RequestID) FROM NewAccountRequest ", connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows )
{
reader.Read();
requestID = Convert.ToInt16(reader[0]) + 1;
}
else
requestID = 1;
reader.Close();
command.CommandText = String.Format("SELECT CustomerName FROM Customer WHERE CustomerID = " + request.CustomerID);
reader = command.ExecuteReader();
reader.Read();
string customerName = reader[0].ToString();
reader.Close();
command.CommandText = String.Format("INSERT INTO NewAccountRequest(RequestID, BranchCode, CustomerID, SubmissionDate, Status, AddressProof, CustomerName) VALUES('{0}', '{1}', '{2}', '{3}', 'S', '{4}', '{5}') ", requestID, request.Branch, request.CustomerID, DateTime.Now.ToString(), request.AddresProof, customerName);
if (command.ExecuteNonQuery() > 0)
result = true;
}
return result;
}
public ActionResult CreateNewAccount()
{
string result = (new CommonDAL()).CheckValidation("Customer", this.Session);
if (result.Equals("LogIn"))
return RedirectToAction("Login", "CommonBiz");
else if (result.Equals("Unauthorised"))
return RedirectToAction("Unauthorised", "CommonBiz");
CommonDAL obj = new CommonDAL();
NewAccountRequestView model = new NewAccountRequestView();
var customerID = (Session["User"] as UserRole).customerID;
ViewBag.cityList = obj.GetCityList();
model.CustomerID = customerID;
return View(model);
}
