public int DA_ValidateCustomer(customentity objCustomerDetails)
{
int val = 0;
DataTable dt = new DataTable();
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand(objQuery.ValidateCustomer, con);
cmd.Parameters.AddWithValue("@MobileNo", objCustomerDetails.MobileNo);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
val = 1;
}
else
{
val = 0;
}
}
catch (Exception ex)
{
ex.ToString();
//throw;
}
finally
{
con.Close();
}
return(val);
}
//public static string connectionString = "Data Source=AARTI-PC;Initial Catalog=GSTMasterTable;Integrated Security=True";
public int DAAddcustomerDetails(customentity objcustomerDetails)
{
int ReturnValue = 0;
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand(objQuery.InsertCustomer, con);
//cmd.Parameters.AddWithValue("@CustomerId", objcustomerDetails.CustomerId);
cmd.Parameters.AddWithValue("@CustomerName", objcustomerDetails.CustomerName);
cmd.Parameters.AddWithValue("@MobileNo", objcustomerDetails.MobileNo);
cmd.Parameters.AddWithValue("@Address", objcustomerDetails.Address);
cmd.Parameters.AddWithValue("@EmailId", objcustomerDetails.EmailId);
cmd.Parameters.AddWithValue("@CustomerGSTNo", objcustomerDetails.CustomerGSTNo);
// cmd.Parameters.AddWithValue("@HSN", objcustomerDetails.HSN);
ReturnValue = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
ex.ToString();
//throw;
}
con.Close();
return(ReturnValue);
}
public int BADeleteCustomer(customentity objCustomerdetails)
{
DACustomer objCustomerDA = new DACustomer();
int returnValue = objCustomerDA.DADeleteCustomer(objCustomerdetails);
return(returnValue);
}
public int BAAddCustomerDetails(customentity objcustomerDetails)
{
DACustomer objCustomerDA = new DACustomer();
int returnValue = objCustomerDA.DAAddcustomerDetails(objcustomerDetails);
return(returnValue);
}
protected void Button1_Click(object sender, EventArgs e)
{
int validate = 0;
customentity objcustomerDetails = new customentity();
try
{
objcustomerDetails.CustomerName = CustomerName.Text;
objcustomerDetails.MobileNo = MobileNo.Text;
objcustomerDetails.Address = Address.Text;
objcustomerDetails.EmailId = EmailId.Text;
objcustomerDetails.CustomerGSTNo = Convert.ToInt32(CustomerGSTNo.Text);
// objcustomerDetails.HSN = Convert.ToInt32(HSN.Text);
}
catch (Exception ex)
{
ex.ToString();
}
//BAL
BACustomers objCustomerBA = new BACustomers();
validate = objCustomerBA.BA_ValidateCustomer(objcustomerDetails);
if (validate > 0)
{
Response.Write("<script> alert('Data already exist!')</script>");
}
else
{
int rValue = objCustomerBA.BAAddCustomerDetails(objcustomerDetails);
if (rValue > 0)
{
Response.Write("<script>alert('Success')</script>");
GetTableDetails();
}
else
{
Response.Write("<script>alert('Error')</script>");
}
}
}
protected void gridview2_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int CustomerId = Convert.ToInt16(gridview2.DataKeys[e.RowIndex].Value);
customentity obj_BECustomer = new customentity();
obj_BECustomer.CustomerId = CustomerId;
BACustomers obj_BACustomer = new BACustomers();
int val = obj_BACustomer.BADeleteCustomer(obj_BECustomer);
if (val > 0)
{
Response.Write("<script>alert('Record deleted successfully')</script>");
GetTableDetails();
}
else
{
Response.Write("<script>alert('Error occured')</script>");
}
}
public int DADeleteCustomer(customentity objCustomerdetails)
{
int ReturnValue = 0;
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand(objQuery.DeleteCustomer, con);
cmd.Parameters.AddWithValue("@CustomerId", objCustomerdetails.CustomerId);
ReturnValue = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
ex.ToString();
//throw;
}
con.Close();
return(ReturnValue);
}
public int BA_ValidateCustomer(customentity objCustomerdetails)
{
DACustomer objCustomerDA = new DACustomer();
return(objCustomerDA.DA_ValidateCustomer(objCustomerdetails));
}
