public DataTable returndatatable(ClsBllCustomerMaster objbll, int flag) { if (con.State == ConnectionState.Open) { con.Close(); } else { con.Open(); } cmd = new SqlCommand("SP_CustomerMaster"); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.Parameters.Clear(); cmd.Parameters.Add("@Flag", SqlDbType.BigInt).Value = flag; if (flag == 3) { cmd.Parameters.Add("@CountryId", SqlDbType.BigInt).Value = objbll.CountryId; } SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); return(dt); }
public void save(ClsBllCustomerMaster objbll, int flag) { if (con.State == ConnectionState.Closed) { con.Open(); } cmd = new SqlCommand("SP_CustomerMaster"); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.Parameters.Add("@Flag", SqlDbType.BigInt).Value = flag; if (flag == 6) { cmd.Parameters.Add("@CustomerId", SqlDbType.BigInt).Value = objbll.CustomerId; } cmd.Parameters.Add("CustomerName", SqlDbType.VarChar).Value = objbll.Name; cmd.Parameters.Add("@Address", SqlDbType.VarChar).Value = objbll.Address; cmd.Parameters.Add("@NationalityId", SqlDbType.BigInt).Value = objbll.Nationality; cmd.Parameters.Add("@StateId", SqlDbType.BigInt).Value = objbll.State; cmd.Parameters.Add("@Locality", SqlDbType.VarChar).Value = objbll.Locality; cmd.Parameters.Add("@TinNo", SqlDbType.VarChar).Value = objbll.TinNo; cmd.Parameters.Add("@Phone1", SqlDbType.VarChar).Value = objbll.PhoneNo1; cmd.Parameters.Add("@Phone2", SqlDbType.VarChar).Value = objbll.PhoneNo2; cmd.Parameters.Add("@EmailId", SqlDbType.VarChar).Value = objbll.EmailID; cmd.Parameters.Add("@Fax", SqlDbType.VarChar).Value = objbll.Fax; cmd.Parameters.Add("@Photo", SqlDbType.Image).Value = objbll.Photo; cmd.ExecuteNonQuery(); con.Close(); }
public void delete(ClsBllCustomerMaster objbll) { if (con.State == ConnectionState.Closed) { con.Open(); } cmd = new SqlCommand("SP_CustomerMaster"); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.Parameters.Add("@Flag", SqlDbType.BigInt).Value = 5; cmd.Parameters.Add("@CustomerId", SqlDbType.BigInt).Value = objbll.CustomerId; cmd.ExecuteNonQuery(); con.Close(); }