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