public int Customer_Save_Insert_Update_Delete(BAL_Customer bc)
{
try
{
con.Open();
cmd = new SqlCommand("SP_Customer", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Flag", 1);
// cmd.Parameters.AddWithValue("@EmployeeID", bc.Employee_ID);
cmd.Parameters.AddWithValue("@Cust_ID", bc.Cust_ID);
cmd.Parameters.AddWithValue("@Name", bc.Name);
cmd.Parameters.AddWithValue("@Mobile_No", bc.Mobile_No);
cmd.Parameters.AddWithValue("@Date_Of_Birth", bc.Date_Of_Birth);
cmd.Parameters.AddWithValue("@Email_ID", bc.Email_ID);
cmd.Parameters.AddWithValue("@Address", bc.Address);
cmd.Parameters.AddWithValue("@Occupation", bc.Occupation);
cmd.Parameters.AddWithValue("@SourceOfEnquiry", bc.Source_OF_Enquiry);
cmd.Parameters.AddWithValue("@SourceEnqID", bc.SourceEnqID);
cmd.Parameters.AddWithValue("@S_Status", bc.S_Status);
cmd.Parameters.AddWithValue("@C_Date", bc.C_Date);
int i = cmd.ExecuteNonQuery();
return i;
}
catch (Exception)
{
throw;
}
finally { con.Close(); }
}
public int Customer_Update(BAL_Customer bc)
{
try
{
con.Open();
cmd = new SqlCommand("SP_Customer_Followup_Update", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Flag", 1);
cmd.Parameters.AddWithValue("@F_ID", bc.F_ID);
cmd.Parameters.AddWithValue("@S_Status", bc.S_Status);
cmd.Parameters.AddWithValue("@C_Date", bc.C_Date);
int i = cmd.ExecuteNonQuery();
return i;
}
catch (Exception)
{
throw;
}
finally { con.Close(); }
}