public static int Update(mtDestination d) { string SQL_INSERT = @"INSERT INTO dbo.mt_Destination (DestinationDescription) VALUES (@DestinationDescription); SELECT @@IDENTITY;"; string SQL_UPDATE = @"UPDATE dbo.mt_Destination SET DestinationDescription = @DestinationDescription WHERE destinationcode = @destinationcode"; using (SqlConnection cn = new SqlConnection(Config.ConnectionString)) { cn.Open(); SqlCommand cmd; if (d.destinationCode > 0) { cmd = new SqlCommand(SQL_UPDATE, cn); cmd.Parameters.Add("@destinationcode", SqlDbType.Int).Value = d.destinationCode; cmd.Parameters.Add("@destinationdescription", SqlDbType.VarChar, 50).Value = d.destinationDescription; cmd.ExecuteNonQuery(); } else { cmd = new SqlCommand(SQL_INSERT, cn); cmd.Parameters.Add("@destinationdescription", SqlDbType.VarChar, 50).Value = d.destinationDescription; d.destinationCode = Convert.ToInt32(cmd.ExecuteScalar()); } } return(d.destinationCode); }
public static mtDestination GetDestination(int destinationCode) { string sSQL = "SELECT * FROM dbo.mt_Destination WHERE destinationCode=@destinationCode"; using (SqlConnection cn = new SqlConnection(Config.ConnectionString)) { cn.Open(); SqlCommand cmd = new SqlCommand(sSQL, cn); cmd.Parameters.Add("@destinationcode", SqlDbType.Int).Value = destinationCode; SqlDataReader rs = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (!rs.Read()) { return(null); } mtDestination d = new mtDestination(); d.destinationCode = (int)rs["destinationcode"]; d.destinationDescription = rs["destinationdescription"] + ""; return(d); } }