public ActionResult Index() { CustomerBAL cust = new CustomerBAL(); ViewBag.Customers = cust.Customers; return(View()); }
public int UpdateCustomer(CustomerBAL CB) { try { using (C.Con) { MySqlCommand cmd = new MySqlCommand("UpdateCustomers", C.Con) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.Add(new MySqlParameter("CU_ID", CB.CustomerID)); cmd.Parameters.Add(new MySqlParameter("C_Name", CB.CustomerName)); cmd.Parameters.Add(new MySqlParameter("C_Address", CB.Address)); cmd.Parameters.Add(new MySqlParameter("C_City", CB.City)); cmd.Parameters.Add(new MySqlParameter("C_Contact", CB.Contact)); cmd.Parameters.Add(new MySqlParameter("C_Mail", CB.MailID)); cmd.Connection.Open(); int Result = cmd.ExecuteNonQuery(); C.Con.Close(); return(Result); } } catch (Exception ex) { MessageBox.Show(ex.Message); throw; } }
protected void grdCustomer_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "EDT") { int rowIndex = Convert.ToInt32(e.CommandArgument); grdCustomer.SelectedIndex = rowIndex; hdnCustomerID.Value = ((HiddenField)grdCustomer.Rows[rowIndex].FindControl("hdnCustomerID")).Value; txtFirstName.Text = ((LinkButton)grdCustomer.Rows[rowIndex].FindControl("lnkFirstName")).Text; txtLastName.Text = ((HyperLink)grdCustomer.Rows[rowIndex].FindControl("hypLastName")).Text; txtBirthDate.Text = ((Label)grdCustomer.Rows[rowIndex].FindControl("lblBirthDate")).Text; txtEmail.Text = ((Label)grdCustomer.Rows[rowIndex].FindControl("lblEmail")).Text; txtAddress.Text = ((Label)grdCustomer.Rows[rowIndex].FindControl("lblAddress")).Text; } else if (e.CommandName == "DLT") { int rowIndex = Convert.ToInt32(e.CommandArgument); hdnCustomerID.Value = ((HiddenField)grdCustomer.Rows[rowIndex].FindControl("hdnCustomerID")).Value; CustomerBAL obj = new CustomerBAL(); int retVal = obj.DeleteCustomer(Convert.ToInt64(hdnCustomerID.Value)); obj = null; if (retVal > 0) { BindGrid(); ClearControls(); Page.ClientScript.RegisterStartupScript(this.GetType(), "Deleted", "<script>alert('Deleted successfully.');</script>"); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "Deleted", "<script>alert('Error while deleting.');</script>"); } } }
public void GetCustomer(Int64 customerID) { //List<CustomerBAL> lst = new List<CustomerBAL>(); DataTable dt = new DataTable(); CustomerBAL obj = new CustomerBAL(); dt = obj.GetCustomer(customerID); obj = null; if (dt.Rows.Count > 0) { divResult.Attributes.Add("class", "show"); divNoRecord.Attributes.Add("class", "hide"); hdnCustomerID.Value = dt.Rows[0]["CustomerID"].ToString(); lblFirstName.Text = dt.Rows[0]["FirstName"].ToString(); lblLastName.Text = dt.Rows[0]["LastName"].ToString(); lblBirthDate.Text = Convert.ToDateTime(dt.Rows[0]["BirthDate"]).ToShortDateString(); lblEmail.Text = dt.Rows[0]["Email"].ToString(); lblAddress.Text = dt.Rows[0]["Address"].ToString(); } else { divResult.Attributes.Add("class", "hide"); divNoRecord.Attributes.Add("class", "show"); } }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { CustomerBAL obj = new CustomerBAL(); obj.CustomerID = Convert.ToInt64(hdnCustomerID.Value); obj.FirstName = txtFirstName.Text.Trim(); obj.LastName = txtLastName.Text.Trim(); // obj.BirthDate = Convert.ToDateTime(txtBirthDate.Text.Trim()); //obj.BirthDate = Convert.ToDateTime((txtBirthDate.Text).ToString()); obj.BirthDate = DateTime.ParseExact(this.txtBirthDate.Text, "dd/MM/yyyy", null); obj.Email = txtEmail.Text.Trim(); obj.Address = txtAddress.Text.Trim(); int retVal = obj.InsertUpdateCustomer(obj); obj = null; if (retVal > 0) { BindGrid(); ClearControls(); Page.ClientScript.RegisterStartupScript(this.GetType(), "Saved", "<script>alert('Saved successfully.');</script>"); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "Saved", "<script>alert('Error while saving.');</script>"); } } }
private void Search() { SqlInt32 CustomerID = SqlInt32.Null; SqlString MobileNo = SqlString.Null; SqlInt32 ProductID = SqlInt32.Null; if (ddlCustomerID.SelectedIndex > 0) { CustomerID = Convert.ToInt32(ddlCustomerID.SelectedValue); } if (txtMobileSerch.Text.Trim() != "") { MobileNo = Convert.ToString(txtMobileSerch.Text.Trim()); } if (ddlProductID.SelectedIndex > 0) { ProductID = Convert.ToInt32(ddlProductID.SelectedValue); } CustomerBAL balCustomer = new CustomerBAL(); DataTable dtCustomer = balCustomer.CustomerSelectSearch(CustomerID, MobileNo, ProductID); if (dtCustomer != null && dtCustomer.Rows.Count > 0) { gvCustomer.DataSource = dtCustomer; gvCustomer.DataBind(); } else { gvCustomer.DataSource = null; gvCustomer.DataBind(); } }
public Service1() { Abal = new AccountsBAL(); Cbal = new CustomerBAL(); Tbal = new TransactionBAL(); mapper = config.CreateMapper(); }
public static void FillDropDownListCustomerID(DropDownList ddl, SqlInt32 UserID) { CustomerBAL balCustomer = new CustomerBAL(); ddl.DataSource = balCustomer.SelectDropDownList(UserID); ddl.DataTextField = "CustomerName"; ddl.DataValueField = "CustomerID"; ddl.DataBind(); ddl.Items.Insert(0, new ListItem("---Select Customer---", "-99")); }
public ActionResult MyFirstViewMethod() { CustomerBAL b = new CustomerBAL(); Customer c = b.GetCustomer(); //string cadena = "Data Source=Desarrollo; Initial Catalog =pruebas; User ID=sa;Password=sa"; //SqlConnection conectarBD = new SqlConnection(); //conectarBD.ConnectionString = cadena; //conectarBD.Open(); //conexionBD conBD = new conexionBD(); //conBD.abrir(); //SqlCommand com = new SqlCommand("select * from cliente", conBD.conectarBD); //listaUsuarios = com.ExecuteScalar(); // var usuario = listaUsuarios.FirstOrDefault(f => f.Nombre == "Prodensa"); DataBasepruebas conbd = new DataBasepruebas(); var listaClientes = (from d in conbd.Cliente select new ListaCliente { IdCliente = d.IdCliente, Numero = d.Numero, Nombre = d.Nombre } ).ToList(); //var listaClientes = conbd.Cliente.ToList(); //var Cliente = conbd.Cliente.FirstOrDefault(f => f.Nombre == "Prodensa"); //return new JsonResult //{ // JsonRequestBehavior = JsonRequestBehavior.AllowGet, // //Data = listaClientes // Data = Cliente //}; //var count = (int)com.ExecuteScalar(); //ViewData["TotalData"] = count; //string CustomerName = "Mr ABC."; ////ViewData["MyData"] = CustomerName; //ViewBag.MyData = "CustomerName"; //ViewBag.CustomerData = c; //conBD.cerrar(); //conectarBD.Close(); return(View("MyFirstView", listaClientes)); }
private void FillCustomerGridView() { if (Session["UserID"] != null) { CustomerBAL balCustomer = new CustomerBAL(); DataTable dtCustomer = balCustomer.SelectAll(); if (dtCustomer != null && dtCustomer.Rows.Count > 0) { gvCustomer.DataSource = dtCustomer; gvCustomer.DataBind(); } } }
private void GetMaritalStatus() { List <MaritalStatus> maritalStatuses = CustomerBAL.GetMaritalStatus(); if ((maritalStatuses != null) && maritalStatuses.Count > 0) { Response.Write(maritalStatuses.ToJSON()); } else { Response.Write("No Result"); } }
private void GetCityList() { List <City> cities = CustomerBAL.GetCity(); if ((cities != null) && cities.Count > 0) { Response.Write(cities.ToJSON()); } else { Response.Write("No Result"); } }
private void GetBrgyListPerCity() { List <Barangay> brgys = CustomerBAL.GetBrgyPerCity(Request.QueryString); if ((brgys != null) && brgys.Count > 0) { Response.Write(brgys.ToJSON()); } else { Response.Write("No Result"); } }
private void GetCityListByBranch() { List <CityPerBranch> ctperbrnch = CustomerBAL.GetCityPerBranch(Request.QueryString); if ((ctperbrnch != null) && ctperbrnch.Count > 0) { Response.Write(ctperbrnch.ToJSON()); } else { Response.Write("No Result"); } }
private void CheckCustomerExist() { List <CheckCustomerExist> Exist = CustomerBAL.CheckCustomerExist(Request.QueryString); if ((Exist != null) && Exist.Count > 0) { Response.Write(Exist.ToJSON()); } else { Response.Write("No Result"); } }
private void GetCustomerID() { List <Customer> customers = CustomerBAL.GetCustomerID(Request.QueryString); if ((customers != null) && customers.Count > 0) { Response.Write(customers.ToJSON()); } else { Response.Write("No Result"); } }
public ActionResult MyFirstView() { CustomerBAL b = new CustomerBAL(); Customer c = b.GetCustomer(); ViewBag.CustomerData = c; //string CustomerName = "Mr. ABC"; //ViewData["MyData"] = CustomerName; ////ViewBag.MyData = CustomerName; //return View("MyFirstView"); return(View()); }
protected void gvCustomer_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "DeleteRecord" && e.CommandArgument != null) { CustomerBAL balCustomer = new CustomerBAL(); if (balCustomer.Delete(Convert.ToInt32(e.CommandArgument))) { FillCustomerGridView(Convert.ToInt32(Session["UserID"])); } else { lblMessage.Text = balCustomer.Message; } } }
protected void btnSave_Click(object sender, EventArgs e) { #region ServerSide Validation #endregion ServerSide Validations CustomerENT entCustomer = new CustomerENT(); CustomerBAL balCustomer = new CustomerBAL(); #region Gather Data if (txtCustomerName.Text.Trim() != String.Empty) { entCustomer.CustomerName = txtCustomerName.Text.Trim(); } if (txtEmailAddress.Text.Trim() != String.Empty) { entCustomer.EmailID = txtEmailAddress.Text.Trim(); } if (txtMobileNo.Text.Trim() != String.Empty) { entCustomer.MobileNo = txtMobileNo.Text.Trim(); } if (txtAddress.Text.Trim() != String.Empty) { entCustomer.Address = txtAddress.Text.Trim(); } entCustomer.CreationDate = DateTime.Now; entCustomer.UserID = Convert.ToInt32(Session["UserID"]); if (Request.QueryString["CustomerID"] == null) { balCustomer.Insert(entCustomer); lblMessage.Text = "Data Insert SuccessFully"; ClearControl(); } else { entCustomer.CustomerID = Convert.ToInt32(Request.QueryString["CustomerID"]); balCustomer.Update(entCustomer); Response.Redirect("~/AdminPanel/Customer/CustomerList.aspx"); } #endregion Gather Data }
private void LoadControls(SqlInt32 CustomerID) { CustomerENT entCustomer = new CustomerENT(); CustomerBAL balCustomer = new CustomerBAL(); entCustomer = balCustomer.SelectByPK(CustomerID); if (!entCustomer.CustomerName.IsNull) { txtCustomerName.Text = entCustomer.CustomerName.Value.ToString(); } if (!entCustomer.MobileNo.IsNull) { txtMobileNo.Text = entCustomer.MobileNo.Value.ToString(); } if (!entCustomer.Address.IsNull) { txtCustomerAddress.Text = entCustomer.Address.Value.ToString(); } if (!entCustomer.BranchID.IsNull) { ddlBranchID.SelectedValue = entCustomer.BranchID.Value.ToString(); } if (!entCustomer.DistributorID.IsNull) { ddlDistributorID.SelectedValue = entCustomer.DistributorID.Value.ToString(); } if (!entCustomer.ProductID.IsNull) { ddlProductID.SelectedValue = entCustomer.ProductID.Value.ToString(); } if (!entCustomer.Quantity.IsNull) { txtQuantity.Text = entCustomer.Quantity.Value.ToString(); } if (!entCustomer.BottlePrice.IsNull) { txtAmount.Text = entCustomer.BottlePrice.Value.ToString(); } }
private void FillCustomerGridView(SqlInt32 UserID) { CustomerBAL balCustomer = new CustomerBAL(); DataTable dtCustomer = balCustomer.SelectAll(UserID); if (dtCustomer != null && dtCustomer.Rows.Count > 0) { gvCustomer.DataSource = dtCustomer; gvCustomer.DataBind(); lblMessage.Text = "No Of Record : " + dtCustomer.Rows.Count.ToString(); } else { lblMessage.Text = "No Data Here"; } }
private void BtnUpdate_Click(object sender, EventArgs e) { CustomerDAL CD = new CustomerDAL(); CustomerBAL CB = new CustomerBAL(); if (TxtCustomerName.Text.Trim() != "") { CB.CustomerName = TxtCustomerName.Text.Trim(); if (TxtAddress.Text.Trim() != "") { CB.Address = TxtAddress.Text.Trim(); if (TxtCity.Text.Trim() != "") { CB.CustomerID = Customer_ID; CB.City = TxtCity.Text.Trim(); CB.Contact = TxtContact.Text.Trim(); CB.MailID = TxtMailID.Text.Trim(); int Result = CD.UpdateCustomer(CB); if (Result > 0) { MessageBox.Show("Customer Updated Successfully"); LoadDGVCustomers(); } else { MessageBox.Show("Oops Something Wwent Wrong"); } } else { MessageBox.Show("Please Enter the City Name"); } } else { MessageBox.Show("Please Enter the Address"); } } else { MessageBox.Show("Please Enter the Customer Name"); } }
public string GetCustomer() { CustomerBAL _Cust = new CustomerBAL(); try { var customers = _Cust.Load(); string json = new JavaScriptSerializer().Serialize(customers); return(json); } catch (Exception) { throw; } finally { } }
public void BindGrid() { //List<CustomerBAL> lst = new List<CustomerBAL>(); DataTable dt = new DataTable(); CustomerBAL obj = new CustomerBAL(); dt = obj.GetCustomer(0); obj = null; if (dt.Rows.Count > 0) { divGrid.Visible = true; divNoRecords.Visible = false; grdCustomer.DataSource = dt; grdCustomer.DataBind(); } else { divGrid.Visible = false; divNoRecords.Visible = true; } }
public void ddlProduct_SelectedIndexChanged(object sender, EventArgs e) { CustomerENT entCustomer = new CustomerENT(); CustomerBAL balCustomer = new CustomerBAL(); if (ddlProductID.SelectedIndex > 0) { DataTable dt = balCustomer.SelectProductAmount(Convert.ToInt32(ddlProductID.SelectedValue)); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { if (!dr["BottlePrice"].Equals(DBNull.Value)) { txtAmount.Text = Convert.ToDecimal(dr["BottlePrice"]).ToString(); } } } } }
public HttpResponseMessage GetCustomer([FromBody] CustomerRequestDTO inputParam) { HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, "Not found"); try { ICustomerBAL customerBAL = new CustomerBAL(); switch (customerBAL.ValidateRequest(inputParam)) { case ValidationStatus.Success: var output = customerBAL.GetCustomer(inputParam); if (output != null) { response = Request.CreateResponse(HttpStatusCode.OK, output); } break; case ValidationStatus.BadRequest: response = Request.CreateResponse(HttpStatusCode.BadRequest, ""); break; case ValidationStatus.InvalidCustomerId: response = Request.CreateResponse(HttpStatusCode.BadRequest, "Invalid Customer Id"); break; case ValidationStatus.InvalidEmail: response = Request.CreateResponse(HttpStatusCode.BadRequest, "Invalid Email"); break; case ValidationStatus.NoInquiryCriteria: response = Request.CreateResponse(HttpStatusCode.BadRequest, "No inquiry criteria"); break; } } catch (Exception) { response = Request.CreateResponse(HttpStatusCode.BadRequest, ""); } return(response); }
protected void gvCustomer_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "DeleteRecord" && e.CommandArgument != null) { CustomerBAL balCustomer = new CustomerBAL(); if (balCustomer.Delete(Convert.ToInt32(e.CommandArgument))) { FillCustomerGridView(); } else { lblMessage.Text = balCustomer.Message; } } } catch (Exception ex) { lblMessage.Text = ex.Message.ToString(); } }
public int InsertUpdateCustomer(CustomerBAL obj) { cmd.Parameters.AddWithValue("@CustomerID", obj.CustomerID); cmd.Parameters.AddWithValue("@FirstName", obj.FirstName); cmd.Parameters.AddWithValue("@LastName", obj.LastName); cmd.Parameters.AddWithValue("@BirthDate", obj.BirthDate); cmd.Parameters.AddWithValue("@Email", obj.Email); cmd.Parameters.AddWithValue("@Address", obj.Address); sprm.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(sprm); int i, j = 0; try { cmd.CommandText = "InsertUpdateCustomer"; cmd.CommandType = CommandType.StoredProcedure; con.Open(); i = cmd.ExecuteNonQuery(); if (i > 0) { j = int.Parse(sprm.Value.ToString()); } } catch (Exception ex) { throw ex; } finally { cmd.Parameters.Clear(); con.Close(); con.Dispose(); cmd.Dispose(); } return(j); }
private void Search() { SqlString CustomerName = SqlString.Null; SqlString MobileNumber = SqlString.Null; SqlString EmailAddress = SqlString.Null; if (txtSearchCustomerName.Text.Trim() != "") { CustomerName = Convert.ToString(txtSearchCustomerName.Text.Trim()); } if (txtSerachEmail.Text.Trim() != "") { EmailAddress = Convert.ToString(txtSerachEmail.Text.Trim()); } if (txtSearchMobileNumber.Text.Trim() != "") { MobileNumber = Convert.ToString(txtSearchMobileNumber.Text.Trim()); } CustomerBAL balCustomer = new CustomerBAL(); DataTable dtCustomer = balCustomer.Search(CustomerName, MobileNumber, EmailAddress); if (dtCustomer != null && dtCustomer.Rows.Count > 0) { gvCustomer.DataSource = dtCustomer; gvCustomer.DataBind(); } else { gvCustomer.DataSource = null; gvCustomer.DataBind(); } }
private void LoadControls(SqlInt32 CustomerID) { CustomerENT entCustomer = new CustomerENT(); CustomerBAL balCustomer = new CustomerBAL(); entCustomer = balCustomer.SelectByPK(CustomerID); if (!entCustomer.CustomerName.IsNull) { txtCustomerName.Text = entCustomer.CustomerName.Value.ToString(); } if (!entCustomer.EmailID.IsNull) { txtEmailAddress.Text = entCustomer.EmailID.Value.ToString(); } if (!entCustomer.MobileNo.IsNull) { txtMobileNo.Text = entCustomer.MobileNo.Value.ToString(); } if (!entCustomer.Address.IsNull) { txtAddress.Text = entCustomer.Address.Value.ToString(); } }