private void getImage()
{
DataTable dtImage = new DataTable();
dtImage = getImageString();
int i = 0;
foreach (DataRow row in dtImage.Rows)
{
i = i + 1;
try
{
byte[] bytes = Convert.FromBase64String(row["image_string"].ToString());
using (MemoryStream ms = new MemoryStream(bytes))
{
Bitmap bm = new Bitmap(Image.FromStream(ms));
float source_aspect = bm.Width / (float)bm.Height;
AddImageToImageList(listImage,
bm, i.ToString(),
listImage.ImageSize.Width,
listImage.ImageSize.Height);
}
listViewImage.AddRow(i.ToString(), row["upload_date"].ToString()); // Year
}
catch (Exception ex)
{
MsgBoxUtil.MsgError(ex.Message.ToString());
}
listViewImage.View = View.LargeIcon;
}
}
public static void SetDataTableRightOnMenu(string cUser, string cAppsID, string cOwner)
{
var objComm = new SqlCommand();
var objDS = new DataSet();
var objDT = new DataTable();
var objDA = new SqlDataAdapter();
try
{
objComm.Connection = clMain.DBConn.objConnection;
objDS = clMain.DBConn.SetDataTableRightOnMenu(cUser, cAppsID, cOwner, ref objComm);
objDA.SelectCommand = objComm;
objDA.Fill(objDS);
objDT = objDS.Tables[0];
clMain.dtAccess = objDT;
}
catch (Exception ex)
{
MsgBoxUtil.MsgError(ex.Message);
}
finally
{
objComm.Dispose();
objDS.Dispose();
objDA.Dispose();
objDT.Dispose();
}
}
private void txtNoReg_Validated(object sender, EventArgs e)
{
try
{
this.TxtNoSEP.Text = "";
if (txtNoReg.Text != "")
{
ClearVariable(false);
this.Cursor = Cursors.WaitCursor;
this.lblKondisiP.Text = "W A I T I N G . . . ";
this.Refresh();
CariPasien(this.txtNoReg.Text);
// this.TxtNoSEP.Text =ClsUtil.GetSettings("vc_no_regj", "vc_no_sep", "bpjs_sep", this.txtNoReg.Text, "");
this.TxtNoSEP.Text = ClsUtil.GetSetting("bpjs_sep", "vc_no_sep", "vc_no_regj", this.txtNoReg.Text);
}
else
{
ClearVariable(true);
}
SettingMenu();
vTglHariIni = clMain.DBConn.GetCurrentDate();
this.Cursor = Cursors.Default;
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
MsgBoxUtil.MsgError("Proses Gagal, Informasi Tidak Dapat Ditampilkan!!" + Constants.vbCrLf + " Silakan Mengulang Pengisian No.Register.. " + Constants.vbCrLf + ex.Message);
ClearVariable(false);
}
}
private void TampilDataGrid(string xStrSQL)
{
DataView ObjDataView;
var ObjDataAdapter = new SqlDataAdapter(xStrSQL, clMain.DBConn.objConnection);
var ObjDataSet = new DataSet();
try
{
lstItem.Columns.Clear();
ObjDataAdapter.Fill(ObjDataSet, "TbAkun");
ObjDataView = new DataView(ObjDataSet.Tables["TbAkun"]);
this.lstItem.DataSource = ObjDataView;
ObjDataAdapter.Dispose();
ObjDataSet.Dispose();
}
catch (Exception ex)
{
MsgBoxUtil.MsgError(ex.Message);
}
finally
{
ObjDataAdapter = default;
ObjDataSet = default;
}
}
private void updateLocation()
{
try
{
string query = @"
UPDATE [dbo].[MST_Location]
SET [Location_Name] =@location_name
,[Lattitude] = @lattitude
,[Longitude] = @longitude
,[Radius] = @radius
,[Location_Desc] = @location_desc
,[is_active] = @is_acitve
WHERE location_id = @location_id";
using (SqlCommand cmd = new SqlCommand(query, ConnUtil.connection))
{
cmd.Parameters.AddWithValue("@location_name", txtLocationName.Text);
cmd.Parameters.AddWithValue("@lattitude", txtLatitude.DoubleValue);
cmd.Parameters.AddWithValue("@longitude", txtLongitude.DoubleValue);
cmd.Parameters.AddWithValue("@Radius", txtRadius.IntegerValue);
cmd.Parameters.AddWithValue("@location_desc", txtLocationDesc.Text);
cmd.Parameters.AddWithValue("@is_acitve", chkBoxActive.Checked);
cmd.Parameters.AddWithValue("@location_id", loc_id);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
MsgBoxUtil.MsgSuccessSave();
}
}
catch (Exception ex)
{
MsgBoxUtil.MsgError(ex.Message);
}
}
private void btnLoad_Click(object sender, EventArgs e)
{
if (cmbJenisPel.Text.Equals(""))
{
MsgBoxUtil.MsgError("Jenis Pelayanan Belum Dipilih");
return;
}
getData();
}
private void insertPEA()
{
DateTime now = ClsUtil.getCurrentDate();
var password = EncodeDecode.Encrypt(txtPassword.Text);
var unitId = cmbUnit.SelectedValue;
var positionId = cmbPosition.SelectedValue;
var gender = cmbGender.Text;
try
{
string query = @"
INSERT INTO [dbo].[Employees]
([Employee_Number]
,[Employee_Name]
,[Gender]
,[Hire_Date]
,[Birth_Date]
,[Unit_Id]
,[Position_id]
,[created_date]
,[created_by]
,[Password])
VALUES
(@Employee_Number
,@Employee_Name
,@Gender
,@Hire_Date
,@Birth_Date
,@Unit_Id
,@Position_id
,@created_date
,@created_by
,@Password)";
using (SqlCommand cmd = new SqlCommand(query, ConnUtil.connection))
{
cmd.Parameters.AddWithValue("@Employee_Number", txtEmployeeNumber.IntegerValue);
cmd.Parameters.AddWithValue("@Employee_Name", txtEmployeeName.Text);
cmd.Parameters.AddWithValue("@Gender", gender);
cmd.Parameters.AddWithValue("@Hire_Date", dtHireDate.Value.ToShortDateString());
cmd.Parameters.AddWithValue("@Birth_Date", dtBirthDate.Value.ToShortDateString());
cmd.Parameters.AddWithValue("@Unit_Id", unitId);
cmd.Parameters.AddWithValue("@Position_id", positionId);
cmd.Parameters.AddWithValue("@created_date", ClsUtil.currentDateTime);
cmd.Parameters.AddWithValue("@created_by", ClsUtil.userLogin);
cmd.Parameters.AddWithValue("@Password", password);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
MsgBoxUtil.MsgSuccessSave();
}
}
catch (Exception ex)
{
MsgBoxUtil.MsgError(ex.Message);
}
}
private void ShowData()
{
byte I;
string vStrSQL;
try
{
switch (this.m_frmSender)
{
case "frmTrsJurnalUmum":
{
vStrSQL = this.strSQL + " AND (DT_TGLJURNAL BETWEEN '" + ClsUtil.TglYMD(this.txtTglAwal.Text) + "' AND '" + ClsUtil.TglYMD(this.txtTglAkhir.Text) + "') " + " ORDER BY DT_TGLJURNAL, VC_NO_JURNAL";
break;
}
case "frmDaftarOperasi":
{
vStrSQL = this.strSQL + " AND (Convert(varchar(10),dt_tgl_trans,20) BETWEEN '" + ClsUtil.TglYMD(this.txtTglAwal.Text) + "' AND '" + ClsUtil.TglYMD(this.txtTglAkhir.Text) + "') " + " ORDER BY vc_no_trans ";
break;
}
case "frmTrsBiayaLain":
{
vStrSQL = this.strSQL + " AND (Convert(varchar(10),dt_tgl_trans,20) BETWEEN '" + ClsUtil.TglYMD(this.txtTglAwal.Text) + "' AND '" + ClsUtil.TglYMD(this.txtTglAkhir.Text) + "') " + " ORDER BY vc_no_bukti ";
break;
}
default:
{
vStrSQL = this.strSQL;
break;
}
}
this.TampilDataGrid(vStrSQL);
var loopTo = (byte)Information.UBound(m_colName);
for (I = 0; I < loopTo; I++)
{
if (m_colName[I] != "")
{
this.lstItem.Columns[I].HeaderText = m_colName[I];
}
}
}
catch (Exception ex)
{
MsgBoxUtil.MsgError(ex.Message);
}
}
private void getImage()
{
ImageList imageList = new ImageList();
this.imageListView.Items.Clear();
DataTable dtImage = new DataTable();
dtImage = getImageString();
int i = 0;
foreach (DataRow row in dtImage.Rows)
{
i = i + 1;
try
{
byte[] bytes = Convert.FromBase64String(row["image_string"].ToString());
using (MemoryStream ms = new MemoryStream(bytes))
{
Bitmap bm = new Bitmap(Image.FromStream(ms));
float source_aspect = bm.Width / (float)bm.Height;
AddImageToImageList(imageList, bm, i.ToString(), 64, 64);
// imageList.Images.Add(bm);
}
}
catch (Exception ex)
{
MsgBoxUtil.MsgError(ex.Message.ToString());
}
}
imageList.ImageSize = new Size(256, 256);
this.imageListView.View = View.LargeIcon;
for (int counter = 0; counter < imageList.Images.Count; counter++)
{
ListViewItem item = new ListViewItem();
item.ImageIndex = counter;
this.imageListView.Items.Add(item);
}
this.imageListView.LargeImageList = imageList;
}
private void btnLoad_Click(object sender, EventArgs e)
{
if (cmbJenisPel.Text.Equals(""))
{
MsgBoxUtil.MsgError("Jenis Pelayanan Belum Dipilih");
return;
}
genarateData();
pivotGridControl1.TableModel.Refresh();
pivotGridControl1.Refresh();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (dt.Rows.Count == 0)
{
MsgBoxUtil.MsgError("Tidak Ada Data Yang Disimpan!!!");
}
else
{
try
{
//foreach (DataRow row in dt.Rows)
//{
// //delete data lama dlu jika ada
// var sep = row["sep"].ToString();
// string SQLText = "DELETE INACBG_RAW_DATA where sep = '" + sep + "'";
// clMain.DBConn.GeneralCommand(SQLText, ref xcmd);
// xcmd.ExecuteNonQuery();
//}
//sqlTrans.Commit();
//sqlTrans.Dispose();
//sqlTrans = null;
deleteTempData();
BulkInsertDataTable("INACBG_RAW_DATA_TEMP", dt);
deleteSEPOld();
bool result = BulkInsertDataTable("INACBG_RAW_DATA", dt);
if (result)
{
MsgBoxUtil.MsgInfo("Save Data Berhasil");
}
else
{
MsgBoxUtil.MsgInfo("Data Gagal Disimpan");
}
}
catch (Exception ex)
{
MsgBoxUtil.MsgError(ex.Message);
sqlTrans.Rollback();
sqlTrans.Dispose();
}
}
}
private void FrmMain_Load(object sender, EventArgs e)
{
clMain.ReadValuesINIFiles();
long openCOnnection = clMain.DBConn.DBOpenConnection();
if (openCOnnection != 0)
{
MsgBoxUtil.MsgError("Gagal Akses Database");
this.Close();
}
clMain.gKdTaripKamar = GetKdTaripKamar();
ClsUtil.SetDataTableRightOnMenu(clMain.cUserLogIn, clMain.cIDApps, clMain.cIDModul);
// ClsUtil.SetDataTableRightOnMenu("wendra", "0202", "2201");
// SetMenuAccess();
kdJKN = ClsUtil.GetSetting("Keu_piut_lookup", "vc_value", "vc_code", "KodeJKN");
}
private void updatePEA()
{
var password = EncodeDecode.Encrypt(txtPassword.Text);
var unitId = cmbUnit.SelectedValue;
var positionId = cmbPosition.SelectedValue;
var gender = cmbGender.Text;
var dateTimeNow = ClsUtil.getCurrentDate();
try
{
string query = @"
UPDATE [dbo].[Employees]
SET [Employee_Number] =@Employee_Number
,[Employee_Name] = @Employee_Name
,[Gender] = @Gender
,[Hire_Date] =@Hire_Date
,[Birth_Date] =@Birth_Date
,[Unit_Id] = @Unit_Id
,[Position_id] = @Position_id
,[Password] = @Password
,[updated_date] = @updated_date
,[updated_by] = @updated_by
WHERE Employee_id = @emp_id ";
using (SqlCommand cmd = new SqlCommand(query, ConnUtil.connection))
{
cmd.Parameters.AddWithValue("@Employee_Number", txtEmployeeNumber.IntegerValue);
cmd.Parameters.AddWithValue("@Employee_Name", txtEmployeeName.Text);
cmd.Parameters.AddWithValue("@Gender", gender);
cmd.Parameters.AddWithValue("@Hire_Date", dtHireDate.Value.ToShortDateString());
cmd.Parameters.AddWithValue("@Birth_Date", dtBirthDate.Value.ToShortDateString());
cmd.Parameters.AddWithValue("@Unit_Id", unitId);
cmd.Parameters.AddWithValue("@Position_id", positionId);
cmd.Parameters.AddWithValue("@Password", password);
cmd.Parameters.AddWithValue("@updated_date", ClsUtil.currentDateTime);
cmd.Parameters.AddWithValue("@updated_by", ClsUtil.userLogin);
cmd.Parameters.AddWithValue("@emp_id", empId);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
MsgBoxUtil.MsgSuccessSave();
}
}
catch (Exception ex)
{
MsgBoxUtil.MsgError(ex.Message);
}
}
public bool BulkInsertDataTable(string tableName, DataTable dataTable)
{
bool isSuccuss;
try
{
SqlBulkCopy bulkCopy = new SqlBulkCopy(clMain.DBConn.objConnection, SqlBulkCopyOptions.TableLock | SqlBulkCopyOptions.FireTriggers | SqlBulkCopyOptions.UseInternalTransaction, null);
bulkCopy.DestinationTableName = tableName;
bulkCopy.WriteToServer(dataTable);
isSuccuss = true;
}
catch (Exception ex)
{
isSuccuss = false;
MsgBoxUtil.MsgError(ex.Message);
}
return(isSuccuss);
}
private void saveImageToFolder(string folderName)
{
try
{
string folder = folderName + "/" + dtPeriod.Value.ToString("dd-MMM-yyyy");
DataTable dtPhoto = getImageString();
if (dtPhoto.Rows.Count > 0)
{
string employee_number_temp = "";
int photoSeq = 0;
if (Directory.Exists(folder))
{
clearFolder(folder);
}
foreach (DataRow row in dtPhoto.Rows)
{
photoSeq = photoSeq + 1;
string employee_name_number = row["employee_number"] + "_" + row["employee_name"];
string folderfinal = folder + "/" + employee_name_number;
if (!Directory.Exists(folderfinal))
{
Directory.CreateDirectory(folderfinal);
}
string filepath = folderfinal + "/" + row["employee_number"] + "_" + photoSeq.ToString() + ".jpeg";
var bytess = Convert.FromBase64String(row["image_string"].ToString());
using (var imageFile = new FileStream(filepath, FileMode.Create))
{
imageFile.Write(bytess, 0, bytess.Length);
imageFile.Flush();
}
employee_number_temp = row["employee_number"].ToString();
}
}
}
catch (Exception ex)
{
MsgBoxUtil.MsgError(ex.Message.ToString());
}
}
private void ImportExcelFile()
{
try
{
string strFileName = ""; OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Excel Files|*.xls;*.xlsx";
// openFileDialog.DefaultExt = ".xls";
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
dgPiutang.DataSource = null;
strFileName = openFileDialog.FileName;
txtFileName.Text = strFileName;
#region Get Correct Worksheet in excel file
DateTime dtStart = DateTime.Now;
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
IWorkbook workbook = application.Workbooks.Open(strFileName);
IWorksheet sheet = workbook.Worksheets[0];
#endregion
dt.Clear();
dt = sheet.ExportDataTable(sheet.UsedRange, ExcelExportDataTableOptions.ColumnNames);
//Close the workbook.
workbook.Close();
//No exception will be thrown if there are unsaved workbooks.
excelEngine.ThrowNotSavedOnDestroy = false;
excelEngine.Dispose();
dgPiutang.DataSource = dt;
dgPiutang.AutoSizeColumnsMode = AutoSizeColumnsMode.AllCells;
}
}
catch (Exception err)
{
MsgBoxUtil.MsgError(err.Message.ToString());
}
}
private void insertLocation()
{
try
{
string query = @"INSERT INTO [dbo].[MST_Location]
([Location_Name]
,[Lattitude]
,[Longitude]
,[Radius]
,[Location_Desc]
,[is_active])
VALUES
(@location_name
, @latitude
, @longitude
, @radius
, @location_desc
, @is_acitve)";
using (SqlCommand cmd = new SqlCommand(query, ConnUtil.connection))
{
cmd.Parameters.AddWithValue("@location_name", txtLocationName.Text);
cmd.Parameters.AddWithValue("@latitude", txtLatitude.DoubleValue);
cmd.Parameters.AddWithValue("@longitude", txtLongitude.DoubleValue);
cmd.Parameters.AddWithValue("@Radius", txtRadius.IntegerValue);
cmd.Parameters.AddWithValue("@Location_Desc", txtLocationDesc.Text);
cmd.Parameters.AddWithValue("@is_acitve", true);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
MsgBoxUtil.MsgSuccessSave();
}
}
catch (Exception ex)
{
MsgBoxUtil.MsgError(ex.Message);
}
}
