public void UpdateRegFormLogoOrder(int webinarID, ArrayList arrLogos)
{
try
{
string sql1 = DBQuery.sqlWebinarResourceLogoOrderUpdate;
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
MySqlCommand sqlCmd = new MySqlCommand(sql1, sqlCon);
sqlCon.Open();
sqlCmd.CommandType = CommandType.Text;
EBirdUtility objUtil = new EBirdUtility();
for (int idx = 0; idx < arrLogos.Count; idx++)
{
if (objUtil.IsNumeric(arrLogos[idx]))
{
sqlCmd.Parameters.Clear();
sqlCmd.Parameters.Add(new MySqlParameter("@resourceOrder", idx + 1));
sqlCmd.Parameters.Add(new MySqlParameter("@webinarID", webinarID));
sqlCmd.Parameters.Add(new MySqlParameter("@docID", arrLogos[idx].ToString()));
sqlCmd.ExecuteNonQuery();
}
}
sqlCon.Close();
}
}
catch (Exception ex)
{
throw;
}
}
