private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (!CheckEntries())
{
return;
}
ConnectionToMySQL cnn = new ConnectionToMySQL();
DataTable dtTemplte = cnn.GetDataTable("select ifnull(max(b.pkid),0)+1 from TEMPLET_HEADER b");
txtPkId.Text = dtTemplte.Rows[0][0].ToString();
int icheck = cnn.TranDataToDB("insert into TEMPLET_HEADER values(" + txtPkId.Text + "," +
glb_function.glb_strUserId + ",sysdate(),'" + txtTempletName.Text + "','" +
glb_function.GetCellValue(ref dgvForms, clmFormEnName.DisplayIndex, dgvForms.SelectedIndex) + "','" +
glb_function.GetCellValue(ref dgvForms, clmFormArName.DisplayIndex, dgvForms.SelectedIndex) + "','" +
glb_function.GetCellValue(ref dgvForms, clmMultiForm.DisplayIndex, dgvForms.SelectedIndex) + "','" +
glb_function.GetCellValue(ref dgvForms, clmFormTypeEn.DisplayIndex, dgvForms.SelectedIndex) + "','" +
glb_function.GetCellValue(ref dgvForms, clmFormTypeAr.DisplayIndex, dgvForms.SelectedIndex) + "')");
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية الحفظ");
return;
}
int iProSwid = 0;
dtTemplte.Clear();
dtTemplte = cnn.GetDataTable("select ifnull(max(b.pkid),0)+1 from TEMPLET_DETAILS b");
iProSwid = Convert.ToInt16(dtTemplte.Rows[0][0].ToString());
for (int i = 0; i < dgProperities.Items.Count; i++)
{
icheck = cnn.TranDataToDB("insert into TEMPLET_DETAILS values(" + iProSwid.ToString() +
"," + txtPkId.Text +
",'" +
glb_function.GetCellValue(ref dgProperities, clmcontrol_type.DisplayIndex, i) + "','" +
glb_function.GetCellValue(ref dgProperities, clmen_name.DisplayIndex, i) + "','" +
glb_function.GetCellValue(ref dgProperities, clmPropertyName.DisplayIndex, i) + "','" +
glb_function.GetCellValueControl(ref dgProperities, "TextBox", clmPropertyValue.DisplayIndex, i) + "'," +
glb_function.glb_strUserId + ",sysdate(),'" +
(glb_function.GetCellValue(ref dgProperities, clmRealValue.DisplayIndex, i) == "" ? glb_function.GetCellValueControl(ref dgProperities, "TextBox", clmPropertyValue.DisplayIndex, i) : glb_function.GetCellValue(ref dgProperities, clmRealValue.DisplayIndex, i)) + "')");
iProSwid++;
if (icheck <= 0)
{
cnn.glb_RollbackTransaction();
glb_function.MsgBox("حدث خطأ اثناء عملية الحفظ");
return;
}
}
cnn.glb_commitTransaction();
glb_function.MsgBox("تمت عملية الحفظ بنجاح");
dgProperities.Items.Clear();
txtTempletName.Text = "";
}
private void btnAdd_Click(object sender, EventArgs e)
{
ConnectionToMySQL cnn = new ConnectionToMySQL();
DataTable dtSU;
int icheck = 0;
string strSU_Pkid = "";
if (lstStandardUnit.SelectedIndex == -1)
{
dtSU = cnn.GetDataTable("select ifnull(max(b.pkid),0)+1 from standard_unit b");
strSU_Pkid = dtSU.Rows[0][0].ToString();
icheck = cnn.TranDataToDB("insert into standard_unit values(" +
"(" + strSU_Pkid + ")" +
",'" + lstStandardUnit.Text.Trim() + "'" +
")");
if (icheck <= 0)
{
cnn.glb_RollbackTransaction();
glb_function.MsgBox("حدث خطأ اثناء عملية الاضافة");
return;
}
}
else
{
strSU_Pkid = lstStandardUnit.SelectedValue.ToString();
}
icheck = cnn.TranDataToDB("insert into units values (" +
"(select ifnull(max(b.pkid),0)+1 from units b)" +
",''" +
",sysdate()" +
"," + glb_function.glb_strUserId +
"," + strSU_Pkid +
",'" + txtUnitName.Text.Trim() + "'" +
"," + nmbUnitValue.Value.ToString() +
",'" + (ckbIsMainUnit.Checked == true ? "1" : "0") + "'" +
",'" + txtUnitNote.Text.Trim() + "'" +
",'" + (ckbIsPurchaseUnit.Checked == true ? "1" : "0") + "'" +
")");
if (icheck <= 0)
{
cnn.glb_RollbackTransaction();
glb_function.MsgBox("حدث خطأ اثناء عملية الاضافة");
return;
}
cnn.glb_commitTransaction();
glb_function.MsgBox("تمت عملية الاضافة بنجاح");
GetData(strSU_Pkid);
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (lstEmp.SelectedIndex == -1)
{
glb_function.MsgBox("الرجاء اختيار العامل");
lstEmp.Focus();
return;
}
if (lstPumps.SelectedIndex == -1)
{
glb_function.MsgBox("الرجاء اختيار الطرمبة");
lstPumps.Focus();
return;
}
ConnectionToMySQL cnn = new ConnectionToMySQL();
ConnectionToMySQL cnnSave = new ConnectionToMySQL();
int icheck = cnnSave.TranDataToDB("insert into pump_emp " +
" values((select ifnull(max(b.pkid),0)+1 from pump_emp b)" +
",'فعال'" +
",SYSDATE() " +
"," + glb_function.glb_strUserId +
",str_to_date('" + dtpWorkingDate.Value.ToString("dd/MM/yyyy") + "','%d/%m/%Y')" +
",'" + lstEmp.SelectedValue.ToString() + "'" +
"," + lstPumps.SelectedValue.ToString() +
")");
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية اضافة البيانات");
return;
}
icheck = cnnSave.TranDataToDB("update pumps set stat ='شغالة' where pkid=" + lstPumps.SelectedValue.ToString());
if (icheck <= 0)
{
cnnSave.glb_RollbackTransaction();
glb_function.MsgBox("حدث خطأ اثناء عملية اضافة البيانات");
return;
}
cnnSave.glb_commitTransaction();
lstEmp.SelectedIndex = -1;
lstPumps.SelectedIndex = -1;
FillPumps();
GetData();
}
private void btnSave_Click(object sender, EventArgs e)
{
glb_function.strDbCnnString = "server=localhost;port=3300;charset=utf8;database=ammar2016;userid=root;password=bigboss;SslMode=none;AllowPublicKeyRetrieval=True";
ConnectionToMySQL cnn = new ConnectionToMySQL();
int icheck = 0;
for (int i = 0; i < myDataGrid1.Rows.Count; i++)
{
icheck = cnn.TranDataToDB("insert into accounts values(" + myDataGrid1[0, i].Value.ToString() +
",'فعال'" +
",sysdate()" +
",1" +
",'" + myDataGrid1[0, i].Value.ToString() + "'" +
",'" + myDataGrid1[1, i].Value.ToString() + "'" +
"," + (myDataGrid1[2, i].Value.ToString() == ""?"null":"'" + myDataGrid1[2, i].Value.ToString() + "'") +
",''" +
",'" + myDataGrid1[5, i].Value.ToString() + "'" +
",'" + myDataGrid1[6, i].Value.ToString() + "'" +
",''" +
",''" +
",'" + myDataGrid1[4, i].Value.ToString() + "'" +
")");
if (icheck <= 0)
{
cnn.glb_RollbackTransaction();
glb_function.MsgBox("Error");
return;
}
}
cnn.glb_commitTransaction();
glb_function.MsgBox("Save");
}
private void button6_Click(object sender, EventArgs e)
{
glb_function.strDbCnnString = "server=localhost;port=3300;charset=utf8;database=ammar2018;userid=root;password=bigboss;SslMode=none;AllowPublicKeyRetrieval=True";
ConnectionToMySQL cnn = new ConnectionToMySQL();
int icheck = 0;
int jourNo = 2;
for (int i = 0; i < myDataGrid1.Rows.Count; i++)
{
icheck = cnn.TranDataToDB("insert into journal_header values(" + myDataGrid1[1, i].Value.ToString() +
",'مرحل'" +
",sysdate()" +
",1" +
",1" +
",'1-" + jourNo + "'" +
",'سند قيد'" +
"," + (i + 1) +
",str_to_date('" + myDataGrid1[2, i].Value.ToString() + "',' %d/%m/%Y')" +
",''" +
",null" +
",'1-" + (i + 1) + "'" +
")");
jourNo++;
if (icheck <= 0)
{
glb_function.MsgBox("Error");
return;
}
}
cnn.glb_commitTransaction();
glb_function.MsgBox("Save");
}
private void dgvProperities_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex <= -1)
{
return;
}
if (e.ColumnIndex == clmDelete.Index)
{
if (glb_function.MsgBox("هل تريد الحذف بالفعل؟", "", true) == false)
{
return;
}
if (dgvProperities[clmPkid.Index, e.RowIndex].Value.ToString() == "")
{
dgvProperities.Rows.Remove(dgvProperities.CurrentRow);
}
else
{
ConnectionToMySQL cnn = new ConnectionToMySQL();
int icheck = cnn.TranDataToDB("delete from forms_de where pkid=" + dgvProperities[0, e.RowIndex].Value.ToString());
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية الحذف");
return;
}
cnn.glb_commitTransaction();
dgvProperities.Rows.Remove(dgvProperities.CurrentRow);
}
glb_function.MsgBox("تمت العملية بنجاح");
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (!CheckEntries())
{
return;
}
ConnectionToMySQL cnnSave = new ConnectionToMySQL();
string str = nmbPumpCounter.Value.ToString();
int icheck = cnnSave.TranDataToDB("update pumps set " +
" created_user="******",PumpNo='" + txtPumpNo.Text.Trim() + "'" +
",PumpName='" + txtPumpName.Text.Trim() + "'" +
",stat='" + lstPumpStat.Text.Trim() + "'" +
",PumpCounter=" + nmbPumpCounter.Value.ToString() + "" +
",warehouse_id=" + lstWareHouse.SelectedValue.ToString() +
",item_id=" + lstItems.SelectedValue.ToString() +
",PumpNote='" + txtPumpNote.Text.Trim() + "'" +
" where pkid=" + txtPkid.Text);
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية تعديل بيانات الصنف");
return;
}
cnnSave.glb_commitTransaction();
glb_function.MsgBox("تمت العملية بنجاح");
GetData(txtPkid.Text);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (!CheckEntries())
{
return;
}
ConnectionToMySQL cnnSave = new ConnectionToMySQL();
int icheck = cnnSave.TranDataToDB("update Items set " +
" created_user="******",itemno='" + txtItemNo.Text.Trim() + "'" +
",itemname='" + txtItemName.Text.Trim() + "'" +
",itemtype='" + lstItemType.Text.Trim() + "'" +
",Standard_Unit_id=" + lstUnits.SelectedValue.ToString() +
",UnitCost=" + nmbCostValue.Value.ToString() +
",UnitSellingPrice=" + nmbSellingPriceValue.Value.ToString() +
",itemnote='" + txtItemNote.Text.Trim() + "'" +
" where pkid=" + txtPkid.Text);
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية تعديل بيانات الصنف");
return;
}
cnnSave.glb_commitTransaction();
glb_function.MsgBox("تمت العملية بنجاح");
GetData(txtPkid.Text);
}
private void btnAdd_Click(object sender, RoutedEventArgs 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;
}
dgvFreeList.Items.Clear();
ConnectionToMySQL cnn = new ConnectionToMySQL();
DataTable dtGetid = cnn.GetDataTable("select ifnull(max(b.pkid),0)+1 from FREE_LIST b");
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 btnUpdate_Click(object sender, RoutedEventArgs e)
{
if (!CheckEntries())
{
return;
}
ConnectionToMySQL cnnSave = new ConnectionToMySQL();
int icheck = cnnSave.TranDataToDB("update warehouse " +
" set " +
" created_user="******",warehouse_no='" + txtWareHouseNo.Text.Trim() + "'" +
",warehouse_name='" + txtWareHouseName.Text.Trim() + "'" +
",branch_id=" + lstBranches.SelectedValue.ToString() +
",warehouse_note='" + txtWarehouseNote.Text.Trim() + "'" +
" where pkid=" + txtPkid.Text.Trim());
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية تعديل بيانات المستخدم");
return;
}
cnnSave.glb_commitTransaction();
glb_function.MsgBox("تمت العملية بنجاح");
GetData(txtPkid.Text);
}
private void btnFind_Click(object sender, EventArgs e)
{
if (txtProfitCenter.Text.Trim() == "")
{
glb_function.MsgBox("الرجاء ادخال اسم مركز الربحية");
txtProfitCenter.Focus();
return;
}
for (int i = 0; i < dgvJournalData.Rows.Count; i++)
{
if (txtProfitCenter.Text.Trim() == dgvJournalData[clmName.Index, i].Value.ToString())
{
glb_function.MsgBox("مركز الربحية مدخل من قبل");
txtProfitCenter.Focus();
return;
}
}
ConnectionToMySQL cnn = new ConnectionToMySQL();
int icheck = cnn.TranDataToDB("insert into profitcenter values(" +
"(select ifnull(max(b.pkid),0)+1 from profitcenter b)" +
",'" + txtProfitCenter.Text.Trim() + "'" +
")");
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء العملية");
return;
}
cnn.glb_commitTransaction();
glb_function.MsgBox("تمت الاضافة بنجاح");
GetAccounts();
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (!CheckEntries())
{
return;
}
ConnectionToMySQL cnnSave = new ConnectionToMySQL();
DataTable dt = cnnSave.GetDataTable("(select ifnull(max(b.pkid),0)+1 from warehouse b)");
txtPkid.Text = dt.Rows[0][0].ToString();
int icheck = cnnSave.TranDataToDB("insert into warehouse " +
" values(" + txtPkid.Text + "" +
",'فعال'" +
",SYSDATE() " +
"," + glb_function.glb_strUserId +
",'" + txtWareHouseNo.Text.Trim() + "'" +
",'" + txtWareHouseName.Text.Trim() + "'" +
"," + lstBranches.SelectedValue.ToString() +
",'" + txtWarehouseNote.Text.Trim() + "'" +
")");
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية حفظ بيانات المستخدم");
return;
}
cnnSave.glb_commitTransaction();
glb_function.MsgBox("تمت العملية بنجاح");
GetData(txtPkid.Text);
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
ConnectionToMySQL conn = new ConnectionToMySQL();
System.Data.DataTable dtLogin = conn.GetDataTable("select pkid from users " +
" where UserFullName='" + glb_function.glb_strUserName.Trim() + "' and PASSWORD='******'");
if (dtLogin != null && dtLogin.Rows.Count != 0)
{
if (txtPassword.Password.Trim() != txtConfirmPass.Password.Trim())
{
glb_function.MsgBox("كلمة السر غير متطابقة");
return;
}
int icheck = conn.TranDataToDB("update users set PASSWORD='******' where pkid=" + glb_function.glb_strUserId);
if (icheck <= 0)
{
conn.glb_RollbackTransaction();
glb_function.MsgBox("حدث خطأ عند تغير كلمة السر");
return;
}
conn.glb_commitTransaction();
glb_function.MsgBox("تمت عملية تغير كلمة السر بنجاح" + "\n" + "الرجاء تسجيل الدخول للتاكد");
this.Close();
}
else
{
glb_function.MsgBox("الرجاء التاكد من كلمة السر السابقة", "رسالة نظام");
return;
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
ConnectionToMySQL cnn = new ConnectionToMySQL();
int icheck = cnn.TranDataToDB("insert into currency values(" +
"(SELECT ifnull(max(b.pkid),0)+1 FROM currency b)" +
",'فعال'" +
",sysdate()" +
"," + glb_function.glb_strUserId +
",'" + txtCurr_name.Text.Trim() + "'" +
",'" + txtCURR_SMPL.Text.Trim() + "'" +
",'" + numCURR_DECIMAL.Value.ToString() + "'" +
",'" + numCURR_CHANGE_Rate.Value.ToString() + "'" +
",'" + txtCURR_NOTE.Text.Trim() + "'" +
",'" + (ckbIsMainCurr.Checked == true ? "1" : "0") + "'" +
",'" + (ckbIsInvCurr.Checked == true ? "1" : "0") + "'" +
")");
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء الإضافة");
return;
}
cnn.glb_commitTransaction();
glb_function.MsgBox("تمت عملية الإضافة بنجاح");
txtCurr_name.Text = "";
txtCURR_SMPL.Text = "";
txtCURR_NOTE.Text = "";
numCURR_DECIMAL.Value = 0;
numCURR_CHANGE_Rate.Value = 0;
ckbIsMainCurr.Checked = false;
ckbIsInvCurr.Checked = false;
GetCurrency();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (!CheckEntries())
{
return;
}
ConnectionToMySQL cnnSave = new ConnectionToMySQL();
int icheck = cnnSave.TranDataToDB("update emp set " +
" created_user="******",empno='" + txtEmpNo.Text.Trim() + "'" +
",empname='" + txtEmpName.Text.Trim() + "'" +
",address='" + txtAddress.Text.Trim() + "'" +
",tel='" + txtTel.Text.Trim() + "'" +
",branch_id=" + lstBranches.SelectedValue.ToString() +
",empNote='" + txtEmpNote.Text.Trim() + "'" +
",acc_id=" + lstAccNo.SelectedValue.ToString() +
" where pkid=" + txtPkid.Text);
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية تعديل بيانات العامل");
return;
}
cnnSave.glb_commitTransaction();
glb_function.MsgBox("تمت العملية بنجاح");
GetData(txtPkid.Text);
}
private void AddAccount()
{
ConnectionToMySQL cnn = new ConnectionToMySQL();
int icheck = cnn.TranDataToDB("insert into accounts values(" +
"(SELECT ifnull(max(b.pkid),0)+1 FROM accounts b)" +
",'فعال'" +
",sysdate()" +
"," + glb_function.glb_strUserId +
",'" + txtAccNo.Text + "'" +
",'" + txtAccName.Text.Trim() + "'" +
",'" + txtParentId.Text.Trim() + "'" +
",'" + txtAccNote.Text.Trim() + "'" +
",'" + txtLevel.Text.Trim() + "'" +
",'" + strAccShortNo.Trim() + "'" +
")");
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء الإضافة");
return;
}
cnn.glb_commitTransaction();
glb_function.MsgBox("تمت عملية الإضافة بنجاح");
txtAccNo.Text = "";
txtAccName.Text = "";
txtAccNote.Text = "";
GetAccNo();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (!CheckEntries())
{
return;
}
ConnectionToMySQL cnnSave = new ConnectionToMySQL();
int icheck = cnnSave.TranDataToDB("update vendors set " +
" created_user="******",vendorno='" + txtVendorNo.Text.Trim() + "'" +
",vendorname='" + txtVendorName.Text.Trim() + "'" +
",addess1='" + txtAddress1.Text.Trim() + "'" +
",addess2='" + txtAddress2.Text.Trim() + "'" +
",tel1='" + txtTel1.Text.Trim() + "'" +
",tel2='" + txtTel2.Text.Trim() + "'" +
",acc_id=" + (lstAccNo.SelectedIndex == -1 ? "null" : lstAccNo.SelectedValue.ToString()) +
",vendornote'" + txtVendorNote.Text.Trim() + "'" +
" where pkid=" + txtPkid.Text);
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية تعديل بيانات المورد");
return;
}
cnnSave.glb_commitTransaction();
glb_function.MsgBox("تمت العملية بنجاح");
GetData(txtPkid.Text);
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (txtPkid.Text == "")
{
glb_function.MsgBox("الرجاء تحديد الحساب");
return;
}
//if (txtLevel.Text.Trim() != "5")
//{
// glb_function.MsgBox("لايمكن حذف حساب رئيسي");
// return;
//}
ConnectionToMySQL cnn = new ConnectionToMySQL();
DataTable dtAcc = cnn.GetDataTable("SELECT d.pkid " +
" FROM journal_details d " +
" join accounts a on(d.acc_id = a.pkid) " +
" where a.Acc_no like '" + txtAccNo.Text.Trim() + "%'");
if (dtAcc != null && dtAcc.Rows.Count > 0)
{
glb_function.MsgBox("لايمكن حذف الحساب لارتباطه بعمليات في اليومية");
return;
}
dtAcc.Clear();
dtAcc = cnn.GetDataTable("SELECT pkid FROM accounts " +
" where parent_id = " + txtParentId.Text +
" and Acc_short_no > " + txtAccShoreNo.Text);
if (dtAcc != null && dtAcc.Rows.Count > 0)
{
glb_function.MsgBox("يوجد حساب بعد هذا الحساب" + "\n" + "لايمكن الحذف");
return;
}
if (glb_function.MsgBox("هل انت متاكد من اتمام عملية الحذف", "تنبية", true) == false)
{
return;
}
int icheck = cnn.TranDataToDB("delete from accounts where Acc_no like '" + txtAccNo.Text.Trim() + "%'");
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية الحذف");
return;
}
cnn.glb_commitTransaction();
glb_function.MsgBox("تمت عملية الحذف بنجاح");
tvAccounts.Nodes.Remove(tvAccounts.SelectedNode);
//FillAccountTree();
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (!CheckEntries())
{
return;
}
ConnectionToMySQL cnn = new ConnectionToMySQL();
DataTable dtTemplte = cnn.GetDataTable("select ifnull(max(b.pkid),0)+1 from FORMS_hd b");
txtSwid.Text = dtTemplte.Rows[0][0].ToString();
int icheck = cnn.TranDataToDB("insert into FORMS_hd values(" + txtSwid.Text + ",'" + txtAR_NAME.Text + "','" + txtEN_NAME.Text + "','" + (ckbMULTI_FORM_FOR_USER.IsChecked == true ? "1" : "0") + "','" + ((ListBoxItem)lstFormType.Items[lstFormType.Items.IndexOf(lstFormType.SelectedItem)]).Tag.ToString() + "','" + lstFormType.Text.Trim() + "')");
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء العملية");
return;
}
for (int i = 0; i < dgvProperities.Items.Count; i++)
{
if (glb_function.GetCellValue(ref dgvProperities, clmSwid.DisplayIndex, i) == "")
{
icheck = cnn.TranDataToDB("insert into FORMs_de values((select ifnull(max(b.pkid),0)+1 from FORMs_de b)," + txtSwid.Text + ",'" + glb_function.GetCellValue(ref dgvProperities, clmFieldType.DisplayIndex, i) + "','" + glb_function.GetCellValue(ref dgvProperities, clmFieldNameEn.DisplayIndex, i) + "','" + glb_function.GetCellValue(ref dgvProperities, clmFieldNameAr.DisplayIndex, i) + "'," + glb_function.GetCellValue(ref dgvProperities, clmListTypeId.DisplayIndex, i) + ",'" + glb_function.GetCellValue(ref dgvProperities, clmFreeList.DisplayIndex, i) + "','" + glb_function.GetCellValue(ref dgvProperities, clmNote.DisplayIndex, i) + "')");
if (icheck <= 0)
{
cnn.glb_RollbackTransaction();
glb_function.MsgBox("حدث خطأ اثناء العملية");
return;
}
}
}
cnn.glb_commitTransaction();
glb_function.MsgBox("تمت العملية بنجاح");
GetData(txtSwid.Text.Trim());
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (!CheckEntries())
{
return;
}
DataTable dtTemplte = new DataTable();
ConnectionToMySQL cnn = new ConnectionToMySQL();
int icheck = cnn.TranDataToDB("update FORMS_hd set AR_NAME='" + txtAR_NAME.Text + "',EN_NAME='" + txtEN_NAME.Text + "',MULTI_FORM_FOR_USER='******',form_type_en='" + lstFormType.SelectedValue.ToString() + "',form_type_ar='" + lstFormType.Text.Trim() + "' where pkid=" + txtPkid.Text);
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء العملية");
return;
}
for (int i = 0; i < dgvProperities.Rows.Count; i++)
{
if (dgvProperities[clmPkid.Index, i].Value.ToString() == "")
{
icheck = cnn.TranDataToDB("insert into FORMs_de values((select ifnull(max(b.pkid),0)+1 from FORMs_de b)," + txtPkid.Text + ",'" + dgvProperities[clmFieldType.Index, i].Value.ToString() + "','" + dgvProperities[clmFieldNameEn.Index, i].Value.ToString() + "','" + dgvProperities[clmFieldNameAr.Index, i].Value.ToString() + "'," + dgvProperities[clmListTypeId.Index, i].Value.ToString() + ",'" + dgvProperities[clmFreeList.Index, i].Value.ToString() + "','" + dgvProperities[clmNote.Index, i].Value.ToString() + "')");
if (icheck <= 0)
{
cnn.glb_RollbackTransaction();
glb_function.MsgBox("حدث خطأ اثناء العملية");
return;
}
}
}
cnn.glb_commitTransaction();
glb_function.MsgBox("تمت العملية بنجاح");
GetData(txtPkid.Text.Trim());
}
private void dgvCurrencies_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
if (e.ColumnIndex == clmUpdateCurrency.Index)
{
string strPkid = dgvCurrencies[clmPkid.Index, e.RowIndex].Value.ToString();
string strIsMainCurr = dgvCurrencies[clmMainCurr.Index, e.RowIndex].Value.ToString();
string strExhangeRate = dgvCurrencies[clmExchangeRate.Index, e.RowIndex].Value.ToString();
if (strIsMainCurr.Trim() == "1")
{
glb_function.MsgBox("لايمكن تغيير سعر صرف العملة الرئيسية");
GetCurrency();
return;
}
ConnectionToMySQL cnn = new ConnectionToMySQL();
int icheck = cnn.TranDataToDB("update currency set curr_change_rate=" + strExhangeRate + " where pkid=" + strPkid);
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية التعديل");
return;
}
cnn.glb_commitTransaction();
glb_function.MsgBox("تمت عملية التعديل بنجاح");
}
else if (clmExchangeRate.Index == e.ColumnIndex)
{
DataGridViewCell abc = dgvCurrencies.CurrentCell;
Rectangle RECT = dgvCurrencies.GetCellDisplayRectangle(abc.ColumnIndex, abc.RowIndex, true);
nmbEditor.W_ColumnName = e.ColumnIndex.ToString();
nmbEditor.Tag = e.RowIndex.ToString();
if (dgvCurrencies[clmExchangeRate.Index, e.RowIndex].Value == null || dgvCurrencies[clmExchangeRate.Index, e.RowIndex].Value.ToString() == "")
{
dgvCurrencies[clmExchangeRate.Index, e.RowIndex].Value = "0";
}
nmbEditor.Value = Convert.ToDecimal(dgvCurrencies[clmExchangeRate.Index, e.RowIndex].Value.ToString());
CtlLocation(RECT, nmbEditor);
}
}
private void btnPosting_Click(object sender, EventArgs e)
{
if (dgvEntries.Rows.Count > 0)
{
ConnectionToMySQL cnn = new ConnectionToMySQL();
int icheck = 0;
int iCount = 0;
for (int i = 0; i < dgvEntries.Rows.Count; i++)
{
if (dgvEntries[clmSelect.Index, i].Value == null || dgvEntries[clmSelect.Index, i].Value.ToString() == "False")
{
continue;
}
string strPkid = dgvEntries[clmPKid.Index, i].Value.ToString();
icheck = cnn.TranDataToDB("update journal_header set stat='مرحل' where pkid=" + strPkid);
iCount++;
if (icheck <= 0)
{
cnn.glb_RollbackTransaction();
glb_function.MsgBox("حدث خطأ اثناء عملية الترحيل");
return;
}
if (!glb_function.UpdateHistory("journal_header", "stat", strPkid, "فعال", "مرحل", "الحالة"))
{
cnn.glb_RollbackTransaction();
glb_function.MsgBox("حدث خطأ عند ادخال التعديل الى بيانات التتبع");
return;
}
}
if (iCount == 0)
{
glb_function.MsgBox("لم يتم تحديد اي مستند للترحيل");
}
else
{
cnn.glb_commitTransaction();
glb_function.MsgBox("تمت عملية الترحيل بنجاح");
GetUnPostingData();
ckbAll.Checked = false;
}
}
else
{
glb_function.MsgBox("لا توجد بيانات للترحيل");
}
}
private void UpdateAccount()
{
ConnectionToMySQL cnn = new ConnectionToMySQL();
int icheck = cnn.TranDataToDB("update accounts set " +
" Acc_Name='" + txtAccName.Text.Trim() + "'" +
",notes='" + txtAccNote.Text.Trim() + "'" +
" where pkid=" + txtPkid.Text);
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية التعديل");
return;
}
cnn.glb_commitTransaction();
glb_function.MsgBox("تمت عملية التعديل بنجاح");
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtPkid.Text.Trim() == "")
{
glb_function.MsgBox("الرجاء اختيار فرع");
return;
}
if (txtBranchNo.Text.Trim() == "")
{
glb_function.MsgBox("الرجاء ادخال رقم الفرع");
txtBranchNo.Focus();
return;
}
if (txtBranchName.Text.Trim() == "")
{
glb_function.MsgBox("الرجاء ادخال اسم الفرع");
txtBranchName.Focus();
return;
}
ConnectionToMySQL cnnSave = new ConnectionToMySQL();
int icheck = cnnSave.TranDataToDB("update branches " +
" set " +
" Branch_no='" + txtBranchNo.Text.Trim() + "'" +
",Branch_name='" + txtBranchName.Text.Trim() + "'" +
",notes='" + txtNote.Text.Trim() + "'" +
" where pkid=" + txtPkid.Text.Trim());
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية تعديل بيانات الفرع");
return;
}
cnnSave.glb_commitTransaction();
glb_function.MsgBox("تمت العملية بنجاح");
GetData(txtPkid.Text);
}
public static bool UpdateHistory(string strTableName, string strColName, string strPkid, string strOldValue, string strNewValue, string strColArName)
{
ConnectionToMySQL cnn = new ConnectionToMySQL();
int icheck = 0;
// insert into sales.USER_TEMPLET values((select ifnull(max(b.pkid),0)+1 from sales.USER_TEMPLET b),
icheck = cnn.TranDataToDB("insert into updatehistory values((select ifnull(max(b.pk),0)+1 from updatehistory b)," + glb_function.glb_strUserId + ",sysdate(),'" + strTableName + "','" + strColName + "'," + strPkid + ",'" + strOldValue + "','" + strNewValue + "','" + strColArName + "')");
if (icheck <= 0)
{
return(false);
}
cnn.glb_commitTransaction();
return(true);
}
private void button4_Click(object sender, EventArgs e)
{
glb_function.strDbCnnString = "server=localhost;port=3300;charset=utf8;database=ammar2018;userid=root;password=bigboss;SslMode=none;AllowPublicKeyRetrieval=True";
ConnectionToMySQL cnn = new ConnectionToMySQL();
int icheck = 0;
string strAmount = "";
for (int i = 0; i < myDataGrid1.Rows.Count; i++)
{
if (myDataGrid1[6, i].Value.ToString().Trim() == "0")
{
strAmount = "-" + myDataGrid1[7, i].Value.ToString().Trim();
}
else
{
strAmount = myDataGrid1[6, i].Value.ToString().Trim();
}
icheck = cnn.TranDataToDB("insert into journal_details values((select ifnull(max(b.pkid),0)+1 from journal_details b)" +
",'فعال'" +
",sysdate()" +
",1" +
"," + myDataGrid1[10, i].Value.ToString() +
",1" +
"," + myDataGrid1[3, i].Value.ToString() +
"," + strAmount +
"," + strAmount +
",1" +
",'" + myDataGrid1[11, i].Value.ToString() + "'" +
",'" + myDataGrid1[13, i].Value.ToString() + "'" +
")");
if (icheck <= 0)
{
cnn.glb_RollbackTransaction();
glb_function.MsgBox("Error");
return;
}
}
cnn.glb_commitTransaction();
glb_function.MsgBox("Save");
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (!CheckEntries())
{
return;
}
ConnectionToMySQL cnnSave = new ConnectionToMySQL();
DataTable dt = cnnSave.GetDataTable("(select ifnull(max(b.pkid),0)+1 from Items b)");
txtPkid.Text = dt.Rows[0][0].ToString();
int icheck = cnnSave.TranDataToDB("insert into Items " +
" values(" + txtPkid.Text + "" +
",'فعال'" +
",SYSDATE() " +
"," + glb_function.glb_strUserId +
",'" + lstItemGroup.Text.Trim() + "'" +
",'" + txtItemNo.Text.Trim() + "'" +
",'" + txtItemName.Text.Trim() + "'" +
",'" + lstItemType.Text.Trim() + "'" +
"," + lstCostCurrency.SelectedValue.ToString() +
"," + nmbCostValue.Value.ToString() +
"," + nmbCostValue_yr.Value.ToString() +
"," + lstSellingPriceCurrency.SelectedValue.ToString() +
"," + nmbSellingPriceValue.Value.ToString() +
"," + nmbSellingPrice_yr.Value.ToString() +
"," + (ckbSellingPriceEditable.IsChecked == true?"1":"0") +
",'" + txtItemNote.Text.Trim() + "'" +
"," + (lstVendor.SelectedIndex == -1?"null": lstVendor.SelectedValue.ToString()) +
")");
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية حفظ بيانات الصنف");
return;
}
cnnSave.glb_commitTransaction();
glb_function.MsgBox("تمت العملية بنجاح");
GetData(txtPkid.Text);
}
private void btnUpdate_Click(object sender, RoutedEventArgs e)
{
if (!CheckEntries())
{
return;
}
ConnectionToMySQL cnnSave = new ConnectionToMySQL();
int icheck = cnnSave.TranDataToDB("insert into Items set " +
" created_user="******",itemgroup='" + lstItemGroup.Text.Trim() + "'" +
",itemno='" + txtItemNo.Text.Trim() + "'" +
",itemname'" + txtItemName.Text.Trim() + "'" +
",itemtype='" + lstItemType.Text.Trim() + "'" +
",cost_currency=" + lstCostCurrency.SelectedValue.ToString() +
",cost_Value=" + nmbCostValue.Value.ToString() +
",cost_Value_yr=" + nmbCostValue_yr.Value.ToString() +
",sellingPrice_currency=" + lstSellingPriceCurrency.SelectedValue.ToString() +
",sellingPrice_value=" + nmbSellingPriceValue.Value.ToString() +
",sellingPrice_yr=" + nmbSellingPrice_yr.Value.ToString() +
",sellingPrice_editable=" + (ckbSellingPriceEditable.IsChecked == true ? "1" : "0") +
",itemnote='" + txtItemNote.Text.Trim() + "'" +
",vendor_id=" + (lstVendor.SelectedIndex == -1 ? "null" : lstVendor.SelectedValue.ToString()) +
" where pkid=" + txtPkid.Text);
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية تعديل بيانات الصنف");
return;
}
cnnSave.glb_commitTransaction();
glb_function.MsgBox("تمت العملية بنجاح");
GetData(txtPkid.Text);
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtExpName.Text.Trim() == "")
{
glb_function.MsgBox("الرجاء ادخال اسم المصروف");
txtExpName.Focus();
return;
}
if (lstAccNo.SelectedIndex == -1 || lstAccName.SelectedIndex == -1)
{
glb_function.MsgBox("الرجاء اختيار الحساب");
lstAccNo.Focus();
return;
}
ConnectionToMySQL cnn = new ConnectionToMySQL();
int icheck = cnn.TranDataToDB("insert into purchase_expensses " +
" values((select ifnull(max(b.pkid),0)+1 from purchase_expensses b)" +
",'" + txtExpName.Text.Trim() + "'" +
"," + lstAccNo.SelectedValue.ToString() +
",'" + lstCalcType.Text.Trim() + "'" +
"," + nmbExpValue.Value.ToString() +
")");
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء اضافة المصروف");
return;
}
cnn.glb_commitTransaction();
glb_function.MsgBox("تمت اضافة المصروف بنجاح");
lstAccNo.SelectedIndex = -1;
lstAccName.SelectedIndex = -1;
txtExpName.Text = "";
lstCalcType.Text = "مبلغ";
nmbExpValue.Value = 0;
GetData();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!CheckEntries())
{
return;
}
ConnectionToMySQL cnnSave = new ConnectionToMySQL();
DataTable dt = cnnSave.GetDataTable("(select ifnull(max(b.pkid),0)+1 from vendors b)");
txtPkid.Text = dt.Rows[0][0].ToString();
int icheck = cnnSave.TranDataToDB("insert into vendors " +
" values(" + txtPkid.Text + "" +
",'فعال'" +
",SYSDATE() " +
"," + glb_function.glb_strUserId +
",'" + txtVendorNo.Text.Trim() + "'" +
",'" + txtVendorName.Text.Trim() + "'" +
",'" + txtAddress1.Text.Trim() + "'" +
",'" + txtAddress2.Text.Trim() + "'" +
",'" + txtTel1.Text.Trim() + "'" +
",'" + txtTel2.Text.Trim() + "'" +
"," + (lstAccNo.SelectedIndex == -1 ? "null" : lstAccNo.SelectedValue.ToString()) +
",'" + txtVendorNote.Text.Trim() + "'" +
")");
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء عملية حفظ بيانات المورد");
return;
}
cnnSave.glb_commitTransaction();
glb_function.MsgBox("تمت العملية بنجاح");
GetData(txtPkid.Text);
}
