public bool SaveCarrierDetails(ShippingCarrierModel carrier) { using (var connection = new SqlConnection(Constants.ConnectorDatabase)) { const string commandText = @"IF @CarrierId<=0 Insert into [ShippingCarrier] (CarrierName,CarrierDescription) values (@CarrierName,@CarrierDescription); ELSE update ShippingCarrier set CarrierName=@CarrierName,CarrierDescription=@CarrierDescription where CarrierId=@CarrierId"; var cmd = new SqlCommand(commandText, connection); cmd.Parameters.AddWithValue("@CarrierId", carrier.CarrierId); cmd.Parameters.AddWithValue("@CarrierName", carrier.CarrierCode); cmd.Parameters.AddWithValue("@CarrierDescription", carrier.CarrierDescription); connection.Open(); int i = cmd.ExecuteNonQuery(); return(i > 0); } }
public bool IsCarrierExists(ShippingCarrierModel carrier) { using (var connection = new SqlConnection(Constants.ConnectorDatabase)) { const string commandText = @"Select CarrierId from ShippingCarrier where CarrierName=@CarrierName and CarrierId<>@CarrierId"; using (var command = new SqlCommand(commandText, connection)) { connection.Open(); command.Parameters.AddWithValue("@CarrierName", carrier.CarrierCode); command.Parameters.AddWithValue("@CarrierId", carrier.CarrierId); using (SqlDataReader dataReader = command.ExecuteReader()) { return(dataReader.Read()); } } } }
private void ClearValues() { Carrier = new ShippingCarrierModel(); ValidationMessage = ""; }