protected void loadgrid()
{
try
{
_obj_smhr_workshops = new SMHR_EMPWORKSHOPSATTENDED();
_obj_smhr_workshops.OPERATION = operation.Select;
_obj_smhr_workshops.EMPWRKSHOPS_ORGID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_workshops.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
DataTable dt = BLL.get_workshops(_obj_smhr_workshops);
if (dt.Rows.Count != 0)
{
RG_EmpWorkshopform.DataSource = dt;
RG_EmpWorkshopform.DataBind();
}
else
{
DataTable dt1 = new DataTable();
RG_EmpWorkshopform.DataSource = dt1;
RG_EmpWorkshopform.DataBind();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_EmpWorkshops", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
public void FileUpload()
{
try
{
if (FUpload.HasFile)
{
DataTable dt_Docs = (DataTable)Session["dt_Docs"];
DataRow dr = dt_Docs.NewRow();
string filename = Convert.ToString(FUpload.FileName.Trim().Replace("'", "''"));
dr[0] = dt_Docs.Rows.Count + 1;
dr[2] = Convert.ToString(FUpload.FileName);
dt_Docs.Rows.Add(dr);
if (!string.IsNullOrEmpty(filename))
{
FUpload.PostedFile.SaveAs(System.IO.Path.Combine(Server.MapPath("~/EmpUploads/DocUploads/"), "WorkShop" + "_" + BUFilter1.EmployeeID + "_" + filename));
dr[3] = "~/EmpUploads/DocUploads/" + "WorkShop" + "_" + BUFilter1.EmployeeID + "_" + filename;
}
dt_Docs.DefaultView.Sort = "EMPWRKSHOPS_DOCNAME";
dt_Docs = dt_Docs.DefaultView.ToTable();
RG_EmpWorkshopform.DataSource = dt_Docs;
RG_EmpWorkshopform.DataBind();
Session["dt_Docs"] = dt_Docs;
_obj_smhr_workshops.EMPWRKSHOPS_PARTCERTDOCNAME = filename;
_obj_smhr_workshops.EMPWRKSHOPS_PARTCERTDOCUPLOAD = "~/EmpUploads/DocUploads/" + "WorkShop" + BUFilter1.EmployeeID + "_" + filename;
}
else
{
BLL.ShowMessage(this, "Please Browse Document before Upload.");
return;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_EmpWorkshops", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
