private void BindEmployeeToll() { try { EmployeeToll employeeToll = EmployeeToll.GetEmployeeTollByEmployeeTollId(this.employeeTollId); DropDownListVehicle.Items.FindByValue(employeeToll.VehicleId.ToString()).Selected = true; TextBoxDateOfToll.Text = employeeToll.DateOfToll.ToString("yyyy/MM/dd"); DropDownListPaymentType.Items.FindByValue(employeeToll.PaymentTypeId.ToString()).Selected = true; TextBoxValue.Text = employeeToll.Value.ToString(); TextBoxDescription.Text = employeeToll.Description.ToString(); BindGridviewResult(); } catch (System.Data.SqlClient.SqlException sqlEx) { for (int i = 0; i < sqlEx.Errors.Count; i++) { LabelError.Text += (sqlEx.Errors[i].Message + "<br />"); } PanelError.Visible = true; } catch (Exception exception) { LabelError.Text += (exception.Message + "<br />"); PanelError.Visible = true; } }
protected void GridViewResult_RowDataBound(object sender, GridViewRowEventArgs e) { GridViewRow currentRow = e.Row; //if (currentRow.RowIndex > 0) if (currentRow.RowType == DataControlRowType.DataRow) { EmployeeToll employeeToll = (EmployeeToll)currentRow.DataItem; if (employeeToll.Attachment.Length == 0) { currentRow.Cells[6].ForeColor = System.Drawing.Color.White; currentRow.Cells[6].Text = "-"; currentRow.Cells[6].Enabled = false; } } }
protected void GridViewResult_RowCommand(object sender, GridViewCommandEventArgs e) { try { switch (e.CommandName.ToLower()) { case "removeemployeetoll": { EmployeeToll.DeleteEmployeeTollByEmployeeTollId(Convert.ToInt32(e.CommandArgument)); BindGridviewResult(); break; } case "viewattachment": { EmployeeToll employeeToll = EmployeeToll.GetEmployeeTollByEmployeeTollId(Convert.ToInt32(e.CommandArgument)); Response.Clear(); Response.ContentType = "image/jpg"; Response.AppendHeader("Content-Disposition", "attachment; filename=TollAttachment.jpg"); Response.TransmitFile(employeeToll.Attachment); Response.End(); break; } } } catch (System.Data.SqlClient.SqlException sqlEx) { LabelError.Text = ""; for (int i = 0; i < sqlEx.Errors.Count; i++) { LabelError.Text += (sqlEx.Errors[i].Message + "<br />"); } PanelError.Visible = true; } }
protected void ButtonSave_Click(object sender, EventArgs e) { if (Page.IsValid) { LabelError.Text = ""; PanelError.Visible = false; DateTime dateOfToll; bool isDate = DateTime.TryParse(TextBoxDateOfToll.Text, out dateOfToll); if (!isDate) { LabelError.Text += "Date Of Toll is required.<br />"; PanelError.Visible = true; return; } //EmployeeToll currentEmployeeToll = EmployeeToll.GetEmployeeTollByVehicleIdEmployeeId(Convert.ToInt32(DropDownListVehicle.SelectedValue), this.employeeId); //EmployeeVehicle employeeVehicle = new EmployeeVehicle(); //employeeVehicle.EmployeeVehicleId = currentEmployeeToll.EmployeeVehicleId;//Convert.ToInt32(ViewState["employeeVehicleId"]); //employeeVehicle.EmployeeId = this.employeeId; //employeeVehicle.VehicleId = Convert.ToInt32(DropDownListVehicle.SelectedValue); //employeeVehicle.ModifiedUser = this.Master.LoggedOnAccount; //employeeVehicle.Save(); //ViewState["employeeVehicleId"] = (employeeVehicle.EmployeeVehicleId != 0) ? employeeVehicle.EmployeeVehicleId : this.employeeVehicleId; EmployeeVehicle employeeVehicle = EmployeeVehicle.GetEmployeeVehicleByEmployeeIdVehicleId(this.employeeId, Convert.ToInt32(DropDownListVehicle.SelectedValue)); EmployeeToll employeeToll = new EmployeeToll(); employeeToll.EmployeeTollId = this.employeeTollId;//Convert.ToInt32(ViewState["employeeTollId"]); employeeToll.EmployeeVehicleId = employeeVehicle.EmployeeVehicleId; employeeToll.DateOfToll = Convert.ToDateTime(TextBoxDateOfToll.Text); employeeToll.PaymentTypeId = Convert.ToInt32(DropDownListPaymentType.SelectedValue); employeeToll.Value = Convert.ToDouble(TextBoxValue.Text); employeeToll.Description = TextBoxDescription.Text; employeeToll.ModifiedUser = this.Master.LoggedOnAccount; employeeToll.Attachment = UploadAttachment(); try { employeeToll.Save(); this.employeeTollId = employeeToll.EmployeeTollId; Button clickedButton = (Button)sender; switch (clickedButton.ID) { case "ButtonSave": Response.Redirect(String.Format("EmployeeEdit.aspx?employeeId={0}", this.employeeId)); break; case "ButtonSaveNew": Response.Redirect(String.Format("EmployeeTollEdit.aspx?employeeId={0}&vehicleId={1}", this.employeeId, Convert.ToInt32(DropDownListVehicle.SelectedValue))); //TextBoxValue.Text = ""; //TextBoxDescription.Text = ""; //TextBoxKMReading.Text = ""; //ViewState["employeeTollId"] = "0"; //ViewState["employeeVehicleId"] = "0"; //BindGridviewResult(); break; } } catch (System.Data.SqlClient.SqlException sqlEx) { LabelError.Text = ""; for (int i = 0; i < sqlEx.Errors.Count; i++) { LabelError.Text += (sqlEx.Errors[i].Message + "<br />"); } PanelError.Visible = true; } } }
private void BindGridviewResult() { GridViewResult.DataSource = EmployeeToll.GetEmployeeTollList(this.employeeId); GridViewResult.DataBind(); }