private List <ExamFormProperty> BindExamFormListObject(DataTable dataTable)
{
var examFormPropertyList = new List <ExamFormProperty>();
try
{
if (dataTable.Rows.Count > 0)
{
for (var j = 0; j < dataTable.Rows.Count; j++)
{
var objExamFormProperty = new ExamFormProperty {
CourseId = Convert.ToInt32(dataTable.Rows[j]["AjCourseId"]),
CourseName = Convert.ToString(dataTable.Rows[j]["AjCourseName"]),
ExamFormCenter = Convert.ToString(dataTable.Rows[j]["AjExamFormCenter"]),
ExamFormDd = Convert.ToString(dataTable.Rows[j]["AjExamFormDD"]),
ExamFormId = Convert.ToInt32(dataTable.Rows[j]["AjExamFormId"]),
ExamFormKeywords = Convert.ToString(dataTable.Rows[j]["AjExamFormMetaTag"]),
ExamFormMetaDesc = Convert.ToString(dataTable.Rows[j]["AjExamFormMetaDesc"]),
ExamFormPrice = Convert.ToString(dataTable.Rows[j]["AjExamFormPrice"]),
ExamFormResultDate = Convert.ToString(dataTable.Rows[j]["AjExamFormResultDate"]),
ExamFormResultDateReamrk = Convert.ToString(dataTable.Rows[j]["AjExamFormResultDateRemark"]),
ExamFormResultWebsite = Convert.ToString(dataTable.Rows[j]["AjExamFormResultWebsite"]),
ExamFormSaleEndDate = Convert.ToString(dataTable.Rows[j]["AjExamFormSaleEndDate"]),
ExamFormSaleEndDateRemark = Convert.ToString(dataTable.Rows[j]["AjExamFormSaleEndDateRemark"]),
ExamFormSaleStartDate = Convert.ToString(dataTable.Rows[j]["AjExamFormSaleStartDate"]),
ExamFormStatus = Convert.ToBoolean(dataTable.Rows[j]["AjExamFormStatus"]),
ExamFormStore = Convert.ToString(dataTable.Rows[j]["AjExamFormStore"]),
ExamFormSubject = Convert.ToString(dataTable.Rows[j]["AjExamFormSubject"]),
ExamFormSubmitDate = Convert.ToString(dataTable.Rows[j]["AjExamFormSubmitDate"]),
ExamFormSubmitDateRemark = Convert.ToString(dataTable.Rows[j]["AjExamFormSubmitDateRemark"]),
ExamFormSyllabus = Convert.ToString(dataTable.Rows[j]["AjExamFormSyllabus"]),
ExamFormTitle = Convert.ToString(dataTable.Rows[j]["AjExamFormTitle"]),
ExamFormUrl = Convert.ToString(dataTable.Rows[j]["AjExamFormUrl"]),
ExamFormWebsite = Convert.ToString(dataTable.Rows[j]["AjExamFormWebsite"]),
ExamFormYear = Convert.ToString(dataTable.Rows[j]["AjExamFormYear"]),
ExamFromSaleStartDateRemark = Convert.ToString(dataTable.Rows[j]["AjExamFormSaleStartDateRemark"]),
ExamId = Convert.ToInt32(dataTable.Rows[j]["AjExamId"]),
ExamName = Convert.ToString(dataTable.Rows[j]["AjExamName"])
};
examFormPropertyList.Add(objExamFormProperty);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindExamFormListObject in Exam.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(examFormPropertyList);
}
public override int UpdateExamFormDetails(ExamFormProperty objExamFormProperty, int modifiedBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = string.Empty;
try
{
_objDataWrapper.AddParameter("@EaxmFormId", objExamFormProperty.ExamFormId);
_objDataWrapper.AddParameter("@ExamId", objExamFormProperty.ExamId);
_objDataWrapper.AddParameter("@ExamFormUrl", objExamFormProperty.ExamFormUrl);
_objDataWrapper.AddParameter("@ExamFormTitle", objExamFormProperty.ExamFormTitle);
_objDataWrapper.AddParameter("@ExamFormMetaDesc", objExamFormProperty.ExamFormMetaDesc);
_objDataWrapper.AddParameter("@ExamFormMetaTag", objExamFormProperty.ExamFormKeywords);
_objDataWrapper.AddParameter("@ExamFormSubject", objExamFormProperty.ExamFormSubject);
_objDataWrapper.AddParameter("@ExamFormYear", objExamFormProperty.ExamFormYear);
_objDataWrapper.AddParameter("@ExamFormWebsite", objExamFormProperty.ExamFormWebsite);
_objDataWrapper.AddParameter("@ExamFormSalesStartDate", objExamFormProperty.ExamFormSaleStartDate);
_objDataWrapper.AddParameter("@ExamFormSalesStartDateReamrk", objExamFormProperty.ExamFromSaleStartDateRemark);
_objDataWrapper.AddParameter("@ExamFormSalesEndDate", objExamFormProperty.ExamFormSaleEndDate);
_objDataWrapper.AddParameter("@ExamFormSalesEndDateReamrk", objExamFormProperty.ExamFormSaleEndDateRemark);
_objDataWrapper.AddParameter("@ExamFormSubmitDate", objExamFormProperty.ExamFormSubmitDate);
_objDataWrapper.AddParameter("@ExamFormSubmitDateReamrk", objExamFormProperty.ExamFormSubmitDateRemark);
_objDataWrapper.AddParameter("@ExamFormResultDate", objExamFormProperty.ExamFormResultDate);
_objDataWrapper.AddParameter("@ExamFormResultDateRemark", objExamFormProperty.ExamFormResultDateReamrk);
_objDataWrapper.AddParameter("@ExamFormResultWebsite", objExamFormProperty.ExamFormResultWebsite);
_objDataWrapper.AddParameter("@ExamFormPrice", objExamFormProperty.ExamFormPrice);
_objDataWrapper.AddParameter("@ExamFormStore", objExamFormProperty.ExamFormStore);
_objDataWrapper.AddParameter("@ExamFromCenter", objExamFormProperty.ExamFormCenter);
_objDataWrapper.AddParameter("@ExamFromDD", objExamFormProperty.ExamFormDd);
_objDataWrapper.AddParameter("@ExamFromSyllabus", objExamFormProperty.ExamFormSyllabus);
_objDataWrapper.AddParameter("@CreatedBy", modifiedBy);
_objDataWrapper.AddParameter("@AjExamFormStatus", objExamFormProperty.ExamFormStatus);
var objErrmsg =
(SqlParameter)
(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateExamFormDetails");
if (objErrmsg != null && objErrmsg.Value != null)
{
errmsg = Convert.ToString(objErrmsg.Value);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing UpdateExamFormDetails in Exam.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
protected void btnUpload_Click(object sender, EventArgs e)
{
_objCommon = new Common();
try
{
var objExamFormProperty = new ExamFormProperty();
_objClsOledbdatalayer = new ClsOleDBDataWrapper();
string path = MapPath(fileUploadExcel.FileName);
string[] excelSheets = _objClsOledbdatalayer.CountTotalSheets(path);
if (excelSheets.Length > 0)
{
foreach (var ds in excelSheets.Select(t => _objClsOledbdatalayer.getdata(path, t)).Where(_ds => _ds.Tables[0].Rows.Count > 0))
{
for (int j = 0; j < ds.Tables[0].Rows.Count - 1; j++)
{
objExamFormProperty.ExamId = Convert.ToInt32(ds.Tables[0].Rows[j]["ExamId"]);
objExamFormProperty.ExamFormUrl = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormUrl"]);
objExamFormProperty.ExamFormTitle = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormTitle"]);
objExamFormProperty.ExamFormMetaDesc = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormMetaDesc"]);
objExamFormProperty.ExamFormKeywords = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormMetaTag"]);
objExamFormProperty.ExamFormSubject = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormSubject"]);
objExamFormProperty.ExamFormYear = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormYear"]);
objExamFormProperty.ExamFormWebsite = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormWebsite"]);
objExamFormProperty.ExamFormSaleStartDate = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormSaleStartDate"]);
objExamFormProperty.ExamFromSaleStartDateRemark = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormSaleStartDateRemark"]);
objExamFormProperty.ExamFormSaleEndDate = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormSaleEndDate"]);
objExamFormProperty.ExamFormSaleEndDateRemark = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormSaleEndDateRemark"]);
objExamFormProperty.ExamFormSubmitDate = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormSubmitDate"]);
objExamFormProperty.ExamFormSubmitDateRemark = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormSubmitDateRemark"]);
objExamFormProperty.ExamFormResultDate = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormResultDate"]);
objExamFormProperty.ExamFormResultDateReamrk = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormResultDateRemark"]);
objExamFormProperty.ExamFormResultWebsite = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormResultWebsite"]);
objExamFormProperty.ExamFormPrice = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormPrice"]);
objExamFormProperty.ExamFormStore = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormStore"]);
objExamFormProperty.ExamFormCenter = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormCenter"]);
objExamFormProperty.ExamFormDd = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormDD"]);
objExamFormProperty.ExamFormSyllabus = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormSyllabus"]);
objExamFormProperty.ExamFormStatus = Convert.ToBoolean(ds.Tables[0].Rows[j]["ExamFormStatus"]);
var errMsg = "";
var _insert = ExamProvider.Instance.InsertExamFormDetails(objExamFormProperty, LoggedInUserId, out errMsg);
}
lblSeccessMsg.Text = _objCommon.GetErrorMessage("lblSucessMsg");
lblSeccessMsg.Visible = true;
Response.Redirect("ManageExamFormMaster.aspx", true);
}
}
else
{
lblErorrMsg.Visible = true;
lblErorrMsg.Text = _objCommon.GetErrorMessage("lblErrMsg");
}
}
catch (Exception ex)
{
string err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.InnerException.Message;
}
string addInfo = "Error :: -> ";
ClsExceptionPublisher objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
protected void btnExamForm_Click(object sender, EventArgs e)
{
string ErrorMsg = "";
try
{
var objExamFormProperty = new ExamFormProperty();
objExamFormProperty.ExamId = Convert.ToInt32(ddlExamName.SelectedValue.ToString());
objExamFormProperty.ExamFormUrl = Convert.ToString(txtExamFormUrl.Text.Trim());
objExamFormProperty.ExamFormTitle = Convert.ToString(txtFormtitle.Text.Trim());
objExamFormProperty.ExamFormMetaDesc = Convert.ToString(txtFormMetaDesc.Text.Trim());
objExamFormProperty.ExamFormKeywords = Convert.ToString(txtFormMataTag.Text.Trim());
objExamFormProperty.ExamFormSubject = Convert.ToString(txtFormSubject.Text.Trim());
objExamFormProperty.ExamFormYear = Convert.ToString(txtFormYear.Text.Trim());
objExamFormProperty.ExamFormWebsite = Convert.ToString(txtFormWebsite.Text.Trim());
if (rbtFormSaleDate.SelectedValue == "1")
{
objExamFormProperty.ExamFormSaleStartDate = Convert.ToString(txtSaleExectStartDate1.Text.Trim());
}
else
{
objExamFormProperty.ExamFormSaleStartDate = Convert.ToString(txtSaleNotExectStartDate1.Text.Trim()) + "," + Convert.ToString(txtSaleNotExectEndDate1.Text.Trim());
}
objExamFormProperty.ExamFromSaleStartDateRemark = Convert.ToString(txtFormSaleStartDateRemark.Text.Trim());
if (rbtFormSaleEndDate.SelectedValue == "1")
{
objExamFormProperty.ExamFormSaleEndDate = Convert.ToString(txtSaleExectEndDate2.Text.Trim());
}
else
{
objExamFormProperty.ExamFormSaleEndDate = Convert.ToString(txtSaleNotExectStartDate2.Text.Trim()) + "," + Convert.ToString(txtSaleNotExectEndDate2.Text.Trim());
}
objExamFormProperty.ExamFormSaleEndDateRemark = Convert.ToString(txtFormSaleEndDateRemark.Text.Trim());
if (rbtFormSubmitDate.SelectedValue == "1")
{
objExamFormProperty.ExamFormSubmitDate = Convert.ToString(txtFormSubmitExectDate1.Text.Trim());
}
else
{
objExamFormProperty.ExamFormSubmitDate = Convert.ToString(txtFormSubmitStartDate1.Text.Trim()) + "," + Convert.ToString(txtFormSubmitEndDate1.Text.Trim());
}
objExamFormProperty.ExamFormSubmitDateRemark = Convert.ToString(txtFormSubmitDateRemark.Text.Trim());
if (rbtResultDate.SelectedValue == "1")
{
objExamFormProperty.ExamFormResultDate = Convert.ToString(txtResultExactDate.Text.Trim());
}
else
{
objExamFormProperty.ExamFormResultDate = Convert.ToString(txtResultStartDate.Text.Trim()) + "," + Convert.ToString(txtResultEndtDate.Text.Trim());
}
objExamFormProperty.ExamFormResultDateReamrk = Convert.ToString(txtResultDateRemark.Text.Trim());
objExamFormProperty.ExamFormResultWebsite = Convert.ToString(txtFormResultWebsite.Text.Trim());
objExamFormProperty.ExamFormPrice = Convert.ToString(txtExamFormPrice.Text.Trim());
objExamFormProperty.ExamFormStore = Convert.ToString(txtExamFormStore.Text.Trim());
objExamFormProperty.ExamFormCenter = Convert.ToString(txtExamFormCenter.Text.Trim());
objExamFormProperty.ExamFormDd = Convert.ToString(txtExamFormDD.Text.Trim());
objExamFormProperty.ExamFormSyllabus = Convert.ToString(txtExamFormSyllabus.Text.Trim());
objExamFormProperty.ExamFormStatus = chkFormStatus.Checked == true ? true : false;
int insert = 0;
if (btnExamForm.Text == "Add")
{
insert = ExamProvider.Instance.InsertExamFormDetails(objExamFormProperty, LoggedInUserId, out ErrorMsg);
Response.Redirect("ManageExamFormMaster.aspx", true);
}
else
{
objExamFormProperty.ExamFormId = Convert.ToInt32(Request.QueryString["ExamFormId"].ToString());
insert = ExamProvider.Instance.UpdateExamFormDetails(objExamFormProperty, LoggedInUserId, out ErrorMsg);
btnExamForm.Text = "Add";
Response.Redirect("ManageExamFormMaster.aspx", false);
lblInsertUpdate.Text = "Insert";
lblHeader.Text = "Add Exam Form Master";
}
if (insert > 0)
{
lblSeccessMsg.Visible = true;
lblSeccessMsg.Text = ErrorMsg;
}
else
{
lblErorrMsg.Visible = true;
lblErorrMsg.Text = ErrorMsg;
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.InnerException.Message;
}
const string addInfo = "Error while executing InsertStateDetails in State.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
public abstract int UpdateExamFormDetails(ExamFormProperty objExamFormProperty, int modifiedBy, out string errmsg);
public abstract int InsertExamFormDetails(ExamFormProperty objExamFormProperty, int createdBy, out string errmsg);
