private void btnSave_Click(object sender, EventArgs e)
{
if (!CheckEntries())
{
return;
}
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtBranch = cnn.GetDataTable("select nvl(max(swid),0)+1 from DEPARTEMENTS");
txtSWID.Text = dtBranch.Rows[0][0].ToString();
glb_function.arrInsertLogs = new System.Collections.ArrayList();
glb_function.arrInsertLogs.Add
("insert into DEPARTEMENTS values(" + txtSWID.Text +
" ,sysdate,'ACTIVE'," + glb_function.glb_strUserId + "" +
"," + nmbDept_No.Value.ToString() + ", '" + txtDept_ANAME.Text + "','" + txtDept_ENAME.Text + "'" +
", '" + txtDept_AADDRESS.Text + "','" + txtDept_EADDRESS.Text + "'" +
",'" + txtDept_TEL.Text + "','" + txtDept_FAX.Text + "'" +
",'" + txtDept_EMAIL.Text + "'" +
"," + (lstBRANCH_Id.SelectedValue == null ? "null" : lstBRANCH_Id.SelectedValue.ToString()) + "" +
" )");
if (glb_function.MultiTransData())
{
GetData(txtSWID.Text.Trim());
}
}
private void GetData(string strSwid)
{
btnNew_Click(null, null);
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtWareHouse = cnn.GetDataTable("select * from EXPENSES_ITEM where swid=" + strSwid);
txtEXPENSES_ItemSwid.Text = strSwid;
txtEXPENSES_NAME.Text = dtWareHouse.Rows[0]["EXPENSES_NAME"].ToString();
txtEXPENSES_NAME.W_OldValue = dtWareHouse.Rows[0]["EXPENSES_NAME"].ToString();
lstEXPENSES_TYPE.Text = dtWareHouse.Rows[0]["EXPENSES_TYPE"].ToString();
lstEXPENSES_TYPE.W_OldValue = dtWareHouse.Rows[0]["EXPENSES_TYPE"].ToString();
lstEXPENSESVALUE_OR_SIZE.Text = dtWareHouse.Rows[0]["EXPENSESVALUE_OR_SIZE"].ToString();
lstEXPENSESVALUE_OR_SIZE.W_OldValue = dtWareHouse.Rows[0]["EXPENSESVALUE_OR_SIZE"].ToString();
lstAccNo.SelectedValue = dtWareHouse.Rows[0]["ACC_ID"].ToString().Trim();
lstAccNo.W_OldValue = (dtWareHouse.Rows[0]["ACC_ID"].ToString());
btnSave.Visible = false;
btnNew.Location = btnSave.Location;
btnNew.Visible = true;
if (HasPrivilege("btnUpdate"))
{
btnUpdate.Enabled = true;
}
}
private void GetAgreementData(string strSwid)
{
btnNewTermExp_Click(null, null);
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtTermsExp = cnn.GetDataTable("select TERMS_NAME,TERMS_CODE from TERMS_EXPENSES_HEADER where swid=" + strSwid);
txtTermExpSwid.Text = strSwid;
txtTERMS_NAME.Text = dtTermsExp.Rows[0]["TERMS_NAME"].ToString();
txtTERMS_NAME.W_OldValue = dtTermsExp.Rows[0]["TERMS_NAME"].ToString();
txtTERMS_COD.Text = dtTermsExp.Rows[0]["TERMS_CODE"].ToString();
txtTERMS_COD.W_OldValue = dtTermsExp.Rows[0]["TERMS_CODE"].ToString();
dtTermsExp.Clear();
FillExpAgreement(txtTermExpSwid.Text);
btnSaveTermExp.Visible = false;
btnNewTermExp.Location = btnSaveTermExp.Location;
btnNewTermExp.Visible = true;
if (HasPrivilege("btnUpdateTermExp"))
{
btnUpdateTermExp.Enabled = true;
}
}
private void GetData(string strPk)
{
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtLocation = cnn.GetDataTable("select * from BRANCHES where swid=" + strPk);
nmbBRANCH_NO.Text = dtLocation.Rows[0]["BRANCH_No"].ToString();
nmbBRANCH_NO.W_OldValue = dtLocation.Rows[0]["BRANCH_No"].ToString();
txtBRANCH_ANAME.Text = dtLocation.Rows[0]["BRANCH_ANAME"].ToString();
txtBRANCH_ANAME.W_OldValue = dtLocation.Rows[0]["BRANCH_ANAME"].ToString();
txtBRANCH_ENAME.Text = dtLocation.Rows[0]["BRANCH_ENAME"].ToString();
txtBRANCH_ENAME.W_OldValue = dtLocation.Rows[0]["BRANCH_ENAME"].ToString();
lstBRANCH_LOCATION.SelectedValue = (dtLocation.Rows[0]["branche_location"].ToString().Trim() == "" ? -1 : Convert.ToInt16(dtLocation.Rows[0]["branche_location"].ToString()));
lstBRANCH_LOCATION.W_OldValue = (dtLocation.Rows[0]["branche_location"].ToString());
btnSave.Visible = false;
btnNew.Location = btnSave.Location;
btnNew.Visible = true;
if (HasPrivilege("btnUpdate"))
{
btnUpdate.Enabled = true;
}
}
private void GetVendorData(string strVendorId)
{
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtVendor = cnn.GetDataTable("select p_name from people where swid=" + strVendorId);
txtSUPPLIER_Name.Text = dtVendor.Rows[0]["p_name"].ToString();
}
private void GetJournalHeaderData()
{
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtJourHeader = cnn.GetDataTable("select swid, to_char(created_date,'dd/mm/yyyy') created_date," +
" created_user, stat, " +
" jour_num, voch_type, " +
" voch_no, voch_no_m, " +
" to_char(jour_date,'dd/mm/yyyy') jour_date, jour_details, " +
" branch_no, model_no, " +
" jour_value,(select FORM_NAME from TEMPLET_HEADER where swid=h.MODEL_NO) Model_name," +
" (select BRANCH_ANAME from branches where swid=h.BRANCH_NO) BranchName," +
" (select user_name from userinfo where swid=h.Created_User) UserName" +
" from journal_header h where swid= " + dgJourHeader [1, dgJourHeader.CurrentRow.Index].Value.ToString());
txtJOUR_NUM.Text = dtJourHeader.Rows[0]["jour_num"].ToString();
txtVOCH_TYPE.Text = dtJourHeader.Rows[0]["VOCH_TYPE"].ToString();
txtVOCH_NO.Text = dtJourHeader.Rows[0]["voch_no"].ToString();
dtpJOUR_DATE.Value = glb_function.StringToDate(dtJourHeader.Rows[0]["JOUR_DATE"].ToString());
txtVOCH_NO_M.Text = dtJourHeader.Rows[0]["voch_no_m"].ToString();
txtMODEL_NO.Text = dtJourHeader.Rows[0]["Model_name"].ToString();
txtBranchName.Text = dtJourHeader.Rows[0]["BranchName"].ToString();
txtStat.Text = dtJourHeader.Rows[0]["stat"].ToString();
dtpCREATED_DATE.Value = glb_function.StringToDate(dtJourHeader.Rows[0]["CREATED_DATE"].ToString());
txtCreated_User.Text = dtJourHeader.Rows[0]["UserName"].ToString();
txtJOUR_DETAILS_Header.Text = dtJourHeader.Rows[0]["jour_details"].ToString();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (!CheckEntries())
{
return;
}
DataTable dtTemplte = new DataTable();
ConnectionToDB cnn = new ConnectionToDB();
glb_function.arrInsertLogs = new System.Collections.ArrayList();
glb_function.arrInsertLogs.Add("update FORMS set AR_NAME='" + txtAR_NAME.Text + "',EN_NAME='" + txtEN_NAME.Text + "',FORM_TYPE='" + lstFORM_TYPE.Text + "',SUB_FORM='" + lstSUB_FORM.Text + "',MULTI_FORM_FOR_USER='******' where swid=" + txtSWID.Text);
int strProSwid = 0;
dtTemplte.Clear();
dtTemplte = cnn.GetDataTable("select nvl(max(swid),0)+1 from FORM_PROPERITY");
strProSwid = Convert.ToInt16(dtTemplte.Rows[0][0].ToString());
for (int i = 0; i < dgvProperities.Rows.Count; i++)
{
if (dgvProperities[0, i].Value.ToString() == "")
{
glb_function.arrInsertLogs.Add("insert into FORM_PROPERITY values(" + strProSwid.ToString() + "," + txtSWID.Text + ",'" + dgvProperities[1, i].Value.ToString() + "','" + dgvProperities[3, i].Value.ToString() + "','" + dgvProperities[2, i].Value.ToString() + "'," + dgvProperities[5, i].Value.ToString() + ",'" + dgvProperities[7, i].Value.ToString() + "','" + dgvProperities[4, i].Value.ToString() + "')");
strProSwid++;
}
}
if (glb_function.MultiTransData())
{
GetData(txtSWID.Text.Trim());
}
}
private void GetProperitiesData()
{
dgvProperities.Items.Clear();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtPorp = cnn.GetDataTable("select pkid, control_type, en_name, ar_name, " +
" list_id, (select l.list_name from HR_list_type l where l.pkid = list_id) listtype, " +
" free_list_name, properity_note " +
" from HR_forms_de " +
" where header_id = " + txtSwid.Text);
clsGrid newRow;
for (int i = 0; i < dtPorp.Rows.Count; i++)
{
newRow = new clsGrid();
newRow.clmSwid = dtPorp.Rows[i]["pkid"].ToString();
newRow.clmFieldType = dtPorp.Rows[i]["control_type"].ToString();
newRow.clmFieldNameEn = dtPorp.Rows[i]["en_name"].ToString();
newRow.clmFieldNameAr = dtPorp.Rows[i]["ar_name"].ToString();
newRow.clmNote = dtPorp.Rows[i]["properity_note"].ToString();
newRow.clmListTypeId = dtPorp.Rows[i]["list_id"].ToString();
newRow.clmListType = dtPorp.Rows[i]["listtype"].ToString();
newRow.clmFreeList = dtPorp.Rows[i]["free_list_name"].ToString();
dgvProperities.Items.Add(newRow);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!CheckEntries())
{
return;
}
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtSwid = cnn.GetDataTable("select nvl(max(swid),0)+1 from STANDARD_UNIT");
txtSWID.Text = dtSwid.Rows[0][0].ToString();
int icheck = cnn.TranDataToDB("insert into STANDARD_UNIT values(" + txtSWID.Text + ",'" + lstUNIT_NAME.Text + "')");
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء العملية.");
return;
}
cnn.glb_commitTransaction();
glb_function.MsgBox("تمت العملية بنجاح");
string strSwid = txtSWID.Text.Trim();
FillUnits();
GetData(strSwid);
}
private void btnSearch_Click(object sender, EventArgs e)
{
dgvExpensses.Rows.Clear();
ConnectionToDB cnn = new ConnectionToDB();
if (txtRequestNo.Text.Trim() != "")
{
strWhere = strWhere + " and request_number = " + txtRequestNo.Text + "";
}
strWhere = strWhere + " and p_name like '%" + txtVendorName.Text + "%'";
DataTable dtLocationData = cnn.GetDataTable("select h.swid,h.request_number,p.p_name,h.request_version_number " +
" from PURCHASE_QUOTATIONS_HEADER h join people p on( h.supplier_id = p.swid) " +
" " +
"where h.swid not in (select nvl(o.purchase_quotations_id,0) from purchases_order_header o ) and h.swid in (select max(swid) from PURCHASE_QUOTATIONS_HEADER h2 group by h2.request_number) " +
strWhere + " order by swid");
for (int i = 0; i < dtLocationData.Rows.Count; i++)
{
dgvExpensses.Rows.Add();
dgvExpensses[0, dgvExpensses.Rows.Count - 1].Value = dtLocationData.Rows[i]["swid"].ToString();
dgvExpensses[1, dgvExpensses.Rows.Count - 1].Value = dtLocationData.Rows[i]["p_name"].ToString();
dgvExpensses[2, dgvExpensses.Rows.Count - 1].Value = dtLocationData.Rows[i]["request_number"].ToString();
dgvExpensses[3, dgvExpensses.Rows.Count - 1].Value = dtLocationData.Rows[i]["request_version_number"].ToString();
}
}
private void dgForms_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex <= -1)
{
return;
}
if (e.ColumnIndex == 5)
{
frmViewEditTemplet frm = new frmViewEditTemplet();
frm.txtFormName.Text = dgForms[1, e.RowIndex].Value.ToString();
frm.txtFormEnName.Text = dgForms[2, e.RowIndex].Value.ToString();
frm.txtFormId.Text = dgForms[0, e.RowIndex].Value.ToString();
frm.txtForm_type.Text = dgForms[3, e.RowIndex].Value.ToString();
frm.ShowDialog();
return;
}
dgProperities.Rows.Clear();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtProp = cnn.GetDataTable("select swid,control_type,en_name,ar_name,list_id,free_list_name from FORM_PROPERITY t " +
" where t.form_id = " + dgForms[0, e.RowIndex].Value.ToString() + " order by swid");
for (int i = 0; i < dtProp.Rows.Count; i++)
{
dgProperities.Rows.Add();
dgProperities[0, dgProperities.Rows.Count - 1].Value = dtProp.Rows[i]["swid"].ToString();
dgProperities[1, dgProperities.Rows.Count - 1].Value = dtProp.Rows[i]["ar_name"].ToString();
dgProperities[2, dgProperities.Rows.Count - 1].Value = "";
dgProperities[3, dgProperities.Rows.Count - 1].Value = dtProp.Rows[i]["control_type"].ToString();
dgProperities[4, dgProperities.Rows.Count - 1].Value = dtProp.Rows[i]["list_id"].ToString();
dgProperities[5, dgProperities.Rows.Count - 1].Value = dtProp.Rows[i]["free_list_name"].ToString();
dgProperities[6, dgProperities.Rows.Count - 1].Value = dtProp.Rows[i]["en_name"].ToString();
}
}
private void btnAddPhone_Click(object sender, EventArgs e)
{
if (txtCONT_VALUE.Text == "")
{
ERP.glb_function.MsgBox("الرجاء ادخال القيمة");
txtCONT_VALUE.Focus();
return;
}
for (int i = 0; i < dgCotactData.Rows.Count; i++)
{
if (txtCONT_VALUE.Text.Trim() == dgCotactData[3, i].Value.ToString().Trim())
{
glb_function.MsgBox("القيمة مدخله من قبل");
return;
}
}
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtContactValue = cnn.GetDataTable("select cont_title,cont_value,a.adb_name from contact_data c,address_book a " +
" where a.swid = c.adb_id and cont_value='" + txtCONT_VALUE.Text.Trim() + "'");
if (dtContactValue != null && dtContactValue.Rows.Count > 0)
{
glb_function.MsgBox("هذا " + lstCONT_TYPE.Text + " مسجل باسم " + dtContactValue.Rows[0]["adb_name"].ToString() + "\n" + "لايمكن اتمام العملية ");
return;
}
dgCotactData.Rows.Add();
dgCotactData[0, dgCotactData.Rows.Count - 1].Value = "";
dgCotactData[1, dgCotactData.Rows.Count - 1].Value = lstCONT_TYPE.Text;
dgCotactData[2, dgCotactData.Rows.Count - 1].Value = lstCONT_TITLE.Text;
dgCotactData[3, dgCotactData.Rows.Count - 1].Value = txtCONT_VALUE.Text;
this.dgCotactData.Sort(this.dgCotactData.Columns["CONT_TYPE"], ListSortDirection.Ascending);
}
private void GetAcc()
{
strDataFromDataSource = true;
ConnectionToDB cnn = new ConnectionToDB();
dtAccData = new DataTable();
string sql = "select a.swid,a.acc_no,a.acc_name,a.acc_type,a.acc_subject " +
" from accounts a " +
" left join acc_curr c on (a.swid = c.acc_id) " +
" left join acc_branch b on (a.swid = b.acc_id) " +
" where a.stat = N'فعال' and acc_class = N'فرعي' " +
" and system_acc_type is null " +
" and b.branch_id = " + lstBranches.SelectedValue.ToString() + " " +
" and c.curr_id = " + lstCurrency.SelectedValue.ToString() + " " +
" and a.swid not in (select upa.acc_id from USER_PREVENTED_ACC upa where user_id = " + glb_function.glb_strUserId + ")";
dtAccData = cnn.GetDataTable(sql);
lstAccNo.DataSource = dtAccData;
lstAccNo.ValueMember = "swid";
lstAccNo.DisplayMember = "acc_no";
lstAccName.DataSource = dtAccData;
lstAccName.ValueMember = "swid";
lstAccName.DisplayMember = "acc_name";
lstAccNo.SelectedIndex = -1;
lstAccName.SelectedIndex = -1;
strDataFromDataSource = false;
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!CheckEntries())
{
return;
}
glb_function.arrInsertLogs = new System.Collections.ArrayList();
//Item Information
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtGetSwid = cnn.GetDataTable("(select nvl(max(swid),0)+1 from WAREHOUSE)");
txtSWID.Text = dtGetSwid.Rows[0][0].ToString();
glb_function.arrInsertLogs.Add("insert into WAREHOUSE values (" + txtSWID.Text + "," +
glb_function.glb_strUserId + ",sysdate,'فعال'," + lstAccNo.SelectedValue.ToString() + "," + nmbW_NO.Value.ToString() +
",'" + txtW_NAME.Text + "','" + txtW_DESCRIPTION.Text + "'," + lstW_LOCATION.SelectedValue.ToString() + ",'" +
txtW_ADDRESS.Text + "'," + lstW_BRANCH.SelectedValue.ToString() + "," +
(lstSERVICE_CENTER.SelectedIndex == -1 ? "null" : lstSERVICE_CENTER.SelectedValue.ToString()) + ")");
for (int i = 0; i < dgvUsers.Rows.Count; i++)
{
glb_function.arrInsertLogs.Add("insert into STOREKEEPER values((select nvl(max(swid),0)+1 from STOREKEEPER)," + glb_function.glb_strUserId + ",sysdate,'فعال',(" + txtSWID.Text + ")," + dgvUsers[1, i].Value.ToString() + ",'" + dgvUsers[3, i].Value.ToString() + "')");
}
if (glb_function.MultiTransData())
{
GetData(txtSWID.Text);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!CheckEntries())
{
return;
}
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtUsers = cnn.GetDataTable("select nvl(max(swid),0)+1 from USERINFO");
txtSWID.Text = dtUsers.Rows[0][0].ToString();
glb_function.arrInsertLogs = new System.Collections.ArrayList();
glb_function.arrInsertLogs.Add
("insert into USERINFO values(" + txtSWID.Text +
" ,sysdate,'ACTIVE'," + glb_function.glb_strUserId + "" +
",'" + txtUSER_LOGIN.Text + "', '" + txtUSER_NAME.Text + "',null" +
", '" + new glb_SysFun().Encrypt("123", true) + "','" + txtUSER_NOTE.Text + "'" +
"," + (lstUSER_BRANCH.SelectedValue == null ? "null" : lstUSER_BRANCH.SelectedValue.ToString()) + "," +
" '" + lstACCESS_TYPE.Text + "'," + lstDept.SelectedValue.ToString() + ")");
SaveUserPreventedAcc();
GetTempletToSave();
if (glb_function.MultiTransData())
{
GetData(txtSWID.Text.Trim());
}
}
private void btnFind_Click(object sender, EventArgs e)
{
dgUser.Rows.Clear();
ConnectionToDB cnn = new ConnectionToDB();
string strParent = "";
if (lstUSER_BRANCH.SelectedValue == null || lstUSER_BRANCH.Text == "")
{
strParent = "";
}
else
{
strParent = " and USER_BRANCH=" + lstUSER_BRANCH.SelectedValue.ToString();
}
DataTable dtLocationData = cnn.GetDataTable("select USER_LOGIN,USER_NAME,USER_BRANCH ,t.USER_NOTE,swid from USERINFO t " +
" where USER_LOGIN like '%" + txtUSER_LOGIN.Text.Trim() + "%' and USER_NAME like '%" +
txtUSER_NAME.Text + "%'" +
" " + strParent + strWhere);
for (int i = 0; i < dtLocationData.Rows.Count; i++)
{
dgUser.Rows.Add();
dgUser[0, dgUser.Rows.Count - 1].Value = dtLocationData.Rows[i]["swid"].ToString();
dgUser[1, dgUser.Rows.Count - 1].Value = dtLocationData.Rows[i]["USER_LOGIN"].ToString();
dgUser[2, dgUser.Rows.Count - 1].Value = dtLocationData.Rows[i]["USER_NAME"].ToString();
dgUser[3, dgUser.Rows.Count - 1].Value = dtLocationData.Rows[i]["USER_BRANCH"].ToString();
dgUser[4, dgUser.Rows.Count - 1].Value = dtLocationData.Rows[i]["USER_NOTE"].ToString();
}
}
//private string GetCostCenterNo()
//{
// ConnectionToDB cnn = new ConnectionToDB();
// DataTable dtCCNo = cnn.GetDataTable("select nvl(max( to_number(substr(cost_center_no,-3))),0)+1 from COSTCENTER t " +
// " where t.cost_center_type = 'نشاط'");
// return dtCCNo.Rows[0][0].ToString().PadLeft(3, '0');
//}
private void GetData(string strPk)
{
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtLocation = cnn.GetDataTable("select swid, created_date, created_user, sata, act_name, act_type,to_char( act_started_date,'dd/mm/yyyy') act_started_date, act_user, cost_center, act_inf, act_tel from ACTIVITIES where swid=" + strPk);
txtACT_NAME.Text = dtLocation.Rows[0]["ACT_NAME"].ToString();
txtACT_NAME.W_OldValue = dtLocation.Rows[0]["ACT_NAME"].ToString();
lstACT_TYPE.Text = dtLocation.Rows[0]["ACT_TYPE"].ToString();
lstACT_TYPE.W_OldValue = dtLocation.Rows[0]["ACT_TYPE"].ToString();
dtpACT_STARTED_DATE.Value = DateTime.ParseExact(dtLocation.Rows[0]["ACT_STARTED_DATE"].ToString(), "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
dtpACT_STARTED_DATE.W_OldValue = DateTime.ParseExact(dtLocation.Rows[0]["ACT_STARTED_DATE"].ToString(), "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy");
txtACT_USER.Text = dtLocation.Rows[0]["ACT_USER"].ToString();
txtACT_USER.W_OldValue = dtLocation.Rows[0]["ACT_USER"].ToString();
txtACT_TEL.Text = dtLocation.Rows[0]["ACT_TEL"].ToString();
txtACT_TEL.W_OldValue = dtLocation.Rows[0]["ACT_TEL"].ToString();
txtACT_INF.Text = dtLocation.Rows[0]["ACT_INF"].ToString();
txtACT_INF.W_OldValue = dtLocation.Rows[0]["ACT_INF"].ToString();
btnSave.Visible = false;
btnNew.Location = btnSave.Location;
btnNew.Visible = true;
if (HasPrivilege("btnUpdate"))
{
btnUpdate.Enabled = true;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!CheckEntries())
{
return;
}
glb_function.arrInsertLogs = new System.Collections.ArrayList();
//Item Information
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtGetSwid = cnn.GetDataTable("(select nvl(max(swid),0)+1 from SERVICES)");
txtSwid.Text = dtGetSwid.Rows[0][0].ToString();
glb_function.arrInsertLogs.Add("insert into SERVICES values (" + txtSwid.Text + ",sysdate," +
glb_function.glb_strUserId + ",'فعال','" + txtSERVICE_NO.Text + "','" + txtSERVICE_NAME.Text + "'," +
lstCURRENCY.SelectedValue.ToString() +
",'" + lstPRICE_TYPE.Text + "'," + nmbPRICE.Value.ToString() + "," + nmbCOST.Value.ToString() +
",'" + txtUNIT.Text + "','" + (ckbAPPEAR_IN_SALES.Checked ?"1":"0") + "','" + txtS_NOTES.Text + "'," +
lstAccNo.SelectedValue.ToString() + "," + lstACTIVITY_ID.SelectedValue.ToString() + ")");
if (glb_function.MultiTransData())
{
GetData(txtSwid.Text);
}
}
private void GetData(string strSwid)
{
new glb_function().clearItems(this);
PrepareForm();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtLocation = cnn.GetDataTable("select * from forms where swid=" + strSwid);
txtSWID.Text = strSwid;
txtAR_NAME.Text = dtLocation.Rows[0]["AR_NAME"].ToString();
txtEN_NAME.Text = dtLocation.Rows[0]["EN_NAME"].ToString();
lstFORM_TYPE.Text = dtLocation.Rows[0]["FORM_TYPE"].ToString();
lstSUB_FORM.Text = dtLocation.Rows[0]["SUB_FORM"].ToString();
ckbMULTI_FORM_FOR_USER.Checked = (dtLocation.Rows[0]["MULTI_FORM_FOR_USER"].ToString() == "1" ? true : false);
GetProperitiesData();
btnSave.Visible = false;
btnNew.Location = btnSave.Location;
btnNew.Visible = true;
if (HasPrivilege("btnUpdate"))
{
btnUpdate.Enabled = true;
}
}
private void FillAcc()
{
if (lstCURRENCY_ID.SelectedIndex == -1)
{
glb_function.MsgBox("الرجاء اختيار العملة اولا");
return;
}
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtAccData;
dtAccData = cnn.GetDataTable("select a.swid,a.acc_no,a.acc_name " +
" from accounts a " +
" join acc_curr c on (c.acc_id = a.swid) " +
" where a.acc_class = N'فرعي' and a.ACC_TYPE like N'%%' and a.stat = N'فعال' " +
" and c.curr_id = " + lstCURRENCY_ID.SelectedValue.ToString());
if (dtAccData != null && dtAccData.Rows.Count > 0)
{
lstAccNo.DataSource = dtAccData;
lstAccNo.DisplayMember = "Acc_no";
lstAccNo.ValueMember = "swid".ToUpper();
lstAccName.DataSource = dtAccData;
lstAccName.DisplayMember = "acc_name";
lstAccName.ValueMember = "swid".ToUpper();
lstAccNo.SelectedIndex = -1;
lstAccName.SelectedIndex = -1;
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
frmFindImport frm = new frmFindImport();
frm.strWhere = " and stat='فعال'";
frm.ShowDialog();
if (frm.strImportID != "")
{
txtImportId.Text = (frm.strImportID);
txtImport_no.Text = frm.strImportNo;
lstImpContainer.Items.Clear();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtInvoice = cnn.GetDataTable("select distinct l.container from packing_list l " +
" where l.import_id = " + txtImportId.Text);
lstImpContainer.DataSource = dtInvoice;
lstImpContainer.DisplayMember = "container";
lstImpContainer.SelectedIndex = -1;
LoadExp();
}
}
private void lstCURRENCY_ID_SelectedIndexChanged(object sender, EventArgs e)
{
//new glb_function().clearItems(this);
if (lstCURRENCY_ID.SelectedValue == null)
{
return;
}
if (lstCURRENCY_ID.SelectedValue.ToString() != "System.Data.DataRowView" && lstCURRENCY_ID.SelectedValue.ToString() != "")
{
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtcurr = cnn.GetDataTable("select c.swid , c.curr_name,e.curr_price,CURR_SMPL,e.CURR_MIN,e.CURR_MAX,c.CURR_DECIMAL from currency c,currency_exchange e " +
" where e.curr_id = c.swid and c.swid = " + lstCURRENCY_ID.SelectedValue.ToString() + " " +
" and e.swid = (select max(x.swid) from currency_exchange x where x.curr_id = c.swid) ");
iCurrSwid = dtcurr.Rows[0]["swid"].ToString();
dExchangeRate = Convert.ToDecimal(dtcurr.Rows[0]["curr_price"].ToString());
iCurrDecimal = Convert.ToInt16(dtcurr.Rows[0]["CURR_DECIMAL"].ToString());
nmbCURRENCY_EXCHANGE.Value = dExchangeRate;
nmbInvoicTotal.DecimalPlaces = iCurrDecimal;
nmbTotalExp.DecimalPlaces = iCurrDecimal;
nmbTotalWithExp.DecimalPlaces = iCurrDecimal;
lstAccNo.Enabled = true;
lstAccName.Enabled = true;
FillAcc();
if (lstBILL_TYPE.Text.Trim() == "اجل")
{
lstAccNo.SelectedValue = iVendorAcc;
lstAccNo.Enabled = false;
lstAccName.Enabled = false;
}
}
}
private void FillBranch()
{
lstBranchHeader.DataSource = null;
ConnectionToDB cnn = new ConnectionToDB();
string strMult = lstTempBranch.Text.Trim();
string iindexx = "";
string strInStat = "";
while (strMult != "")
{
iindexx = (strMult.Substring(0, strMult.IndexOf(";")));
strMult = strMult.Substring(strMult.IndexOf(";") + 1);
// lstBranchHeader.Items.Add(iindexx);
strInStat = (strInStat == "" ? "'" + iindexx + "'" : strInStat + ",'" + iindexx + "'");
}
DataTable dt = cnn.GetDataTable("select swid,b.branch_cost_center_name " +
" from branches_costcenter b " +
" where b.branch_cost_center_name in (" + strInStat + ")");
lstBranchHeader.DataSource = dt;
lstBranchHeader.ValueMember = "swid";
lstBranchHeader.DisplayMember = "branch_cost_center_name";
}
private void btnSearch_Click(object sender, EventArgs e)
{
dgvExpensses.Rows.Clear();
ConnectionToDB cnn = new ConnectionToDB();
if (txtRequestNo.Text.Trim() != "")
{
strWhere = strWhere + " and purchase_order_num = " + txtRequestNo.Text + "";
}
strWhere = strWhere + " and p_name like '%" + txtVendorName.Text + "%'";
DataTable dtLocationData = cnn.GetDataTable("select h.swid,p.p_name,h.bill_number,to_char(h.bill_date,'dd/mm/yyyy') bill_date " +
" from purchases_bill h" +
" join people p on (p.swid = h.supplier_id) " +
strWhere);
for (int i = 0; i < dtLocationData.Rows.Count; i++)
{
dgvExpensses.Rows.Add();
dgvExpensses[0, dgvExpensses.Rows.Count - 1].Value = dtLocationData.Rows[i]["swid"].ToString();
dgvExpensses[1, dgvExpensses.Rows.Count - 1].Value = dtLocationData.Rows[i]["p_name"].ToString();
dgvExpensses[2, dgvExpensses.Rows.Count - 1].Value = dtLocationData.Rows[i]["bill_number"].ToString();
dgvExpensses[3, dgvExpensses.Rows.Count - 1].Value = dtLocationData.Rows[i]["bill_date"].ToString();
}
}
private void GetTermsExpensess(string strTermSwid)
{
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtTerm = cnn.GetDataTable("select TERMS_NAME from TERMS_EXPENSES_HEADER where swid= " + strTermSwid);
txtTERMS_OF_EXPENSES_name.Text = dtTerm.Rows[0][0].ToString();
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtVALUE_MEMBER.Text.Trim() == "")
{
glb_function.MsgBox("الرجاء ادخال رقم التعريف");
txtVALUE_MEMBER.Focus();
return;
}
if (txtDISPLAY_MEMBER.Text.Trim() == "")
{
glb_function.MsgBox("الرجاء ادخال القيمة");
txtDISPLAY_MEMBER.Focus();
return;
}
dgFreeList.Rows.Clear();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtGetid = cnn.GetDataTable("select nvl(max(swid),0)+1 from FREE_LIST");
txtSWid.Text = dtGetid.Rows[0][0].ToString();
int icheck = cnn.TranDataToDB("insert into FREE_LIST values(" + txtSWid.Text + ",'" + lstLIST_NAME.Text + "','" + txtDISPLAY_MEMBER.Text + "','" + txtVALUE_MEMBER.Text + "')");
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية الاضافة");
return;
}
cnn.glb_commitTransaction();
GetData(lstLIST_NAME.Text);
glb_function.MsgBox("تمت العملية بنجاح.");
}
private void btnSaveTermExp_Click(object sender, EventArgs e)
{
if (!CheckExpAgreementEntries())
{
return;
}
glb_function.arrInsertLogs = new System.Collections.ArrayList();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtGetSwid = cnn.GetDataTable("(select nvl(max(swid),0)+1 from TERMS_EXPENSES_HEADER)");
txtTermExpSwid.Text = dtGetSwid.Rows[0][0].ToString();
glb_function.arrInsertLogs.Add("insert into TERMS_EXPENSES_HEADER values (" + txtTermExpSwid.Text + ",sysdate," + glb_function.glb_strUserId + ",'فعال'," +
"'" + txtTERMS_NAME.Text + "','" + txtTERMS_COD.Text + "')");
for (int i = 0; i < dgvExpAgreement.Rows.Count; i++)
{
if (dgvExpAgreement["clmSelect", i].Value.ToString() == "True")
{
glb_function.arrInsertLogs.Add("insert into TERMS_EXPENSES_DETAILS values ((select nvl(max(swid),0)+1 from TERMS_EXPENSES_DETAILS)," + txtTermExpSwid.Text + "," + dgvExpAgreement["clmExpItemId", i].Value.ToString() + ")");
}
}
if (glb_function.MultiTransData())
{
GetAgreementData(txtTermExpSwid.Text);
}
}
private void GetData(string strSwid)
{
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtLocation = cnn.GetDataTable("select c.*,a.acc_no,a.acc_parent,a.ACC_NATURE from CASHER c ,accounts a " +
" where c.acc_id = a.swid and c.swid =" + strSwid);
txtC_Name.Text = dtLocation.Rows[0]["C_Name"].ToString();
txtC_Name.W_OldValue = dtLocation.Rows[0]["C_Name"].ToString();
lstAccName.SelectedValue = Convert.ToInt16(dtLocation.Rows[0]["acc_parent"].ToString());
txtAccNo.Text = dtLocation.Rows[0]["acc_no"].ToString();
txtAccId.Text = dtLocation.Rows[0]["acc_id"].ToString();
lstC_type.Text = dtLocation.Rows[0]["C_type"].ToString();
lstBranches.SelectedValue = Convert.ToInt16(dtLocation.Rows[0]["branch_id"].ToString());
lstACC_NATURE.Text = dtLocation.Rows[0]["ACC_NATURE"].ToString();
lstAccName.Enabled = false;
lstAccNo.Enabled = false;
btnSave.Visible = false;
btnNew.Location = btnSave.Location;
btnNew.Visible = true;
if (HasPrivilege("btnUpdate"))
{
btnUpdate.Enabled = true;
}
}
private void btnAddAddressBook_Click(object sender, EventArgs e)
{
if (lstBankName.SelectedIndex == -1)
{
glb_function.MsgBox("لايمكن اضافة دليل عناوين حتى يتم حفظ بيانات البنك");
return;
}
File.frmContacts frm = new File.frmContacts();
frm.txtADB_NAME.Text = lstBankName.Text.Trim();
frm.ShowDialog();
if (frm.txtSWID.Text.Trim() == "")
{
glb_function.MsgBox("لم يتم حفظ العنوان");
return;
}
ConnectionToDB cnn = new ConnectionToDB();
DataTable dt = cnn.GetDataTable("select nvl(max(swid),0)+1 from BANK_ADDRESS");
int icheck = cnn.TranDataToDB("insert into BANK_ADDRESS values (" + dt.Rows[0][0].ToString() + "," + lstBankName.SelectedValue.ToString() + "," + frm.txtSWID.Text.Trim() + ")");
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية حفظ العنوان");
return;
}
cnn.glb_commitTransaction();
GetBankAddress();
}
private void btnFind_Click(object sender, EventArgs e)
{
dgCurrency.Rows.Clear();
ConnectionToDB cnn = new ConnectionToDB();
// DataTable dtCurrencyData = cnn.GetDataTable("select * from CURRENCY t " +
// " where CURR_NAME like '%" + txtCURR_NAME.Text .Trim() + "%' and CURR_SMPL like '%" +
// txtCURR_SMPL .Text + "%'" +
// " ");
//جملة البحث بواسطة خالد مبارك
DataTable dtCurrencyData = cnn.GetDataTable("select c.swid , c.curr_name,e.curr_price,CURR_SMPL,CURR_NOTE from currency c,currency_exchange e" +
" where e.curr_id = c.swid " +
" and e.swid = (select max(x.swid) from currency_exchange x where x.curr_id = c.swid) and c.CURR_NAME like '%" + txtCURR_NAME.Text.Trim() + "%' and c.CURR_SMPL like '%" +
txtCURR_SMPL.Text + "%'");
for (int i = 0; i < dtCurrencyData.Rows.Count; i++)
{
dgCurrency.Rows.Add();
dgCurrency[0, dgCurrency.Rows.Count - 1].Value = dtCurrencyData.Rows[i]["swid"].ToString();
dgCurrency[1, dgCurrency.Rows.Count - 1].Value = dtCurrencyData.Rows[i]["CURR_NAME"].ToString();
dgCurrency[2, dgCurrency.Rows.Count - 1].Value = dtCurrencyData.Rows[i]["CURR_SMPL"].ToString();
dgCurrency[3, dgCurrency.Rows.Count - 1].Value = dtCurrencyData.Rows[i]["curr_price"].ToString();
dgCurrency[4, dgCurrency.Rows.Count - 1].Value = dtCurrencyData.Rows[i]["CURR_NOTE"].ToString();
}
}