/// <summary> /// Function to Update values in tbl_QuickLaunchItems Table /// </summary> /// <param name="infoQuickLaunchItems"></param> public void QuickLaunchItemsEdit(QuickLaunchItemsInfo infoQuickLaunchItems) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sqlcmd = new SqlCommand("QuickLaunchItemsEdit", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@quickLaunchItemsId", SqlDbType.Decimal).Value = infoQuickLaunchItems.QuickLaunchItemsId; sqlcmd.Parameters.Add("@itemsName", SqlDbType.VarChar).Value = infoQuickLaunchItems.ItemsName; sqlcmd.Parameters.Add("@status", SqlDbType.Bit).Value = infoQuickLaunchItems.Status; sqlcmd.Parameters.Add("@extra1", SqlDbType.VarChar).Value = infoQuickLaunchItems.Extra1; sqlcmd.Parameters.Add("@extra2", SqlDbType.VarChar).Value = infoQuickLaunchItems.Extra2; sqlcmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { sqlcon.Close(); } }
/// <summary> /// Function to Update values in tbl_QuickLaunchItems Table /// </summary> /// <param name="infoQuickLaunchItems"></param> public void QuickLaunchItemsEdit(QuickLaunchItemsInfo infoQuickLaunchItems) { QuickLaunchItemsSP SPQuickLaunchItems = new QuickLaunchItemsSP(); try { SPQuickLaunchItems.QuickLaunchItemsEdit(infoQuickLaunchItems); } catch (Exception ex) { MessageBox.Show("QLIBll 2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }