protected void ddllType_SelectedIndexChanged(object sender, EventArgs e) { DataTable dt = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZEMPLEAVETYPE WHERE EmpleaveCode = '" + ddllType.SelectedValue + "'", "A2ZHRMCUS"); if (dt.Rows.Count > 0) { lblEffectSalary.Text = Converter.GetString(dt.Rows[0]["EffectSalary"]); txtTotDay.Text = Converter.GetString(dt.Rows[0]["TotalDays"]); } A2ZCSPARAMETERDTO dto = A2ZCSPARAMETERDTO.GetParameterValue(); DateTime date = Converter.GetDateTime(dto.ProcessDate); int year = date.Year; lblprocYear.Text = Converter.GetString(year); int empcode = Converter.GetInteger(txtEmpNo.Text); int lyear = Converter.GetInteger(year); int lcode = Converter.GetInteger(ddllType.SelectedValue); A2ZEMPLEAVEBALANCEDTO getDTO = (A2ZEMPLEAVEBALANCEDTO.GetInformation(empcode, lyear, lcode)); if (getDTO.norecord > 0) { txtBalDay.Text = Converter.GetString(getDTO.LeaveBalDays); lblUsedDays.Text = Converter.GetString(getDTO.LeaveDays); } else { txtBalDay.Text = string.Empty; lblUsedDays.Text = string.Empty; } }
protected void UpdLeaveBalance() { A2ZEMPLEAVEBALANCEDTO objDto = new A2ZEMPLEAVEBALANCEDTO(); objDto.EmpCode = Converter.GetInteger(txtEmpNo.Text); objDto.LeaveYear = Converter.GetInteger(lblprocYear.Text); objDto.LeaveCode = Converter.GetInteger(ddllType.SelectedValue); objDto.LeaveDays = Converter.GetDecimal(lblUsedDays.Text); objDto.LeaveBalDays = Converter.GetDecimal(lblBalDays.Text); int result = A2ZEMPLEAVEBALANCEDTO.UpdateInformation(objDto); }