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();
}
}
