protected void UpdtaeFaqCategory()
{
string errMsg;
_objFaqCategoryProperty = new FAQCategoryProperty
{
FAQCategoryId = Convert.ToInt16(hdnFAQCategoryMaster.Value),
FAQCategoryName = txtFAQCategoryName.Text,
FAQCategoryStatus = chkFAQDetailsStatus.Checked,
};
var result = FAQProvider.Instance.UpdtaeFAQCategory(_objFaqCategoryProperty, LoggedInUserId, out errMsg);
if (result > 0)
{
btnSave.Text = "Update";
lblSuccess.Visible = true;
lblSuccess.Text = errMsg;
lblError.Text = "";
lblInform.Text = string.Empty;
lblInsert.Text = "Insert";
lblError.Text = "";
lblSuccess.Focus();
lblHeader.Text = "Add FAQ Category Master";
}
else
{
lblError.Visible = true;
lblError.Text = errMsg;
lblSuccess.Text = "";
}
lblInsert.Text = "Insert";
btnSave.Text = "Save";
}
protected void InsertFaqCategory()
{
string errMsg;
_objFaqCategoryProperty = new FAQCategoryProperty
{
FAQCategoryName = txtFAQCategoryName.Text,
FAQCategoryStatus = chkFAQDetailsStatus.Checked,
};
var result = FAQProvider.Instance.InsertFAQCategory(_objFaqCategoryProperty, LoggedInUserId, out errMsg);
if (result > 0)
{
btnSave.Text = "Save";
lblSuccess.Visible = true;
lblSuccess.Text = errMsg;
lblError.Text = "";
lblInform.Text = "";
}
else
{
lblError.Visible = true;
lblError.Text = errMsg;
}
}
public override int UpdtaeFAQCategory(FAQCategoryProperty objFAQCategoryProperty, int modifiedBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = "";
try
{
_objDataWrapper.AddParameter("@FAQCategoryId", objFAQCategoryProperty.FAQCategoryId);
_objDataWrapper.AddParameter("@FAQCategoryName", objFAQCategoryProperty.FAQCategoryName);
_objDataWrapper.AddParameter("@FAQCategoryStatus", objFAQCategoryProperty.FAQCategoryStatus);
_objDataWrapper.AddParameter("@CreatedBy", modifiedBy);
var errMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateFAQCategory");
if (errMsg != null && errMsg.Value != null)
{
errmsg = Convert.ToString(errMsg.Value);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing UpdtaeFAQCategory in FAQ.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
// Method to Bind The private member of the the Class
private List <FAQCategoryProperty> BindFAQCategoryObjectList(DataTable datatable)
{
var objFAQCategoryList = new List <FAQCategoryProperty>();
try
{
if (datatable != null && datatable.Rows.Count > 0)
{
for (var j = 0; j < datatable.Rows.Count; j++)
{
var objFAQCategory = new FAQCategoryProperty
{
FAQCategoryId = Convert.ToInt32(datatable.Rows[j]["AjFaqCategoryId"]),
FAQCategoryName = Convert.ToString(datatable.Rows[j]["AjFaqCategoryName"]),
FAQCategoryStatus = Convert.ToBoolean(datatable.Rows[j]["AjFaqStatus"])
};
objFAQCategoryList.Add(objFAQCategory);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindFAQCategoryObjectList in FAQ.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objFAQCategoryList);
}
protected void btnUpload_Click(object sender, EventArgs e)
{
_objCommon = new Common();
try
{
_objFaqCategoryProperty = new FAQCategoryProperty();
var objClsOledbdatalayer = new ClsOleDBDataWrapper();
string[] excelSheets;
var path = MapPath(fileUploadExcel.FileName);
fileUploadExcel.SaveAs(path);
excelSheets = objClsOledbdatalayer.CountTotalSheets(path);
if (excelSheets.Length > 0)
{
foreach (var t in excelSheets)
{
var _ds = objClsOledbdatalayer.getdata(path, t);
if (_ds.Tables[0].Rows.Count <= 0)
{
continue;
}
for (int j = 0; j <= _ds.Tables[0].Rows.Count - 1; j++)
{
_objFaqCategoryProperty = new FAQCategoryProperty
{
FAQCategoryName = _ds.Tables[0].Rows[j]["FAQCategoryName"].ToString(),
FAQCategoryStatus = Convert.ToBoolean(_ds.Tables[0].Rows[j]["FAQCategoryStatus"].ToString())
};
var errMsg = "";
int result = FAQProvider.Instance.InsertFAQCategory(_objFaqCategoryProperty, LoggedInUserId, out errMsg);
if (result > 0)
{
lblRecordsInserted.Text = "";
lblRecordsInserted.Text = j + " row inserted out of " + _ds.Tables[0].Rows.Count;
}
}
lblSuccess.Text = _objCommon.GetErrorMessage("lblSucessMsg");
lblSuccess.Visible = true;
}
}
else
{
lblError.Text = _objCommon.GetErrorMessage("lblErrMsg");
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.InnerException.Message;
}
const string addInfo = "Error while executing btnUpload_Click in FAQCategoryMaster.aspx :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
public abstract int UpdtaeFAQCategory(FAQCategoryProperty objFAQCategoryProperty, int modifiedBy, out string errmsg);
public abstract int InsertFAQCategory(FAQCategoryProperty objFAQCategoryProperty, int createdBy, out string errmsg);