public void BindTrainers() { DataTable dt = BLL_Crew_Training.Get_Crew_Trainers(GetSessionUserID()); gvTrainers.DataSource = dt; gvTrainers.DataBind(); }
public void BindTrainingTypes() { int rowcount = ucCustomPagerItems.isCountRecord; string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } DataTable dt = BLL_Crew_Training.Get_Crew_TrainingTypes(txtFilter_TrainingType.Text, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } if (dt.Rows.Count > 0) { gvTrainingTypes.DataSource = dt; gvTrainingTypes.DataBind(); } else { gvTrainingTypes.DataSource = dt; gvTrainingTypes.DataBind(); } }
protected void Load_Trainings() { int CrewID = UDFLib.ConvertToInteger(Request.QueryString["CrewID"]); DataTable dt = BLL_Crew_Training.Get_Crew_Trainings(CrewID, GetSessionUserID()); GridView_Trainings.DataSource = dt; GridView_Trainings.DataBind(); }
protected void ImgExpExcel_Click(object sender, EventArgs e) { DataTable dt = BLL_Crew_Training.Get_Crew_Trainers(GetSessionUserID()); string[] HeaderCaptions = { "Trainer Name" }; string[] DataColumnsName = { "TrainerName" }; GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "CrewTrainers", "Crew Trainers", ""); }
protected void Load_TraiingTypes() { DataTable dt = BLL_Crew_Training.Get_Crew_TrainingTypes(); ddlTrainingType.DataSource = dt; ddlTrainingType.DataValueField = "TrainingTypeID"; ddlTrainingType.DataTextField = "TrainingTypeName"; ddlTrainingType.DataBind(); }
protected void Load_Trainers() { DataTable dt = BLL_Crew_Training.Get_Crew_Trainers(GetSessionUserID()); ddlTrainer.DataSource = dt; ddlTrainer.DataValueField = "LibUserID"; ddlTrainer.DataTextField = "TrainerName"; ddlTrainer.DataBind(); }
protected void Load_Attachments(int TrainingID) { DataTable dtAttachments = BLL_Crew_Training.Get_Training_Attachments(TrainingID, GetSessionUserID()); rptAttachments.DataSource = dtAttachments; rptAttachments.DataBind(); rptAttachmentse.DataSource = dtAttachments; rptAttachmentse.DataBind(); }
protected void ImgExpExcel_Click(object sender, EventArgs e) { int rowcount = ucCustomPagerItems.isCountRecord; DataTable dt = BLL_Crew_Training.Get_Crew_TrainingTypes(); string[] HeaderCaptions = { "Training Type ID", "Training Type" }; string[] DataColumnsName = { "TrainingTypeID", "TrainingTypeName" }; GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "TrainingTypes", "TrainingTypes", ""); }
protected void ImgAdd_Click(object sender, EventArgs e) { if (Convert.ToInt32(lstUserList.SelectedValue) > 0) { int retval = BLL_Crew_Training.INSERT_Crew_Trainer(Convert.ToInt32(lstUserList.SelectedValue), Convert.ToInt32(Session["USERID"])); BindTrainers(); } else { string js = "alert('Please select user name from the list')"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "js1", js, true); } }
protected void Load_TrainingToEdit(int TrainingID) { int CrewID = UDFLib.ConvertToInteger(Request.QueryString["CrewID"]); DataTable dt = BLL_Crew_Training.Get_Crew_Trainings(CrewID, TrainingID, GetSessionUserID()); if (dt.Rows.Count > 0) { txtDateofTraining.Text = UDFLib.ConvertUserDateFormat(Convert.ToString(dt.Rows[0]["StartDate"])); ddlTrainer.SelectedValue = dt.Rows[0]["Trainer"].ToString(); ddlTrainingType.SelectedValue = dt.Rows[0]["TrainingType"].ToString(); txtResult.Text = dt.Rows[0]["Result"].ToString(); txtRemarks.Text = dt.Rows[0]["Remarks"].ToString(); } Load_Attachments(TrainingID); }
public int UploadFile(byte[] bFile, string sFilePath, string DisplayName) { int iAttachID = 0; try { FileStream fileStream = new FileStream(sFilePath, FileMode.Create, FileAccess.ReadWrite); fileStream.Write(bFile, 0, bFile.Length); fileStream.Close(); iAttachID = BLL_Crew_Training.INSERT_Training_Attachment(DisplayName, Path.GetFileName(sFilePath), bFile.Length, 0, 0); } catch { } return(iAttachID); }
public string InsertVideoView(string userid, string chaperid, string itemname) { try { DataTable dt = new DataTable(); dt.Columns.Add("PID", typeof(int)); BLL_Crew_Training.INSERT_Training(UDFLib.ConvertToInteger(userid), DateTime.Now, 1, UDFLib.ConvertToInteger(userid), "Video", Convert.ToDecimal(1), UDFLib.ConvertToInteger(userid), dt, Convert.ToInt32(chaperid), itemname); return(""); } catch { return(""); } }
protected void btnsave_Click(object sender, EventArgs e) { if (HiddenFlag.Value == "Add") { int retval = BLL_Crew_Training.INSERT_TrainingType(txtTrainingType.Text, Convert.ToInt32(Session["USERID"])); } else { int retval = BLL_Crew_Training.UPDATE_TrainingType(Convert.ToInt32(hdnTrainingTypeID.Value.Trim()), txtTrainingType.Text, Convert.ToInt32(Session["USERID"])); } BindTrainingTypes(); string hidemodal = String.Format("hideModal('divadd')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hidemodal", hidemodal, true); }
protected void onUpdate(object source, CommandEventArgs e) { HiddenFlag.Value = "Edit"; OperationMode = "Edit"; DataTable dt = new DataTable(); dt = BLL_Crew_Training.Get_Crew_TrainingTypes(Convert.ToInt32(e.CommandArgument.ToString())); if (dt.Rows.Count > 0) { hdnTrainingTypeID.Value = dt.Rows[0]["TrainingTypeID"].ToString(); txtTrainingType.Text = dt.Rows[0]["TrainingTypeName"].ToString(); string js = String.Format("showModal('divadd',false);"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "TradeZone", js, true); } }
public string Get_Training_Attachments(int TrainingID, int UserID) { DataTable dt = BLL_Crew_Training.Get_Training_Attachments(TrainingID, UserID); UDCHyperLink aLink = new UDCHyperLink("DocURL", "", new string[] { }, new string[] { }, "_blank"); Dictionary <string, UDCHyperLink> dicLink = new Dictionary <string, UDCHyperLink>(); dicLink.Add("DisplayName", aLink); return(UDFLib.CreateHtmlTableFromDataTable(dt, new string[] { "Attachments" }, new string[] { "DisplayName" }, dicLink, new Dictionary <string, UDCToolTip>(), new string[] { "left" }, "CrewQuery-Attachments-table", "CrewQuery-Attachments-DataHeder", "CrewQuery-Attachments-Data")); }
private int Save_Training(string Mode) { int Res = 0; string js = ""; if (UDFLib.ConvertDateToNull(txtDateofTraining.Text) == null || UDFLib.ConvertToInteger(ddlTrainingType.SelectedValue) == 0 || UDFLib.ConvertToInteger(ddlTrainer.SelectedValue) == 0) { js = "alert('Unable to save as some of the fields are left blank');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "js1", js, true); } else { int CrewID = UDFLib.ConvertToInteger(HiddenField_CrewID.Value); string Date_Of_Training = txtDateofTraining.Text; int TrainingType = UDFLib.ConvertToInteger(ddlTrainingType.Text); int Trainer = UDFLib.ConvertToInteger(ddlTrainer.SelectedValue); decimal Result = UDFLib.ConvertToDecimal(txtResult.Text); string Remarks = txtRemarks.Text; string EditMode = Request.QueryString["Mode"]; DataTable dt = new DataTable(); dt.Columns.Add("PID"); if (HiddenField_SelectedFiles.Value != "") { string Attachments = HiddenField_SelectedFiles.Value; foreach (string id in Attachments.Split(',')) { DataRow dr = dt.NewRow(); dr["PID"] = id; dt.Rows.Add(dr); } } if (EditMode == "EDIT") { int TrainingID = UDFLib.ConvertToInteger(Request.QueryString["TrainingID"]); Res = BLL_Crew_Training.UPDATE_Training(TrainingID, Convert.ToDateTime(txtDateofTraining.Text), UDFLib.ConvertToInteger(ddlTrainingType.SelectedValue), UDFLib.ConvertToInteger(ddlTrainer.SelectedValue), txtRemarks.Text, Result, GetSessionUserID(), dt); js = "parent.GetCrewTrainingLog(" + HiddenField_CrewID.Value.ToString() + ");"; ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", js, true); } //else if (EditMode == "INSERT") //{ // Res = BLL_Crew_Training.INSERT_Training(CrewID, Convert.ToDateTime(txtDateofTraining.Text), UDFLib.ConvertToInteger(ddlTrainingType.SelectedValue), UDFLib.ConvertToInteger(ddlTrainer.SelectedValue), txtRemarks.Text, Result, GetSessionUserID(), dt, 0, ""); // js = "parent.GetCrewTrainingLog(" + HiddenField_CrewID.Value.ToString() + ");"; // ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", js, true); //} if (Mode == "SaveAndClose") { string js1 = "parent.hideModal('dvPopupFrame');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "msgc", js1, true); } else { Load_Attachments(UDFLib.ConvertToInteger(Request.QueryString["TrainingID"])); } } return(Res); }
protected void onDelete(object source, CommandEventArgs e) { int retval = BLL_Crew_Training.DELETE_TrainingType(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session["USERID"])); BindTrainingTypes(); }