private void SaveData() { HR_CUTI_KUOTA_DAL _dalHR_CUTI_KUOTA_DAL = null; Hashtable _htParameters = null; int iNextID = 0; try { _dalHR_CUTI_KUOTA_DAL = new HR_CUTI_KUOTA_DAL(); _htParameters = new Hashtable(); MPF23.Shared.Mapper.UIToDB.Map(pnlBody.Controls, _htParameters); Utility.ApplyDefaultProp(_htParameters); if (Request.Params["action"] == "add") { _dalHR_CUTI_KUOTA_DAL.Insert(_htParameters, ref iNextID); } else { _dalHR_CUTI_KUOTA_DAL.Update(_htParameters); iNextID = Int32.Parse(lblID.Text); } Utility.ShowMessageBox(this, Utility.SAVE_DATA_SUCCESS_MESSAGE, null, "kuotacutidtl.aspx?action=edt&id=" + iNextID.ToString()); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.SAVE_DATA_FAIL_MESSAGE, ex, null); } }
protected void gvwList_RowCommand(object sender, GridViewCommandEventArgs e) { switch (e.CommandName) { case "Edit": Response.Redirect("kuotacutidtl.aspx?action=edt&id=" + e.CommandArgument); break; case "Delete": HR_CUTI_KUOTA_DAL _dalHR_CUTI_KUOTA_DAL = null; Hashtable _htParameters = null; try { _dalHR_CUTI_KUOTA_DAL = new HR_CUTI_KUOTA_DAL(); _htParameters = new Hashtable(); _htParameters["p_id"] = e.CommandArgument.ToString(); _dalHR_CUTI_KUOTA_DAL.Delete(_htParameters); this.BindGrid(); Response.Redirect("kuotacutilist.aspx"); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null); } break; } }
private void BindGridUpload() { HR_CUTI_KUOTA_DAL _dalHR_CUTI_KUOTA_DAL = null; Hashtable htParameters = null; try { _dalHR_CUTI_KUOTA_DAL = new HR_CUTI_KUOTA_DAL(); htParameters = new Hashtable(); htParameters["p_keywords"] = txtSearchListUpload.Text; gvwListUpload.DataSource = _dalHR_CUTI_KUOTA_DAL.GetRowsTempBalanceGrid(htParameters); gvwListUpload.DataBind(); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null); } }
private void BindGrid() { HR_CUTI_KUOTA_DAL _dalHR_CUTI_KUOTA_DAL = null; Hashtable _htParameters = null; try { _dalHR_CUTI_KUOTA_DAL = new HR_CUTI_KUOTA_DAL(); _htParameters = new Hashtable(); _htParameters["p_keywords"] = txtSearch.Text; _htParameters["p_STATUS"] = ddlStatus.SelectedValue; if (Session[SessionKey.CURRENT_USER_HRMS_ROLE].ToString() == "1") { _htParameters["p_NIK"] = Session[SessionKey.CURRENT_USER_HRMS_EMP_CODE].ToString(); btnImport.Visible = false; } else { btnImport.Visible = true; } gvwList.DataSource = _dalHR_CUTI_KUOTA_DAL.GetRows(_htParameters); gvwList.DataBind(); string abc = Session[SessionKey.CURRENT_USER_HRMS_ROLE].ToString(); if (gvwList.Rows.Count > 0) { if (Session[SessionKey.CURRENT_USER_HRMS_ROLE].ToString() == "1") { gvwList.Columns[gvwList.Rows[0].Cells.Count - 1].Visible = false; gvwList.Columns[gvwList.Rows[0].Cells.Count - 2].Visible = false; } else { gvwList.Columns[gvwList.Rows[0].Cells.Count - 1].Visible = true; gvwList.Columns[gvwList.Rows[0].Cells.Count - 2].Visible = true; } } } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null); } }
protected void btnProcess_Click(object sender, EventArgs e) { HR_CUTI_KUOTA_DAL _dalHR_CUTI_KUOTA_DAL = null; Hashtable htParameters = null; try { _dalHR_CUTI_KUOTA_DAL = new HR_CUTI_KUOTA_DAL(); htParameters = new Hashtable(); htParameters["p_user_id"] = Session[SessionKey.CURRENT_USER_SESSION_KEY].ToString().Trim(); Utility.ApplyDefaultProp(htParameters); _dalHR_CUTI_KUOTA_DAL.TempBalanceUploadProcess(htParameters); BindGridUpload(); Utility.ShowMessageBox(this, Utility.SAVE_DATA_SUCCESS_MESSAGE, null, null, null); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.SAVE_DATA_FAIL_MESSAGE, ex, null, null); } }
private void LoadData() { HR_CUTI_KUOTA_DAL _dalHR_CUTI_KUOTA_DAL = null; Hashtable _htParameters = null; try { //System.Diagnostics.Debugger.Break(); _dalHR_CUTI_KUOTA_DAL = new HR_CUTI_KUOTA_DAL(); _htParameters = new Hashtable(); _htParameters["p_id"] = Request.Params["id"]; DataTable _dt = _dalHR_CUTI_KUOTA_DAL.GetRow(_htParameters); MPF23.Shared.Mapper.DBToUI.Map(pnlBody.Controls, _dt.Rows[0]); //imgBtnLookUpKaryawan.Enabled = false; } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null); } }
//asfor Karyawan private void BindGridPopUpKaryawan() { HR_CUTI_KUOTA_DAL _dalHR_CUTI_KUOTA_DAL = null; Hashtable _htParameters = null; try { _dalHR_CUTI_KUOTA_DAL = new HR_CUTI_KUOTA_DAL(); _htParameters = new Hashtable(); _htParameters["p_keywords"] = txtSearchKaryawan.Text; _htParameters["p_status"] = "1"; if (Session[SessionKey.CURRENT_USER_HRMS_ROLE].ToString() == "1") { _htParameters["p_NIK"] = Session[SessionKey.CURRENT_USER_HRMS_EMP_CODE].ToString(); } gvwListKaryawan.DataSource = _dalHR_CUTI_KUOTA_DAL.GetRowsBalanceByEmployee(_htParameters); gvwListKaryawan.DataBind(); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null); } }
protected void btnDownloadTemplate_OnClick(object sender, EventArgs e) { HR_CUTI_KUOTA_DAL _dalHR_CUTI_KUOTA_DAL = null; Hashtable _htParameters = null; try { _dalHR_CUTI_KUOTA_DAL = new HR_CUTI_KUOTA_DAL(); _htParameters = new Hashtable(); string empcode = Session[SessionKey.CURRENT_USER_HRMS_EMP_CODE].ToString().Trim(); _htParameters["p_START_DATE"] = Utility.ToDateTime(txtStartDate.Text); _htParameters["p_END_DATE"] = Utility.ToDateTime(txtEndDate.Text); var dt = _dalHR_CUTI_KUOTA_DAL.GetRowsTempBalanceDataExcel(_htParameters); if (dt.Rows.Count <= 0) { throw new Exception("No data found for date " + txtStartDate.Text + " to date " + txtEndDate.Text); } var filename = "kuota_cuti_pegawai_" + empcode + "_" + Utility.ToDateTime(txtStartDate.Text).ToString("yyyyMMdd"); var filepath = Server.MapPath(@"~\temp\xls\" + filename); var columns = new string[dt.Columns.Count]; var rows = new string[dt.Rows.Count]; var i = 0; foreach (DataColumn col in dt.Columns) { columns[i] = col.ColumnName; i++; } var builder = new StringBuilder(); builder.Append(string.Join(",", columns.ToArray())).Append("\n"); i = 0; foreach (DataRow dr in dt.Rows) { var currentRow = new string[dt.Columns.Count]; var j = 0; foreach (DataColumn col in dt.Columns) { object item = dr[col]; currentRow[j] = (item.ToString()); j++; } rows[i] = string.Join(",", currentRow.ToArray()); i++; } builder.Append(string.Join("\n", rows.ToArray())); Response.Clear(); Response.ContentType = "text/csv"; Response.AddHeader("Content-Disposition", "attachment;filename=" + filename + ".csv"); Response.Write(builder.ToString()); Response.End(); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null); } }
protected void btnUpload_Click(object sender, EventArgs e) { var valid = true; if (!FileUploadControl.HasFile) { return; } var filename = FileUploadControl.FileName; var s = filename.Split('.'); var extension = s[s.Length - 1]; var saveAsFileName = "UploadKuotaCutiPegawai_" + DateTime.Now.ToString("yyyyMMddhhmmss") + "." + extension; var contenttype = FileUploadControl.PostedFile.ContentType; var log = ""; try { if (contenttype == "application/octet-stream" || contenttype == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" || contenttype == "application/vnd.ms-excel" || contenttype == "text/csv") { FileUploadControl.SaveAs(Server.MapPath(@"../../temp/xls/") + saveAsFileName); log += "Upload file " + filename + " success.\t" + DateTime.Now.ToString(CultureInfo.InvariantCulture) + "\n\r"; var uploadedPath = Server.MapPath(@"../../temp/xls/") + saveAsFileName; var ctr = 0; var parser = new Microsoft.VisualBasic.FileIO.TextFieldParser(uploadedPath); parser.TextFieldType = Microsoft.VisualBasic.FileIO.FieldType.Delimited; parser.SetDelimiters(new string[] { "," }); while (!parser.EndOfData) { string[] row = parser.ReadFields(); if (ctr == 0) { ctr = 1; } else { if (row != null) { var employee_code = row[0]; var employee_name = row[1]; var start_date = row[4]; var end_date = row[5]; var Quota = row[6]; if (employee_code != "NIK") { try { //InsertXlsRowData(row); HR_CUTI_KUOTA_DAL _dalHR_CUTI_KUOTA_DAL = null; Hashtable htParameters = null; _dalHR_CUTI_KUOTA_DAL = new HR_CUTI_KUOTA_DAL(); htParameters = new Hashtable(); var iNextId = 0; htParameters.Clear(); htParameters["p_NIK"] = employee_code; htParameters["p_START_DATE"] = Utility.ToDateTime(start_date); htParameters["p_END_DATE"] = Utility.ToDateTime(end_date); htParameters["p_Quota"] = Quota; Utility.ApplyDefaultProp(htParameters); _dalHR_CUTI_KUOTA_DAL.InsertTempBalance(htParameters, ref iNextId); log += "Insert Data : " + employee_code + " - " + employee_name + " Success.\t" + DateTime.Now.ToString(CultureInfo.InvariantCulture) + "\n\r"; } catch (Exception exc) { log += "Insert Data : " + employee_code + " - " + employee_name + " Failed.\t" + exc.InnerException.Message + "\t" + DateTime.Now.ToString(CultureInfo.InvariantCulture) + "\n\r"; valid = false; // Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null); } } } } } Utility.ShowMessageBox(this, valid ? "Upload Success" : "Upload Success but error in processing data. Check Log for detail info.", null, "kuotacutiimport.aspx"); //BindGridUpload(); } else { Utility.ShowMessageBox(this, "Error Excel Format", null, null); } } catch (Exception ex) { Utility.ShowMessageBox(this, "Upload Failed.", ex, null); } CreateLog(log); }