protected void BtnUploadClick(object sender, EventArgs e)
{
_objCommon = new Common();
try
{
_objExamProperty = new ExamProperty();
var _ds = new DataSet();
var objClsOledbdatalayer = new ClsOleDBDataWrapper();
var path = MapPath(fileUploadExcel.FileName);
fileUploadExcel.SaveAs(path);
var excelSheets = objClsOledbdatalayer.CountTotalSheets(path);
if (excelSheets.Length > 0)
{
foreach (var t in excelSheets)
{
_ds = objClsOledbdatalayer.getdata(path, t);
if (_ds != null && _ds.Tables.Count > 0)
{
for (int j = 0; j <= _ds.Tables[0].Rows.Count - 1; j++)
{
_objExamProperty.CourseId = Convert.ToInt32(_ds.Tables[0].Rows[j]["CourseId"]);
_objExamProperty.ExamName = Convert.ToString(_ds.Tables[0].Rows[j]["ExamName"]);
_objExamProperty.ExamFullName = Convert.ToString(_ds.Tables[0].Rows[j]["ExamFullName"]);
_objExamProperty.ExamLogo = Convert.ToString(_ds.Tables[0].Rows[j]["ExamLogo"]);
_objExamProperty.ExamDesc = Convert.ToString(_ds.Tables[0].Rows[j]["ExamDesc"]);
_objExamProperty.ExamWebSite = Convert.ToString(_ds.Tables[0].Rows[j]["ExamWebsite"]);
_objExamProperty.ExamPopularName = Convert.ToString(_ds.Tables[0].Rows[j]["ExamPopularName"]);
_objExamProperty.ExamEligiblityCriteria = Convert.ToString(_ds.Tables[0].Rows[j]["ExamEligiblityCriteria"]);
_objExamProperty.ExamStatus = Convert.ToBoolean(_ds.Tables[0].Rows[j]["ExamStatus"]);
var errMsg = "";
var insert = ExamProvider.Instance.InsertExamDetails(_objExamProperty, 1, out errMsg);
if (insert <= 0)
{
continue;
}
lblRecordsInserted.Text = "";
lblRecordsInserted.Text = j + " row inserted out of " + _ds.Tables[0].Rows.Count;
}
}
}
lblSeccessMsg.Text = _objCommon.GetErrorMessage("lblSucessMsg");
lblSeccessMsg.Visible = true;
BindAllCourseList();
}
else
{
lblErorrMsg.Text = _objCommon.GetErrorMessage("lblErrMsg");
}
}
catch (Exception ex)
{ }
}
private List <ExamProperty> BindExamListObject(DataTable dataTable)
{
var examObjectList = new List <ExamProperty>();
try
{
if (dataTable.Rows.Count > 0)
{
for (var j = 0; j < dataTable.Rows.Count; j++)
{
var objExamProperty = new ExamProperty
{
ExamId = Convert.ToInt32(dataTable.Rows[j]["AjExamId"]),
CourseName = Convert.ToString(dataTable.Rows[j]["AjCourseName"]),
ExamDesc = Convert.ToString(dataTable.Rows[j]["AjExamDesc"]),
ExamEligiblityCriteria =
Convert.ToString(dataTable.Rows[j]["AjExamEligiblityCriteria"]),
ExamFullName = Convert.ToString(dataTable.Rows[j]["AjExamFullName"]),
ExamLogo = Convert.ToString(dataTable.Rows[j]["AjExamLogo"]),
ExamName = Convert.ToString(dataTable.Rows[j]["AjExamName"]),
ExamPopularName =
Convert.ToString(dataTable.Rows[j]["AjExamPopularName"]),
ExamWebSite = Convert.ToString(dataTable.Rows[j]["AjExamWebsite"]),
CourseId = Convert.ToInt32(dataTable.Rows[j]["AjCourseId"]),
ExamStatus = Convert.ToBoolean(dataTable.Rows[j]["AjExamStatus"]),
HelpLineNumber = Convert.ToString(dataTable.Columns.Contains("AjHelpLineNo") ? (dataTable.Rows[j]["AjHelpLineNo"].ToString() != "" ? dataTable.Rows[j]["AjHelpLineNo"] : null) : null),
};
examObjectList.Add(objExamProperty);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindExamListObject in Exam.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(examObjectList);
}
public override int UpdateExamDetails(ExamProperty objExamProperty, int modifiedBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = string.Empty;
try
{
_objDataWrapper.AddParameter("@ExamId", objExamProperty.ExamId);
_objDataWrapper.AddParameter("@ExamName", objExamProperty.ExamName);
_objDataWrapper.AddParameter("@CourseId", objExamProperty.CourseId);
_objDataWrapper.AddParameter("@ExamFullName", objExamProperty.ExamFullName);
_objDataWrapper.AddParameter("@ExamPopularName", objExamProperty.ExamPopularName);
_objDataWrapper.AddParameter("@ExamLogo", objExamProperty.ExamLogo);
_objDataWrapper.AddParameter("@ExamDesc", objExamProperty.ExamDesc);
_objDataWrapper.AddParameter("@ExamWebsite", objExamProperty.ExamWebSite);
_objDataWrapper.AddParameter("@ExamEligiblityCriteria", objExamProperty.ExamEligiblityCriteria);
_objDataWrapper.AddParameter("@ExamStatus", objExamProperty.ExamStatus);
_objDataWrapper.AddParameter("@CreatedBy", modifiedBy);
var objErrMsg =
(SqlParameter)
(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateExam");
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 UpdateExamDetails in Exam.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
protected void btnExam_Click(object sender, EventArgs e)
{
var fileName = this.flUploadImage.FileName;
if (!string.IsNullOrEmpty(fileName))
{
hdnFileName.Value = fileName;
flUploadImage.SaveAs(Server.MapPath(new Common().GetFilepath("ExamImg") + fileName));
}
try
{
var objExamProperty = new ExamProperty
{
CourseId =
Convert.ToInt32(ddlCourseName.SelectedValue.ToString()),
ExamName = Convert.ToString(txtExamName.Text.Trim()),
ExamFullName = Convert.ToString(txtExamFullName.Text.Trim()),
ExamPopularName =
Convert.ToString(txtPopularName.Text.Trim()),
ExamEligiblityCriteria =
Convert.ToString(txtEligiblityCriteria.Text.Trim()),
ExamLogo = hdnFileName.Value,
ExamDesc =
Convert.ToString(txtExamDescription.FckValue.Trim()),
ExamWebSite = Convert.ToString(txtWebSite.Text.Trim()),
ExamStatus = chkStatus.Checked
};
string errorMsg;
int insert;
if (btnCourse.Text == "Add")
{
insert = ExamProvider.Instance.InsertExamDetails(objExamProperty, LoggedInUserId, out errorMsg);
BindExamMasterDetail();
ClearFields();
}
else
{
objExamProperty.ExamId = Convert.ToInt32(hdnExamMaster.Value);
insert = ExamProvider.Instance.UpdateExamDetails(objExamProperty, LoggedInUserId, out errorMsg);
BindExamMasterDetail();
ClearFields();
btnCourse.Text = "Add";
lblRecordsInserted.Text = "Insert";
lblInsertUpdate.Text = "Add Exam Details";
}
if (insert > 0)
{
lblSeccessMsg.Visible = true;
lblSeccessMsg.Text = errorMsg;
}
else
{
lblErorrMsg.Visible = true;
lblErorrMsg.Text = errorMsg;
}
}
catch (Exception ex)
{
string err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.InnerException.Message;
}
const string addInfo = "Error :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
public abstract int UpdateExamDetails(ExamProperty objExamProperty, int modifiedBy, out string errmsg);
public abstract int InsertExamDetails(ExamProperty objExamProperty, int createdBy, out string errmsg);
