public int CheckCustomer(CheckCustomerRequest ObjCheckCustomerRequest) { CustomerServiceMethods ObjCustomerServiceMethods = new CustomerServiceMethods(); int Count = ObjCustomerServiceMethods.CheckCustomer(ObjCheckCustomerRequest); return(Count); }
public int CheckCustomer(CheckCustomerRequest ObjCheckCustomerRequest) { string connectionstring = "data source=.;" + "database=Binoy;" + "Integrated Security=true"; SqlConnection connection = new SqlConnection(connectionstring); connection.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_checkCustomer_s2por"; cmd.Connection = connection; cmd.Parameters.AddWithValue("@id", ObjCheckCustomerRequest.Id); cmd.Parameters.AddWithValue("@count", 0); cmd.Parameters.AddWithValue("@name", ObjCheckCustomerRequest.Name); cmd.Parameters["@count"].Direction = ParameterDirection.Output; int check = cmd.ExecuteNonQuery(); connection.Close(); CheckCustomerResponse ObjCheckCustomerResponse = new CheckCustomerResponse(); return(ObjCheckCustomerResponse.Count = (Convert.ToInt32(cmd.Parameters["@count"].Value))); }