protected void gridListInvoice_DetailRowExpandedChanged(object sender, ASPxGridViewDetailRowEventArgs e) { //initialize control BootstrapGridView grid = (BootstrapGridView)sender; BootstrapTextBox txtInvoiceNumber = (BootstrapTextBox)grid.FindDetailRowTemplateControl(e.VisibleIndex, "txtInvoiceNumber"); BootstrapTextBox txtApproveBy = (BootstrapTextBox)grid.FindDetailRowTemplateControl(e.VisibleIndex, "txtApproveBy"); BootstrapDateEdit dateInvoice = (BootstrapDateEdit)grid.FindDetailRowTemplateControl(e.VisibleIndex, "dateInvoice"); BootstrapMemo txtNote = (BootstrapMemo)grid.FindDetailRowTemplateControl(e.VisibleIndex, "txtNote"); //bind control if (txtInvoiceNumber == null) { return; } txtInvoiceNumber.Text = grid.GetRowValues(e.VisibleIndex, "InvoiceNumber").ToString(); txtApproveBy.Text = grid.GetRowValues(e.VisibleIndex, "ApproveBy") != null?grid.GetRowValues(e.VisibleIndex, "ApproveBy").ToString() : string.Empty; txtNote.Text = grid.GetRowValues(e.VisibleIndex, "Note") != null?grid.GetRowValues(e.VisibleIndex, "Note").ToString() : string.Empty; DateTime InvoiceDate = Convert.ToDateTime(grid.GetRowValues(e.VisibleIndex, "InvoiceDate")); if (InvoiceDate != DateTime.Parse("1/1/1900")) { dateInvoice.Value = InvoiceDate; } else { dateInvoice.Value = null; } }
protected void deBirthday_Init(object sender, EventArgs e) { BootstrapDateEdit de = sender as BootstrapDateEdit; if (!gv.IsNewRowEditing) { de.Date = Convert.ToDateTime(gv.GetRowValues(gv.EditingRowVisibleIndex, "Birthday")); } }
protected MasterDataModel.MasterDataDriver GetGvValue(BootstrapGridView gv, int key = 0) { BootstrapTextBox txtName = gv.FindEditFormTemplateControl("txtName") as BootstrapTextBox; BootstrapComboBox cmbTransportir = gv.FindEditFormTemplateControl("cmbTransportir") as BootstrapComboBox; BootstrapDateEdit deBirthday = gv.FindEditFormTemplateControl("deBirthday") as BootstrapDateEdit; BootstrapMemo txtAddress = gv.FindEditFormTemplateControl("txtAddress") as BootstrapMemo; BootstrapTextBox txtEmail = gv.FindEditFormTemplateControl("txtEmail") as BootstrapTextBox; BootstrapTextBox txtPhone1 = gv.FindEditFormTemplateControl("txtPhone1") as BootstrapTextBox; BootstrapTextBox txtPhone2 = gv.FindEditFormTemplateControl("txtPhone2") as BootstrapTextBox; MasterDataModel.MasterDataDriver item = new MasterDataModel.MasterDataDriver(); item.Driver_ID = key; item.Name = txtName.Text; item.Transporter_ID = Convert.ToInt32(cmbTransportir.Value); if (deBirthday.Value != null) { item.Birthday = deBirthday.Date; } else { item.Birthday = null; } item.Address = txtAddress.Text; item.Email = txtEmail.Text; item.Phone1 = txtPhone1.Text; item.Phone2 = txtPhone2.Text; item.CreationBy = UserProfile.Username; item.UpdateBy = UserProfile.Username; if (Session["DriverPhotoImageName"] != null && Session["DriverPhotoImageBytes"] != null) { item.ImageName = Convert.ToString(Session["DriverPhotoImageName"]); item.ImageBytes = (byte[])Session["DriverPhotoImageBytes"]; Session["DriverPhotoImageName"] = null; Session["DriverPhotoImageBytes"] = null; } return(item); }
/// <summary> /// This method fires when the user clicks the save button for a row and it saves the trainings /// for the user to the database /// </summary> /// <param name="sender">The lbSaveTrainings LinkButton</param> /// <param name="e">The click event</param> protected void lbSaveTrainings_Click(object sender, EventArgs e) { try { //To hold the training dates DateTime?PBCDate = null, ICECPDate = null, TPOTDate = null, TPITOSDate = null; //Get the calling button LinkButton thisButton = (LinkButton)sender; //Get the calling button container GridViewDataItemTemplateContainer buttonContainer = (GridViewDataItemTemplateContainer)thisButton.NamingContainer; //Get the DateEdits from the row in which the button resides BootstrapDateEdit dePBC = (BootstrapDateEdit)bsGREmployees.FindRowCellTemplateControl(buttonContainer.VisibleIndex, (GridViewDataColumn)bsGREmployees.Columns["CoachColumn"], "dePBCDate"); BootstrapDateEdit deICECPDate = (BootstrapDateEdit)bsGREmployees.FindRowCellTemplateControl(buttonContainer.VisibleIndex, (GridViewDataColumn)bsGREmployees.Columns["CoachColumn"], "deICECPDate"); BootstrapDateEdit deTPOTTrainingDate = (BootstrapDateEdit)bsGREmployees.FindRowCellTemplateControl(buttonContainer.VisibleIndex, (GridViewDataColumn)bsGREmployees.Columns["ObserverColumn"], "deTPOTTrainingDate"); BootstrapDateEdit deTPITOSTrainingDate = (BootstrapDateEdit)bsGREmployees.FindRowCellTemplateControl(buttonContainer.VisibleIndex, (GridViewDataColumn)bsGREmployees.Columns["ObserverColumn"], "deTPITOSTrainingDate"); //Get the employee PK and name int employeePK = Convert.ToInt32(bsGREmployees.GetRowValues(buttonContainer.VisibleIndex, "ProgramEmployeePK")); string employeeName = Convert.ToString(bsGREmployees.GetRowValues(buttonContainer.VisibleIndex, "Name")); //Get the training dates from the DateEdits PBCDate = (dePBC.Value == null ? (DateTime?)null : Convert.ToDateTime(dePBC.Value)); ICECPDate = (deICECPDate.Value == null ? (DateTime?)null : Convert.ToDateTime(deICECPDate.Value)); TPOTDate = (deTPOTTrainingDate.Value == null ? (DateTime?)null : Convert.ToDateTime(deTPOTTrainingDate.Value)); TPITOSDate = (deTPITOSTrainingDate.Value == null ? (DateTime?)null : Convert.ToDateTime(deTPITOSTrainingDate.Value)); //Only continue if the employee PK has a value if (employeePK > 0) { using (PyramidContext context = new PyramidContext()) { //To hold the training acronyms of the added trainings List <string> trainingsAdded = new List <string>(); //Check each training date to see if it was added if (PBCDate.HasValue) { //Add the PBC training to the database Training PBCTraining = new Training(); PBCTraining.CreateDate = DateTime.Now; PBCTraining.Creator = User.Identity.Name; PBCTraining.ProgramEmployeeFK = employeePK; PBCTraining.TrainingCodeFK = (int)Utilities.TrainingFKs.PRACTICE_BASED_COACHING; PBCTraining.TrainingDate = PBCDate.Value; context.Training.Add(PBCTraining); //Add the PBC training to the list trainingsAdded.Add("PBC"); } if (ICECPDate.HasValue) { //Add the ICECP training to the database Training ICECPTraining = new Training(); ICECPTraining.CreateDate = DateTime.Now; ICECPTraining.Creator = User.Identity.Name; ICECPTraining.ProgramEmployeeFK = employeePK; ICECPTraining.TrainingCodeFK = (int)Utilities.TrainingFKs.INTRODUCTION_TO_COACHING; ICECPTraining.TrainingDate = ICECPDate.Value; context.Training.Add(ICECPTraining); //Add the ICECP training to the list trainingsAdded.Add("ICECP"); } if (TPOTDate.HasValue) { //Add the TPOT observer training to the database Training TPOTTraining = new Training(); TPOTTraining.CreateDate = DateTime.Now; TPOTTraining.Creator = User.Identity.Name; TPOTTraining.ProgramEmployeeFK = employeePK; TPOTTraining.TrainingCodeFK = (int)Utilities.TrainingFKs.TPOT_OBSERVER; TPOTTraining.TrainingDate = TPOTDate.Value; context.Training.Add(TPOTTraining); //Add the TPOT observer training to the list trainingsAdded.Add("TPOT Observer"); } if (TPITOSDate.HasValue) { //Add the TPITOS observer training to the database Training TPITOSTraining = new Training(); TPITOSTraining.CreateDate = DateTime.Now; TPITOSTraining.Creator = User.Identity.Name; TPITOSTraining.ProgramEmployeeFK = employeePK; TPITOSTraining.TrainingCodeFK = (int)Utilities.TrainingFKs.TPITOS_OBSERVER; TPITOSTraining.TrainingDate = TPITOSDate.Value; context.Training.Add(TPITOSTraining); //Add the TPITOS observer training to the list trainingsAdded.Add("TPITOS Observer"); } //Check to see if any changes were made if (trainingsAdded.Count > 0) { //Save the trainings to the database context.SaveChanges(); //Refresh the gridview bsGREmployees.DataBind(); //Show the user a message msgSys.ShowMessageToUser("success", "Trainings Added", string.Join(",", trainingsAdded) + " trainings were added for " + employeeName, 10000); } else { //Show the user a warning msgSys.ShowMessageToUser("warning", "No Dates Detected", "No training dates were entered, and no changes have been saved.", 5000); } } } else { //Show the user a warning msgSys.ShowMessageToUser("warning", "No Employee Info Found", "The system was unable to determine the employee, please try again.", 5000); } } catch (Exception ex) { //Log the exception Utilities.LogException(ex); //Show the user the message msgSys.ShowMessageToUser("danger", "Error!", "An error occurred. Message: " + ex.Message, 5000); } }