//Method to UpdateStreamMaster by indu kumar pandey...
protected void UpdateStreamMaster()
{
try
{
var errMsg = "";
_objCourseStreamProperty = new CourseStreamProperty
{
StreamId = Convert.ToInt16(Request.QueryString["StreamId"]),
CourseStreamName = txtCourseStreamName.Text.Trim(),
CourseId = Convert.ToInt16(ddlCourseId.Text.Trim()),
CourseStreamUrl = txtCourseStreamUrl.Text.Trim(),
CourseStreamTitle = txtCourseStreamTitle.Text.Trim(),
CourseStreamMetaTag = txtStreamMetaTag.Text.Trim(),
CourseStreamMetaDesc = txtStreamMetaDesc.Text.Trim(),
CourseStreamDesc = fckStreamDesc.FckValue.Trim(),
CourseStreamHistory = txtCourseStreamHistory.Text.Trim(),
CourseSteamFuture = txtCourseStreamFuture.Text.Trim(),
CourseStreamCoreCompanies = txtCourseStreamCoreCompanies.Text.Trim(),
CourseStreamRelatedIndustry =
txtCourseStreamRelatedIndustry.Text.Trim(),
CourseStreamStatus =
Convert.ToBoolean(chkbCourseStreamStatus.Checked)
};
int result = StreamProvider.Instance.UpdateCourseStreamDetails(_objCourseStreamProperty, LoggedInUserId,
out errMsg);
if (result > 0)
{
btntCourseCategory.Text = "Update";
lblHeader.Text = "Add Course Stream Master";
}
else
{
lblError.Visible = true;
lblError.Text = errMsg;
lblSuccess.Text = "";
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex;
}
const string addInfo = "Error while executing UpdateStreamMaster in AddCourseStreamMaster.aspx :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
//event BtnUploadClick to upload stream detials by indu kumar pandey...
protected void BtnUploadClick(object sender, EventArgs e)
{
_objCommon = new Common();
try
{
var objClsOledbdatalayer = new ClsOleDBDataWrapper();
var path = MapPath(fulUploadExcel.FileName);
fulUploadExcel.SaveAs(path);
var excelSheets = objClsOledbdatalayer.CountTotalSheets(path);
if (excelSheets.Length > 0)
{
foreach (string t in excelSheets)
{
DataSet ds = objClsOledbdatalayer.getdata(path, t);
if (ds.Tables[0].Rows.Count > 0)
{
for (var j = 0; j <= ds.Tables[0].Rows.Count - 1; j++)
{
var errMsg = "";
_objCourseStreamProperty = new CourseStreamProperty
{
CourseStreamName = Convert.ToString(ds.Tables[0].Rows[j]["AjCourseStreamName"]),
CourseId = Convert.ToInt16(ds.Tables[0].Rows[j]["CourseId"]),
CourseStreamHistory = Convert.ToString(ds.Tables[0].Rows[j]["AjCourseStreamHistory"]),
CourseSteamFuture = Convert.ToString(ds.Tables[0].Rows[j]["AjCourseStreamFuture"]),
CourseStreamRelatedIndustry = Convert.ToString(ds.Tables[0].Rows[j]["AjCourseStreamRelatedIndustry"]),
CourseStreamStatus = ds.Tables[0].Rows[j]["AjCourseStreamStatus"].ToString() == "True" ? true : false,
CourseStreamDesc = Convert.ToString(ds.Tables[0].Rows[j]["AjCourseStreamDesc"]),
CourseStreamCoreCompanies = Convert.ToString(ds.Tables[0].Rows[j]["AjCourseStreamCoreCompanies"])
};
var result = StreamProvider.Instance.InsertCourseStreamDetails(_objCourseStreamProperty, LoggedInUserId, out errMsg);
}
lblSuccess.Text = _objCommon.GetErrorMessage("lblSucessMsg");
Response.Redirect("CourseStreamMaster.aspx");
}
}
}
else
{
lblError.Text = _objCommon.GetErrorMessage("lblErrMsg");
}
}
catch (Exception ex)
{ }
}
// This is private member that will bind the Coutse stream Object List
private List <CourseStreamProperty> BindStreamObjectList(DataTable datatable)
{
var courseStreamObjectList = new List <CourseStreamProperty>();
try
{
if (datatable.Rows.Count > 0)
{
for (var j = 0; j < datatable.Rows.Count; j++)
{
var objCourseStream = new CourseStreamProperty
{
CourseId = Convert.ToInt32(datatable.Rows[j]["AjCourseId"]),
CourseName = Convert.ToString(datatable.Rows[j]["AjCourseName"]),
CourseSteamFuture = Convert.ToString(datatable.Rows[j]["AjCourseStreamFuture"]),
CourseStreamCoreCompanies = Convert.ToString(datatable.Rows[j]["AjCourseStreamCoreCompanies"]),
CourseStreamDesc = Convert.ToString(datatable.Rows[j]["AjCourseStreamDesc"]),
CourseStreamHistory = Convert.ToString(datatable.Rows[j]["AjCourseStreamHistory"]),
CourseStreamMetaDesc = Convert.ToString(datatable.Rows[j]["AjCourseStreamMetaDesc"]),
CourseStreamMetaTag = Convert.ToString(datatable.Rows[j]["AjCourseStreamMetaTag"]),
CourseStreamName = Convert.ToString(datatable.Rows[j]["AjCourseStreamName"]),
CourseStreamRelatedIndustry = Convert.ToString(datatable.Rows[j]["AjCourseStreamRelatedIndustry"]),
CourseStreamStatus = Convert.ToBoolean(datatable.Rows[j]["AjCourseStreamStatus"]),
CourseStreamTitle = Convert.ToString(datatable.Rows[j]["AjCourseStreamTitle"]),
CourseStreamUrl = Convert.ToString(datatable.Rows[j]["AjCourseStreamUrl"]),
StreamId = Convert.ToInt32(datatable.Rows[j]["AjCourseStreamId"])
};
courseStreamObjectList.Add(objCourseStream);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindStreamObjectList in Stream.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(courseStreamObjectList);
}
public override int UpdateCourseStreamDetails(CourseStreamProperty objCourseStreamProperty, int modifiedBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = "";
try
{
_objDataWrapper.AddParameter("@StreamId", objCourseStreamProperty.StreamId);
_objDataWrapper.AddParameter("@StreamName", objCourseStreamProperty.CourseStreamName);
_objDataWrapper.AddParameter("@CourseId", objCourseStreamProperty.CourseId);
_objDataWrapper.AddParameter("@CourseStreamUrl", objCourseStreamProperty.CourseStreamUrl);
_objDataWrapper.AddParameter("@CourseStreamTitle", objCourseStreamProperty.CourseStreamName);
_objDataWrapper.AddParameter("@CourseStreamMetaTag", objCourseStreamProperty.CourseStreamMetaTag);
_objDataWrapper.AddParameter("@CourseStreamMetaDesc", objCourseStreamProperty.CourseStreamMetaDesc);
_objDataWrapper.AddParameter("@CourseStreamDesc", objCourseStreamProperty.CourseStreamDesc);
_objDataWrapper.AddParameter("@CourseStreamHistory", objCourseStreamProperty.CourseStreamHistory);
_objDataWrapper.AddParameter("@CourseStreamFurture", objCourseStreamProperty.CourseSteamFuture);
_objDataWrapper.AddParameter("@CourseStreamCoreCompanies", objCourseStreamProperty.CourseStreamCoreCompanies);
_objDataWrapper.AddParameter("@CourseStreamRelatedIndustry", objCourseStreamProperty.CourseStreamRelatedIndustry);
_objDataWrapper.AddParameter("@CourseStreamStatus", objCourseStreamProperty.CourseStreamStatus);
_objDataWrapper.AddParameter("@CreatedBy", modifiedBy);
var objErrmsg = (SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateCourseStreamDetails");
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 UpdateCourseStreamDetails in Stream.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public abstract int UpdateCourseStreamDetails(CourseStreamProperty objCourseStreamProperty, int modifiedBy, out string errmsg);
public abstract int InsertCourseStreamDetails(CourseStreamProperty objCourseStreamProperty, int createdBy, out string errmsg);
