public void UpdateExperience(Vendor.BusinessLayer.ExperienceBL argExp)
{
SqlConnection conn;
conn = new SqlConnection();
conn = BsfGlobal.OpenVendorAnalDB();
SqlTransaction tran = conn.BeginTransaction();
try
{
SqlCommand Command = new SqlCommand("Update_Experience", conn, tran);
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.Clear();
Command.Parameters.AddWithValue("@ExperienceId", argExp.ExperienceId);
Command.Parameters.AddWithValue("@VendorId", argExp.VendorId);
Command.Parameters.AddWithValue("@WorkDescription", argExp.WorkDescription);
Command.Parameters.AddWithValue("@ClientName", argExp.ClientName);
Command.Parameters.AddWithValue("@Value", argExp.Value);
Command.Parameters.AddWithValue("@Period", argExp.Period);
Command.Parameters.AddWithValue("@Type", argExp.Type);
Command.ExecuteNonQuery();
tran.Commit();
}
catch
{
tran.Rollback();
}
finally
{
conn.Close();
}
}
public void UpdateExperience(Vendor.BusinessLayer.ExperienceBL argExp)
{
m_oExperience.UpdateExperience(argExp);
}
public frmExperience()
{
InitializeComponent();
m_oExp = new Vendor.BusinessLayer.ExperienceBL();
}
public void InsertExperience(Vendor.BusinessLayer.ExperienceBL argExp)
{
m_oExperience.InsertExperience(argExp);
}
