public ActionResult ViewCustomerByCustomerId(Customer cu) { if (!ModelState.IsValid) { DataAccessLayer.DBManager obj = new DataAccessLayer.DBManager(); int temp_id = cu.temp_ID; string temp_search = cu.Customer_Search; int check = obj.checkCustomer(temp_id, temp_search); if (check > 0) { return(RedirectToAction("viewCustbyID", new { data = temp_id, mode = temp_search })); } else { if (Request.HttpMethod == "POST") { TempData["AlertMessage"] = "Requested customer ID is not present in system."; ModelState.Clear(); } return(View()); } } return(View()); }
public ActionResult InsertCustomer(CreateCustomerAccounts2por meth) { if (ModelState.IsValid) { DataAccessLayer.DBManager obj = new DataAccessLayer.DBManager(); int check = obj.checkCustomer(meth.CustomerID, "ByCustomerID"); if (check > 0) { CreateCustomerAccounts2porDbData ab = new CreateCustomerAccounts2porDbData(); int result = ab.insertdata(meth); if (result == 0) { return(RedirectToAction("Exception")); } ViewData["Result"] = result; TempData["AlertMessage"] = "Account is created successfully with " + result + " AccountID"; ModelState.Clear(); return(View()); } else { TempData["AlertMessage"] = "Requested customer ID is not present in system."; return(View()); } } else { return(View()); } }
public void DownloadWordCustomerDetails() { DataAccessLayer.DBManager obj = new DataAccessLayer.DBManager(); Customer cus = new Customer(); cus.storeData = obj.viewCustomerbyID(Convert.ToInt32(Session["data"]), Session["mode"].ToString()); GridView gv = new GridView(); gv.DataSource = cus.storeData; gv.DataBind(); Response.ClearContent(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment;filename=customerdetails.doc"); //Response.ContentType = "application/vnd.ms-word "; //Response.Write(gv); Response.Charset = ""; Response.ContentType = "application/vnd.ms-word "; StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); gv.RenderControl(hw); Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); }
public ActionResult ViewAllCustomer() { DataAccessLayer.DBManager obj = new DataAccessLayer.DBManager(); List <Customer> clist = obj.ViewAllCustomer(); return(View(clist)); }
public ActionResult viewCustbyID(int data, string mode) { DataAccessLayer.DBManager obj = new DataAccessLayer.DBManager(); Customer cus = new Customer(); cus.storeData = obj.viewCustomerbyID(data, mode); return(View(cus)); }
public ActionResult updatecustomer(Customer customer) { DataAccessLayer.DBManager obj = new DataAccessLayer.DBManager(); string result = obj.UpdateCustomer(customer); ViewData["resultupdate"] = result; TempData["notice"] = "Customer update initiated successfully."; return(View()); }
public ActionResult ViewCustomerteller(int data, string mode) { DataAccessLayer.DBManager obj = new DataAccessLayer.DBManager(); Customer cus = new Customer(); Session["data"] = data; Session["mode"] = mode; cus.storeData = obj.viewCustomerbyID(data, mode); return(View(cus)); }
public ActionResult DeleteCustomer(Customer MB) { DataAccessLayer.DBManager objDB = new DataAccessLayer.DBManager(); int result = objDB.deleteCustomer(MB); if (result == 0) { return(RedirectToAction("Exception")); } ViewData["resultDelete"] = result; return(View()); }
public ActionResult DeleteCustomer(int id) { DataAccessLayer.DBManager objDB = new DataAccessLayer.DBManager(); DataSet ds = objDB.viewCustomerbyID(id, "ByCustomerID"); Customer MB = new Customer(); MB.Customer_ssn_Id = Convert.ToInt32(ds.Tables[0].Rows[0]["Customer_SSN_ID"].ToString()); MB.Customer_Id = Convert.ToInt32(ds.Tables[0].Rows[0]["Customer_ID"].ToString()); MB.Customer_Name = ds.Tables[0].Rows[0]["Customer_Name"].ToString(); MB.Customer_Age = Convert.ToInt32(ds.Tables[0].Rows[0]["Customer_Age"].ToString()); MB.Customer_Address = ds.Tables[0].Rows[0]["Customer_Address"].ToString(); return(View(MB)); }
public void DownloadExcel() { DataAccessLayer.DBManager obj = new DataAccessLayer.DBManager(); List <Customer> clist = obj.ViewAllCustomer(); WebGrid grid = new WebGrid(source: clist); string gridData = grid.GetHtml(columns: grid.Columns( grid.Column("Customer_Id", "Customer ID"), grid.Column("Customer_ssn_Id", "Customer SSN ID"), grid.Column("customer_status", "Status"), grid.Column("customer_message", "Message"), grid.Column("update_date", "Last updated") )).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment;filename=customerexcel.xls"); Response.ContentType = "application/excel"; Response.Write(gridData); Response.End(); }
public ActionResult AddCustomer(Customer cu) { try { if (!ModelState.IsValid) { DataAccessLayer.DBManager obj = new DataAccessLayer.DBManager(); int result = obj.addCustomer(cu); ViewData["Result"] = result; TempData["AlertMessage"] = "Customer successfully created with " + result + " Customer Id"; ModelState.Clear(); return(View()); } else { ModelState.AddModelError("", "Error in Saving Data"); return(View()); } } catch (Exception e) { return(RedirectToAction("Exception")); } }