protected void InsertCollegeGroupDetails() { try { if (flpImgUpload.HasFile) { hdnFileName.Value = flpImgUpload.FileName; flpImgUpload.SaveAs(Server.MapPath(new Common().GetFilepath("UniversityImage") + hdnFileName.Value)); } string errMsg; _objCollegeGroupProperty = new CollegeGroupProperty { CollegeGroupName = txtCollegeGroupName.Text, CollegeGropuStatus = chkStatus.Checked, CollegeGroupLogo = hdnFileName.Value }; var result = CollegeProvider.Instance.InsertCollegeGroupDetails(_objCollegeGroupProperty, LoggedInUserId, out errMsg); lblSuccess.Visible = true; lblSuccess.Text = errMsg; } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.ToString(); } const string addInfo = "Error while executing InsertCollegeGroupDetails() in AddCollegeGroupMaster.aspx :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } }
//code for Excel upload protected void btnUpload_Click(object sender, EventArgs e) { lblSuccess.Visible = false; var errMsg = ""; try { _objCollegeGroupProperty = new CollegeGroupProperty(); _objCommon = new Common(); DataSet _ds = new DataSet(); var _objClsOledbdatalayer = new ClsOleDBDataWrapper(); var excelSheets = new String[0]; string path = MapPath(fileUploadExcel.FileName); fileUploadExcel.SaveAs(path); excelSheets = _objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (string t in excelSheets) { _ds = _objClsOledbdatalayer.getdata(path, t); if (_ds.Tables[0].Rows.Count > 0) { for (int j = 0; j <= _ds.Tables[0].Rows.Count - 1; j++) { _objCollegeGroupProperty = new CollegeGroupProperty { CollegeGroupName = _ds.Tables[0].Rows[j]["CollegeGroupName"].ToString(), CollegeGropuStatus = Convert.ToBoolean(_ds.Tables[0].Rows[j]["CollegeGropuStatus"].ToString()) }; int result = CollegeProvider.Instance.InsertCollegeGroupDetails(_objCollegeGroupProperty, 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"); Response.Redirect("CollegeGroupMaster.aspx"); } } } else { lblError.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { } }
public abstract int UpdateCollegeGroupDetails(CollegeGroupProperty objCollegeGroupProperty, int modifiedBy, out string errmsg);
public abstract int InsertCollegeGroupDetails(CollegeGroupProperty objCollegeGroupProperty, int createdBy, out string errmsg);