public void InsertEnclosure(Vendor.BusinessLayer.EnclosureBL m_oEnclosure)
{
string sSql = "";
SqlCommand cmd;
string argDate = String.Format("{0:dd-MMM-yyyy}", m_oEnclosure.EncDate);
try
{
BsfGlobal.OpenVendorAnalDB();
sSql = "Insert Into Enclosure (VendorId,Location,Date,Name,Type) Values " +
"(" + m_oEnclosure.VendorId + ",'" + m_oEnclosure.Location + "', '" + argDate + "', " +
" '" + m_oEnclosure.Name + "','" + m_oEnclosure.Type + "') ";
cmd = new SqlCommand(sSql, BsfGlobal.g_VendorDB);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
catch (Exception ce)
{
throw ce;
}
finally
{
BsfGlobal.g_VendorDB.Close();
}
}
public void UpdateEnclosure(Vendor.BusinessLayer.EnclosureBL m_oEnclosure)
{
string sSql = "";
SqlCommand cmd;
string argDate = String.Format("{0:dd-MMM-yyyy}", m_oEnclosure.EncDate);
try
{
BsfGlobal.OpenVendorAnalDB();
sSql = "Update Enclosure Set VendorId=" + m_oEnclosure.VendorId + ",Location='" + m_oEnclosure.Location + "', " +
" Date='" + argDate + "',Name='" + m_oEnclosure.Name + "',Type='" + m_oEnclosure.Type + "' Where EnclosureId=" + m_oEnclosure.EnclosureId + " ";
cmd = new SqlCommand(sSql, BsfGlobal.g_VendorDB);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
catch (Exception ce)
{
throw ce;
}
finally
{
BsfGlobal.g_VendorDB.Close();
}
}
public frmEnclosure()
{
InitializeComponent();
m_oEncolosure = new BusinessLayer.EnclosureBL();
}
