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