public void QuickLaunchItemsEdit(QuickLaunchItemsInfo infoQuickLaunchItems)
{
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sqlcmd = new SqlCommand("QuickLaunchItemsEdit", base.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
{
base.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);
}
}
private void SaveorEdit()
{
try
{
QuickLaunchItemsInfo infoQuickLaunchItems = new QuickLaunchItemsInfo();
QuickLaunchItemsSP spQuickLaunchItems = new QuickLaunchItemsSP();
if (dtblSelected.Rows.Count >= 1)
{
foreach (DataRow row in dtblSelected.Rows)
{
infoQuickLaunchItems.ItemsName = row.ItemArray[0].ToString();
infoQuickLaunchItems.QuickLaunchItemsId = Convert.ToDecimal(row.ItemArray[1]);
infoQuickLaunchItems.Status = true;
infoQuickLaunchItems.Extra1 = string.Empty;
infoQuickLaunchItems.Extra2 = string.Empty;
spQuickLaunchItems.QuickLaunchItemsEdit(infoQuickLaunchItems);
}
foreach (DataRow row2 in dtblNonSelected.Rows)
{
infoQuickLaunchItems.ItemsName = row2.ItemArray[0].ToString();
infoQuickLaunchItems.QuickLaunchItemsId = Convert.ToDecimal(row2.ItemArray[1]);
infoQuickLaunchItems.Status = false;
infoQuickLaunchItems.Extra1 = string.Empty;
infoQuickLaunchItems.Extra2 = string.Empty;
spQuickLaunchItems.QuickLaunchItemsEdit(infoQuickLaunchItems);
}
Messages.SavedMessage();
base.Close();
}
else
{
MessageBox.Show("Select atleast one form in quick launch", "Openmiracle", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "MC:3 " + ex.Message;
}
}
/// <summary>
/// Save or edit function, Here checking the items in the list
/// </summary>
private void SaveorEdit()
{
try
{
QuickLaunchItemsInfo infoQuickLaunchItems = new QuickLaunchItemsInfo();
QuickLaunchItemsBll BllQuickLaunchItems=new QuickLaunchItemsBll();
if (listObjSelected[0].Rows.Count >= 1)
{
foreach (DataRow dRoW in listObjSelected[0].Rows)
{
infoQuickLaunchItems.ItemsName = dRoW.ItemArray[0].ToString();
infoQuickLaunchItems.QuickLaunchItemsId = Convert.ToDecimal(dRoW.ItemArray[1]);
infoQuickLaunchItems.Status = true;
infoQuickLaunchItems.Extra1 = string.Empty;
infoQuickLaunchItems.Extra2 = string.Empty;
BllQuickLaunchItems.QuickLaunchItemsEdit(infoQuickLaunchItems);
}
foreach (DataRow dRoW in listObjNonSelected[0].Rows)
{
infoQuickLaunchItems.ItemsName = dRoW.ItemArray[0].ToString();
infoQuickLaunchItems.QuickLaunchItemsId = Convert.ToDecimal(dRoW.ItemArray[1]);
infoQuickLaunchItems.Status = false;
infoQuickLaunchItems.Extra1 = string.Empty;
infoQuickLaunchItems.Extra2 = string.Empty;
BllQuickLaunchItems.QuickLaunchItemsEdit(infoQuickLaunchItems);
}
Messages.SavedMessage();
this.Close();
}
else
{
MessageBox.Show("Select atleast one form in quick launch", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("MC:4 " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
