public static int Delete(SurveyQuestion o)
{
int iReturn = -1; //assume the worst
SqlParameter[] arrParams = new SqlParameter[1];
arrParams[0] = new SqlParameter("@QID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QID, o.QID.GetTypeCode()));
try
{
iReturn = SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_SurveyQuestion_Delete", arrParams);
var s = Survey.FetchObject(o.SID);
if (s.CanBeScored != Survey.IsScorable(s.SID))
{
s.CanBeScored = !s.CanBeScored;
s.Update();
}
}
catch (SqlException exx)
{
System.Diagnostics.Debug.Write(exx.Message);
}
return(iReturn);
}
public static int MaxScore(int SID)
{
var maxScore = 0;
var dsQ = SurveyQuestion.GetAll(SID);
foreach (DataRow qRow in dsQ.Tables[0].Rows)
{
var qType = Convert.ToInt32(qRow["QType"]);
if (qType == 3)
{
return(0); // cannot score a test that has multiple choice
}
var isRequired = Convert.ToBoolean(qRow["IsRequired"]);
if ((qType == 2 && !isRequired) || (qType == 4 && !isRequired))
{
return(0); // cannot score a test that does not have all questions/answers required
}
var isCheckbox = Convert.ToInt32(qRow["DisplayControl"]) == 1;
var QID = Convert.ToInt32(qRow["QID"]);
var qScore = 0;
if (qType == 2 || qType == 4)
{
var dsA = SQChoices.GetAll(QID);
var maxAScore = 0;
foreach (DataRow aRow in dsA.Tables[0].Rows)
{
var score = Convert.ToInt32(aRow["Score"]);
if (isCheckbox)
{
qScore += score;
}
else
{
if (score > maxAScore)
{
maxAScore = score;
}
}
}
if (!isCheckbox)
{
qScore += maxAScore;
}
}
if (qType == 4)
{
//Matrix, how many lines?
var dsML = SQMatrixLines.GetAll(QID);
var numLines = dsML.Tables[0].Rows.Count;
qScore = qScore * numLines;
}
maxScore += qScore;
}
return(maxScore);
}
public static int Update(SurveyQuestion o)
{
int iReturn = -1; //assume the worst
SqlParameter[] arrParams = new SqlParameter[18];
arrParams[0] = new SqlParameter("@QID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QID, o.QID.GetTypeCode()));
arrParams[1] = new SqlParameter("@SID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SID, o.SID.GetTypeCode()));
arrParams[2] = new SqlParameter("@QNumber", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QNumber, o.QNumber.GetTypeCode()));
arrParams[3] = new SqlParameter("@QType", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QType, o.QType.GetTypeCode()));
arrParams[4] = new SqlParameter("@QName", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QName, o.QName.GetTypeCode()));
arrParams[5] = new SqlParameter("@QText", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QText, o.QText.GetTypeCode()));
arrParams[6] = new SqlParameter("@DisplayControl", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DisplayControl, o.DisplayControl.GetTypeCode()));
arrParams[7] = new SqlParameter("@DisplayDirection", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DisplayDirection, o.DisplayDirection.GetTypeCode()));
arrParams[8] = new SqlParameter("@IsRequired", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.IsRequired, o.IsRequired.GetTypeCode()));
arrParams[9] = new SqlParameter("@FldInt1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt1, o.FldInt1.GetTypeCode()));
arrParams[10] = new SqlParameter("@FldInt2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt2, o.FldInt2.GetTypeCode()));
arrParams[11] = new SqlParameter("@FldInt3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt3, o.FldInt3.GetTypeCode()));
arrParams[12] = new SqlParameter("@FldBit1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit1, o.FldBit1.GetTypeCode()));
arrParams[13] = new SqlParameter("@FldBit2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit2, o.FldBit2.GetTypeCode()));
arrParams[14] = new SqlParameter("@FldBit3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit3, o.FldBit3.GetTypeCode()));
arrParams[15] = new SqlParameter("@FldText1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText1, o.FldText1.GetTypeCode()));
arrParams[16] = new SqlParameter("@FldText2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText2, o.FldText2.GetTypeCode()));
arrParams[17] = new SqlParameter("@FldText3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText3, o.FldText3.GetTypeCode()));
try
{
iReturn = SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_SurveyQuestion_Update", arrParams);
var s = Survey.FetchObject(o.SID);
if (s.CanBeScored != Survey.IsScorable(s.SID))
{
s.CanBeScored = !s.CanBeScored;
s.Update();
}
}
catch (SqlException exx)
{
System.Diagnostics.Debug.Write(exx.Message);
}
return(iReturn);
}
public static bool IsScorable(int SID)
{
var dsQ = SurveyQuestion.GetAll(SID);
foreach (DataRow qRow in dsQ.Tables[0].Rows)
{
var qType = Convert.ToInt32(qRow["QType"]);
if (qType == 3)
{
return(false); // cannot score a test that has multiple choice
}
var isRequired = Convert.ToBoolean(qRow["IsRequired"]);
if ((qType == 2 && !isRequired) || (qType == 4 && !isRequired))
{
return(false); // cannot score a test that does not have all questions/answers required
}
}
return(true);
}
public static int Insert(SurveyQuestion o)
{
SqlParameter[] arrParams = new SqlParameter[18];
arrParams[0] = new SqlParameter("@SID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SID, o.SID.GetTypeCode()));
arrParams[1] = new SqlParameter("@QNumber", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QNumber, o.QNumber.GetTypeCode()));
arrParams[2] = new SqlParameter("@QType", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QType, o.QType.GetTypeCode()));
arrParams[3] = new SqlParameter("@QName", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QName, o.QName.GetTypeCode()));
arrParams[4] = new SqlParameter("@QText", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QText, o.QText.GetTypeCode()));
arrParams[5] = new SqlParameter("@DisplayControl", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DisplayControl, o.DisplayControl.GetTypeCode()));
arrParams[6] = new SqlParameter("@DisplayDirection", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DisplayDirection, o.DisplayDirection.GetTypeCode()));
arrParams[7] = new SqlParameter("@IsRequired", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.IsRequired, o.IsRequired.GetTypeCode()));
arrParams[8] = new SqlParameter("@FldInt1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt1, o.FldInt1.GetTypeCode()));
arrParams[9] = new SqlParameter("@FldInt2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt2, o.FldInt2.GetTypeCode()));
arrParams[10] = new SqlParameter("@FldInt3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt3, o.FldInt3.GetTypeCode()));
arrParams[11] = new SqlParameter("@FldBit1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit1, o.FldBit1.GetTypeCode()));
arrParams[12] = new SqlParameter("@FldBit2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit2, o.FldBit2.GetTypeCode()));
arrParams[13] = new SqlParameter("@FldBit3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit3, o.FldBit3.GetTypeCode()));
arrParams[14] = new SqlParameter("@FldText1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText1, o.FldText1.GetTypeCode()));
arrParams[15] = new SqlParameter("@FldText2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText2, o.FldText2.GetTypeCode()));
arrParams[16] = new SqlParameter("@FldText3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText3, o.FldText3.GetTypeCode()));
arrParams[17] = new SqlParameter("@QID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QID, o.QID.GetTypeCode()));
arrParams[17].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_SurveyQuestion_Insert", arrParams);
o.QID = int.Parse(arrParams[17].Value.ToString());
var s = Survey.FetchObject(o.SID);
if (s.CanBeScored != Survey.IsScorable(s.SID))
{
s.CanBeScored = !s.CanBeScored;
s.Update();
}
return(o.QID);
}
public static int Delete(SurveyQuestion o)
{
int iReturn = -1; //assume the worst
SqlParameter[] arrParams = new SqlParameter[1];
arrParams[0] = new SqlParameter("@QID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QID, o.QID.GetTypeCode()));
try
{
iReturn = SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_SurveyQuestion_Delete", arrParams);
var s = Survey.FetchObject(o.SID);
if (s.CanBeScored != Survey.IsScorable(s.SID))
{
s.CanBeScored = !s.CanBeScored;
s.Update();
}
}
catch (SqlException exx)
{
System.Diagnostics.Debug.Write(exx.Message);
}
return iReturn;
}
public static int Update(SurveyQuestion o)
{
int iReturn = -1; //assume the worst
SqlParameter[] arrParams = new SqlParameter[18];
arrParams[0] = new SqlParameter("@QID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QID, o.QID.GetTypeCode()));
arrParams[1] = new SqlParameter("@SID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SID, o.SID.GetTypeCode()));
arrParams[2] = new SqlParameter("@QNumber", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QNumber, o.QNumber.GetTypeCode()));
arrParams[3] = new SqlParameter("@QType", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QType, o.QType.GetTypeCode()));
arrParams[4] = new SqlParameter("@QName", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QName, o.QName.GetTypeCode()));
arrParams[5] = new SqlParameter("@QText", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QText, o.QText.GetTypeCode()));
arrParams[6] = new SqlParameter("@DisplayControl", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DisplayControl, o.DisplayControl.GetTypeCode()));
arrParams[7] = new SqlParameter("@DisplayDirection", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DisplayDirection, o.DisplayDirection.GetTypeCode()));
arrParams[8] = new SqlParameter("@IsRequired", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.IsRequired, o.IsRequired.GetTypeCode()));
arrParams[9] = new SqlParameter("@FldInt1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt1, o.FldInt1.GetTypeCode()));
arrParams[10] = new SqlParameter("@FldInt2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt2, o.FldInt2.GetTypeCode()));
arrParams[11] = new SqlParameter("@FldInt3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt3, o.FldInt3.GetTypeCode()));
arrParams[12] = new SqlParameter("@FldBit1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit1, o.FldBit1.GetTypeCode()));
arrParams[13] = new SqlParameter("@FldBit2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit2, o.FldBit2.GetTypeCode()));
arrParams[14] = new SqlParameter("@FldBit3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit3, o.FldBit3.GetTypeCode()));
arrParams[15] = new SqlParameter("@FldText1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText1, o.FldText1.GetTypeCode()));
arrParams[16] = new SqlParameter("@FldText2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText2, o.FldText2.GetTypeCode()));
arrParams[17] = new SqlParameter("@FldText3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText3, o.FldText3.GetTypeCode()));
try
{
iReturn = SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_SurveyQuestion_Update", arrParams);
var s = Survey.FetchObject(o.SID);
if (s.CanBeScored != Survey.IsScorable(s.SID))
{
s.CanBeScored = !s.CanBeScored;
s.Update();
}
}
catch (SqlException exx)
{
System.Diagnostics.Debug.Write(exx.Message);
}
return iReturn;
}
public static int Insert(SurveyQuestion o)
{
SqlParameter[] arrParams = new SqlParameter[18];
arrParams[0] = new SqlParameter("@SID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SID, o.SID.GetTypeCode()));
arrParams[1] = new SqlParameter("@QNumber", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QNumber, o.QNumber.GetTypeCode()));
arrParams[2] = new SqlParameter("@QType", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QType, o.QType.GetTypeCode()));
arrParams[3] = new SqlParameter("@QName", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QName, o.QName.GetTypeCode()));
arrParams[4] = new SqlParameter("@QText", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QText, o.QText.GetTypeCode()));
arrParams[5] = new SqlParameter("@DisplayControl", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DisplayControl, o.DisplayControl.GetTypeCode()));
arrParams[6] = new SqlParameter("@DisplayDirection", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DisplayDirection, o.DisplayDirection.GetTypeCode()));
arrParams[7] = new SqlParameter("@IsRequired", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.IsRequired, o.IsRequired.GetTypeCode()));
arrParams[8] = new SqlParameter("@FldInt1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt1, o.FldInt1.GetTypeCode()));
arrParams[9] = new SqlParameter("@FldInt2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt2, o.FldInt2.GetTypeCode()));
arrParams[10] = new SqlParameter("@FldInt3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt3, o.FldInt3.GetTypeCode()));
arrParams[11] = new SqlParameter("@FldBit1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit1, o.FldBit1.GetTypeCode()));
arrParams[12] = new SqlParameter("@FldBit2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit2, o.FldBit2.GetTypeCode()));
arrParams[13] = new SqlParameter("@FldBit3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit3, o.FldBit3.GetTypeCode()));
arrParams[14] = new SqlParameter("@FldText1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText1, o.FldText1.GetTypeCode()));
arrParams[15] = new SqlParameter("@FldText2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText2, o.FldText2.GetTypeCode()));
arrParams[16] = new SqlParameter("@FldText3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText3, o.FldText3.GetTypeCode()));
arrParams[17] = new SqlParameter("@QID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.QID, o.QID.GetTypeCode()));
arrParams[17].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_SurveyQuestion_Insert", arrParams);
o.QID = int.Parse(arrParams[17].Value.ToString());
var s = Survey.FetchObject(o.SID);
if (s.CanBeScored != Survey.IsScorable(s.SID))
{
s.CanBeScored = !s.CanBeScored;
s.Update();
}
return o.QID;
}
public bool Fetch(int QID)
{
// declare reader
SqlDataReader dr;
SqlParameter[] arrParams = new SqlParameter[1];
arrParams[0] = new SqlParameter("@QID", QID);
dr = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, "app_SurveyQuestion_GetByID", arrParams);
if (dr.Read())
{
// declare return value
var result = new SurveyQuestion();
int _int;
if (int.TryParse(dr["QID"].ToString(), out _int)) this.QID = _int;
if (int.TryParse(dr["SID"].ToString(), out _int)) this.SID = _int;
if (int.TryParse(dr["QNumber"].ToString(), out _int)) this.QNumber = _int;
if (int.TryParse(dr["QType"].ToString(), out _int)) this.QType = _int;
this.QName = dr["QName"].ToString();
this.QText = dr["QText"].ToString();
if (int.TryParse(dr["DisplayControl"].ToString(), out _int)) this.DisplayControl = _int;
if (int.TryParse(dr["DisplayDirection"].ToString(), out _int)) this.DisplayDirection = _int;
this.IsRequired = bool.Parse(dr["IsRequired"].ToString());
if (int.TryParse(dr["FldInt1"].ToString(), out _int)) this.FldInt1 = _int;
if (int.TryParse(dr["FldInt2"].ToString(), out _int)) this.FldInt2 = _int;
if (int.TryParse(dr["FldInt3"].ToString(), out _int)) this.FldInt3 = _int;
this.FldBit1 = bool.Parse(dr["FldBit1"].ToString());
this.FldBit2 = bool.Parse(dr["FldBit2"].ToString());
this.FldBit3 = bool.Parse(dr["FldBit3"].ToString());
this.FldText1 = dr["FldText1"].ToString();
this.FldText2 = dr["FldText2"].ToString();
this.FldText3 = dr["FldText3"].ToString();
dr.Close();
return true;
}
dr.Close();
return false;
}
protected bool Save()
{
try
{
var obj = new SurveyQuestion();
obj.QType = QType.SelectedValue.SafeToInt();
obj.QNumber = -1;
obj.SID = SID.Text.SafeToInt();
switch (obj.QType)
{
case 1:
obj.QText = QText.InnerHtml;
obj.QName = "Instructions/Text/Description";
break;
case 5:
case 6:
obj.QText= string.Empty;
obj.QName= string.Empty;
break;
case 3:
obj.QText = QText3.InnerHtml;
obj.QName = QName3.Text;
obj.IsRequired = IsRequired3.Checked;
break;
case 2:
obj.QText = QText2.InnerHtml;
obj.QName = QName2.Text;
obj.IsRequired = IsRequired2.Checked;
obj.DisplayControl = DisplayControl2.SelectedValue.SafeToInt();
obj.DisplayDirection = DisplayDirection2.SelectedValue.SafeToInt();
break;
case 4:
obj.QText = QText4.InnerHtml;
obj.QName = QName4.Text;
obj.IsRequired = IsRequired4.Checked;
obj.DisplayControl = DisplayControl4.SelectedValue.SafeToInt();
break;
}
if (obj.IsValid(BusinessRulesValidationMode.INSERT))
{
obj.Insert();
switch (obj.QType)
{
case 2:
SaveType2Answers(obj.QID);
break;
case 4:
SaveType4Answers(obj.QID);
SaveType4Lines(obj.QID);
break;
}
Session["QID"] = obj.QID;
return true;
}
else
{
var masterPage = (IControlRoomMaster)Master;
string message = String.Format(SRPResources.ApplicationError1, "<ul>");
foreach (BusinessRulesValidationMessage m in obj.ErrorCodes)
{
message = string.Format(String.Format("{0}<li>{{0}}</li>", message), m.ErrorMessage);
}
message = string.Format("{0}</ul>", message);
if (masterPage != null) masterPage.PageError = message;
return false;
}
}
catch (Exception ex)
{
var masterPage = (IControlRoomMaster)Master;
if (masterPage != null)
masterPage.PageError = String.Format(SRPResources.ApplicationError1, ex.Message);
return false;
}
}
public bool Fetch(int QID)
{
// declare reader
SqlDataReader dr;
SqlParameter[] arrParams = new SqlParameter[1];
arrParams[0] = new SqlParameter("@QID", QID);
dr = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, "app_SurveyQuestion_GetByID", arrParams);
if (dr.Read())
{
// declare return value
var result = new SurveyQuestion();
int _int;
if (int.TryParse(dr["QID"].ToString(), out _int))
{
this.QID = _int;
}
if (int.TryParse(dr["SID"].ToString(), out _int))
{
this.SID = _int;
}
if (int.TryParse(dr["QNumber"].ToString(), out _int))
{
this.QNumber = _int;
}
if (int.TryParse(dr["QType"].ToString(), out _int))
{
this.QType = _int;
}
this.QName = dr["QName"].ToString();
this.QText = dr["QText"].ToString();
if (int.TryParse(dr["DisplayControl"].ToString(), out _int))
{
this.DisplayControl = _int;
}
if (int.TryParse(dr["DisplayDirection"].ToString(), out _int))
{
this.DisplayDirection = _int;
}
this.IsRequired = bool.Parse(dr["IsRequired"].ToString());
if (int.TryParse(dr["FldInt1"].ToString(), out _int))
{
this.FldInt1 = _int;
}
if (int.TryParse(dr["FldInt2"].ToString(), out _int))
{
this.FldInt2 = _int;
}
if (int.TryParse(dr["FldInt3"].ToString(), out _int))
{
this.FldInt3 = _int;
}
this.FldBit1 = bool.Parse(dr["FldBit1"].ToString());
this.FldBit2 = bool.Parse(dr["FldBit2"].ToString());
this.FldBit3 = bool.Parse(dr["FldBit3"].ToString());
this.FldText1 = dr["FldText1"].ToString();
this.FldText2 = dr["FldText2"].ToString();
this.FldText3 = dr["FldText3"].ToString();
dr.Close();
return(true);
}
dr.Close();
return(false);
}
