public static void Update(mtVendorGroup c)
{
string sSQL = @"IF NOT EXISTS(SELECT * FROM dbo.mt_vendorgroupcode WHERE vendorGroupCode=@vendorGroupCode)
INSERT INTO dbo.mt_vendorgroupcode (vendorGroupCode) VALUES (@vendorGroupCode) ";
using (SqlConnection cn = new SqlConnection(Config.ConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand(sSQL, cn);
cmd.Parameters.Add("@vendorGroupCode", SqlDbType.VarChar, 25).Value = c.vendorGroupCode;
cmd.ExecuteNonQuery();
}
}
public static mtVendorGroup GetVendorGroup(string vendorGroupCode)
{
string sSQL = "SELECT * FROM dbo.mt_vendorgroupcode WHERE vendorGroupCode=@vendorGroupCode";
using (SqlConnection cn = new SqlConnection(Config.ConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand(sSQL, cn);
cmd.Parameters.Add("@vendorGroupCode", SqlDbType.VarChar).Value = vendorGroupCode;
SqlDataReader rs = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (!rs.Read())
{
return(null);
}
mtVendorGroup c = new mtVendorGroup();
c.vendorGroupCode = rs["vendorGroupCode"].ToString();
return(c);
}
}
