private void lbDrag_Drop(object sender, DragEventArgs e)
{
try
{
BOQAnswer droppedData = e.Data.GetData(typeof(BOQAnswer)) as BOQAnswer;
var obj = _list.QuestionList.Where(q => q.QAId.Equals(droppedData.QuestionId)).FirstOrDefault().AnswerList.Where(f => f.Answer.Equals(droppedData.Answer)).FirstOrDefault();
obj.UserAnswer = false; obj.OrderingList = OrderingListNo;
OrderingListNo--;
foreach (var item in listQuestion.Items)
{
var _Container = listQuestion.ItemContainerGenerator
.ContainerFromItem(item);
var _Children = AllChildren(_Container);
if (_Children.Count > 0)
{
var _control = _Children.OfType <ListBox>().First(x => x.Name.Equals("lbDrag")); _control.Items.Refresh();
_control = _Children.OfType <ListBox>().First(x => x.Name.Equals("lbDrop"));
_control.Items.SortDescriptions.Add(new System.ComponentModel.SortDescription("OrderingList", System.ComponentModel.ListSortDirection.Ascending));
_control.Items.Refresh();
}
}
}
catch
{
}
}
internal int IUDAnswer(BOQAnswer _boqans)
{
int returnvalue = default(int);
using (SqlConnection _sqlconnection = ConnectionInfo.GetConnection())
{
_sqlcommand = new SqlCommand();
_sqlcommand.Connection = _sqlconnection;
_sqlcommand.CommandText = "SP_IUDAnswer";
_sqlcommand.CommandType = CommandType.StoredProcedure;
_sqlconnection.Open();
_sqlcommand.Parameters.AddWithValue("@AnswerId", _boqans.AnswerId);
_sqlcommand.Parameters.AddWithValue("@Answer", _boqans.Answer);
_sqlcommand.Parameters.AddWithValue("@QuestionId", _boqans.QuestionId);
_sqlcommand.Parameters.AddWithValue("@RightAnswer", _boqans.RightAnswer);
_sqlcommand.Parameters.AddWithValue("@IsActive", _boqans.IsActive);
_sqlcommand.Parameters.AddWithValue("@IsDelete", _boqans.IsDelete);
_sqlcommand.Parameters.AddWithValue("@CreatedBy", _boqans.CreatedBy);
_sqlcommand.Parameters.AddWithValue("@CreatedDate", _boqans.CreatedDate);
_sqlcommand.Parameters.AddWithValue("@UpdatedBy", _boqans.UpdatedBy);
_sqlcommand.Parameters.AddWithValue("@UpdatedDate", _boqans.UpdatedDate);
_sqlcommand.Parameters.AddWithValue("@Event", _boqans.Event);
_sqlcommand.Parameters.AddWithValue("@returnValue", 0).Direction = System.Data.ParameterDirection.InputOutput;
try
{
_sqlcommand.ExecuteNonQuery();
returnvalue = Convert.ToInt32(_sqlcommand.Parameters["@returnValue"].Value);
}
catch (SqlException sqlex)
{ Common.LogError(sqlex); }
catch (StackOverflowException stackex)
{ Common.LogError(stackex); }
catch (Exception ex)
{
Common.LogError(ex);
}
finally
{
_sqlconnection.Close();
_sqlcommand.Dispose();
}
}
return(returnvalue);
}
internal int Update(BOQAnswer _boqans)
{
return(_daqand.IUDAnswer(_boqans));
}
internal int Insert(BOQAnswer _boqans)
{
return(_daqand.IUDAnswer(_boqans));
}
