public override int UpdateUnivesityCategoryDetails(BO.UniversityCategoryProperty objUniversityCategory, int modifiedBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = "";
try
{
_objDataWrapper.AddParameter("@UniversityCategoryId", objUniversityCategory.UniversityCategoryId);
_objDataWrapper.AddParameter("@UniversityCategoryName", objUniversityCategory.UniversityCategoryName);
_objDataWrapper.AddParameter("@CreatedBy", modifiedBy);
var objErrMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateUniversityCategoryDetails");
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 UpdateUnivesityCategoryDetails in University.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
// private method to bind The Object List Of The university Categoty object
private List <BO.UniversityCategoryProperty> BindUniversityCategoryObject(DataTable datatable)
{
var objUniversityCategoryList = new List <BO.UniversityCategoryProperty>();
try
{
if (datatable.Rows.Count > 0)
{
for (var j = 0; j < datatable.Rows.Count; j++)
{
var objUniversityCategory = new BO.UniversityCategoryProperty
{
UniversityCategoryId = Convert.ToInt32(datatable.Rows[j]["AjUniversityCategoryId"]),
UniversityCategoryName = Convert.ToString(datatable.Rows[j]["AjUniversityCategoryName"])
};
objUniversityCategoryList.Add(objUniversityCategory);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindUniversityCategoryObject in University.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objUniversityCategoryList);
}
public abstract int UpdateUnivesityCategoryDetails(BO.UniversityCategoryProperty objUniversityCategory, int modifiedBy, out string errmsg);
public abstract int InsertUniversityCategoryDetails(BO.UniversityCategoryProperty objUniversityCategory, int createdBy, out string errmsg);
