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);
