public void btnSave_Click(System.Object sender, System.EventArgs e)
{
if (txtEmployeeName.Text.Trim() == "")
{
MessageBox.Show("من فضلك ادخل الموظف", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (txtShiftOrderNo.Text.Trim() == "")
{
MessageBox.Show("من فضلك ادخل الوردية", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
//try
//{
string TransACTIONID = Name + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Millisecond;
mTable.ExecuteNonQuery("BEGIN TransACTION " + TransACTIONID);
if (mTable.find("ID=" + mID))
{
mTable.Add_New();
mTable.SetFiled("Year", Settings.CurrentYear);
mTable.SetFiled("Branch_ID", Settings.CurrentBranch_ID);
mTable.SetFiled("TransDate", Convert.ToDateTime(txtTransDate.Text + " " + dtpAttTime.Text));
mTable.SetFiled("ShiftOrderNo", txtShiftOrderNo.Text);
mTable.SetFiled("EmployeeCode", txtEmployeeCode.Text);
mTable.SetFiled("TransType", radioButton1.Checked ? 1 : 0);
mTable["dwYear"] = txtTransDate.Value.Year;
mTable["dwMonth"] = txtTransDate.Value.Month;
mTable["dwDay"] = txtTransDate.Value.Day;
mTable["dwHour"] = dtpAttTime.Value.Hour;
mTable["dwMinute"] = dtpAttTime.Value.Minute;
mTable["dwSecond"] = dtpAttTime.Value.Second;
mTable.Update("ID=" + mID);
//---------------------------------------
mTable2.Add_New();
mTable2.SetFiled("ID", mID);
mTable2.SetFiled("Year", Settings.CurrentYear);
mTable2.SetFiled("Branch_ID", Settings.CurrentBranch_ID);
mTable2.SetFiled("TransDate", Convert.ToDateTime(txtTransDate.Text + " " + dtpAttTime.Text));
mTable2.SetFiled("ShiftOrderNo", txtShiftOrderNo.Text);
mTable2.SetFiled("EmployeeCode", txtEmployeeCode.Text);
mTable2.SetFiled("UserCode", Settings.CurrentUser_ID);
mTable2.SetFiled("TransType", radioButton1.Checked ? 1 : 0);
mTable2.SetFiled("TransTypeOld", radioButton1.Tag + "" == "true" ? 1 : 0);
mTable2.SetFiled("TransDateOld", txtTransDate.Tag);
mTable2.Update();
}
else
{
mTable.Add_New();
mTable.SetFiled("Year", Settings.CurrentYear);
mTable.SetFiled("Branch_ID", Settings.CurrentBranch_ID);
mTable.SetFiled("TransDate", Convert.ToDateTime(txtTransDate.Text + " " + dtpAttTime.Text));
mTable.SetFiled("ShiftOrderNo", txtShiftOrderNo.Text);
mTable.SetFiled("EmployeeCode", txtEmployeeCode.Text);
mTable.SetFiled("TransType", radioButton1.Checked ? 1 : 0);
mTable.Update();
}
mTable.ExecuteNonQuery("COMMIT TransACTION " + TransACTIONID);
NewRecord = false;
InProcess = false;
if (SaveMsgDontShow)
{
btnNew_Click(null, null);
}
else
if (MessageBox.Show("تم حفظ البيانات. ", "حفظ", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
{
btnNew_Click(null, null);
}
//}
//catch (Exception Ex)
//{
// MessageBox.Show(Ex.Message);
//}
}
public void btnSave_Click(System.Object sender, System.EventArgs e)
{
if (txtCode.Text.Trim() == "")
{
MessageBox.Show("من فضلك ادخل الكود", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (txtName.Text.Trim() == "")
{
MessageBox.Show("من فضلك ادخل الاسم", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (NewRecord && mTable.find("Code=N\'" + txtCode.Text.Trim() + "\'"))
{
MessageBox.Show("الكود موجود من قبل...ولا يمكن اضافة جديد بهذا الكود", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtCode.Text = "";
return;
}
try
{
string TransACTIONID = Name + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Millisecond;
mTable.ExecuteNonQuery("BEGIN TransACTION " + TransACTIONID);
InProcess = true;
mTable.Add_New();
mTable.SetFiled("Code", (BasicDataNo ? Convert.ToInt64(txtCode.Text).ToString() : txtCode.Text));
mTable.SetFiled("Name", txtName.Text);
if (where == "main=1")
{
mTable.SetFiled("Main", 1);
}
//mTable.SetFiled("MainNo", txtMainCode.Text);
mTable.Update("Code=N\'" + txtCode.Text.Trim() + "\'");
mTable.ExecuteNonQuery("COMMIT TransACTION " + TransACTIONID);
NewRecord = false;
InProcess = false;
if (SaveMsgDontShow)
{
btnNew_Click(null, null);
}
else
if (MessageBox.Show("تم حفظ البيانات...هل تريد مستند جديد؟", "حفظ", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
btnNew_Click(null, null);
}
else
{
Retrieve();
}
}
catch (Exception Ex)
{
if (InProcess)
{
////mTable.ExecuteNonQuery("Rollback TransACTION " + TransACTIONID);
InProcess = false;
}
MessageBox.Show(Ex.Message);
}
}
public void btnSave_Click(System.Object sender, System.EventArgs e)
{
//-----------------------------------------------
if (Settings.CurrentBox == "")
{
MessageBox.Show("لا يوجد كاشير علي المستخدم الحالي....من فضلك حاول مرة اخري", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
//if (!Pub.ShiftIsOpen(ShiftOrderNo))
//{
// MessageBox.Show("تم قفل الوردية الحالية ولا يمكن الاستمرار من فضل اغلاق البرنامج ثم حاول مرة اخرى", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
// return;
//}
exx :;
Settings.ExecuteReader("select * from ShiftsOpening2 where OrderNo=" + ShiftOrderNo + " and Year=" + Settings.CurrentYear + " and Branch_ID=N'" + Settings.CurrentBranch_ID + "' and BoxCode=N'" + Settings.CurrentBox + "'");
if (Settings.DR.HasRows == false)
{
if (MessageBox.Show("سوف يتم فتح الكاشير الحالي علي الوردية الحالية", "", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
//FrmKasherOpen frm = new FrmKasherOpen();
//frm.ShowDialog();
goto exx;
}
else
{
return;
}
}
else
{
if (Settings.DR["BoxStatus"].ToString() == "1")
{
MessageBox.Show("تم قفل الكاشير ولا يمكن الاستمرار", "", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
return;
}
}
//-----------------------------------------------
if (txtName.Text.Trim() == "")
{
MessageBox.Show(" من فضلك ادخل الموظف", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
//s = " Year=" + Pub.CurrentYear + " and Branch_ID=N'" + Pub.CurrentBranch
// + "' and ShiftOrderNo=" + ShiftOrderNo + " and BoxCode=N'" + Pub.CurrentBox
// + "' and EmployeesCode=N'" + txtCode.Text.Trim() + "'";
//Pub.ExecuteReader("select OrderNo from PaymentsEmployeesBetween where " + s);
//if (Pub.DR.HasRows)
//{
// MessageBox.Show(" هذا الموظف تم عليه حركة مدفوعات علي هذه الوردية", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
// return;
//}
//if (NewRecord == false && Pub.PaymentsEditDelete == false)
//{
// MessageBox.Show("هذا المستخدم لايستطيع التعديل ", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
// if (Pub.ManagerPassword("PaymentsEditDelete") == false)
// {
// MessageBox.Show("هذا المستخدم لايستطيع التعديل من فضلك حاول مرة اخرى", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
// return;
// }
//}
if (txtTotal.Text == "")
{
MessageBox.Show("لا يوجد مبالغ....لايمكن الحفظ", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
try
{
mTable.ExecuteNonQuery("BEGIN TransACTION " + Name);
if (NewRecord)
{
s = " Year=" + Settings.CurrentYear + " and Branch_ID=N'" + Settings.CurrentBranch_ID + "' and ShiftOrderNo=" + ShiftOrderNo + " and BoxCode=N'" + Settings.CurrentBox + "' and OrderNo=" + txtOrderNo.Text;
Settings.ExecuteReader("select OrderNo from PaymentsEmployeesBetween where " + s);
if (Settings.DR.HasRows)
{
s = " Year=" + Settings.CurrentYear + " and Branch_ID=N'" + Settings.CurrentBranch_ID + "' and ShiftOrderNo=" + ShiftOrderNo + " and BoxCode=N'" + Settings.CurrentBox + "'";
txtOrderNo.Text = mTable.Get_New("orderNo", s);
}
}
mTable.Add_New();
mTable.SetFiled("Year", Settings.CurrentYear);
mTable.SetFiled("Branch_ID", Settings.CurrentBranch_ID);
mTable.SetFiled("BoxCode", Settings.CurrentBox);
mTable.SetFiled("OrderNo", txtOrderNo.Text);
mTable.SetFiled(dtpOrderDate);
mTable.SetFiled("ShiftOrderNo", ShiftOrderNo);
mTable.SetFiled("EmployeesCode", txtCode.Text);
mTable.SetFiled("Total", txtTotal.Text);
mTable.SetFiled("Posted", 1);
s = " Year=" + Settings.CurrentYear + " and Branch_ID=N'" + Settings.CurrentBranch_ID + "' and ShiftOrderNo=" + ShiftOrderNo + " and BoxCode=N'" + Settings.CurrentBox + "' and OrderNo=" + txtOrderNo.Text;
mTable.Update(s);
//------------------------------------
s = " Year=" + Settings.CurrentYear + " and Branch_ID=N'" + Settings.CurrentBranch_ID + "' and ShiftOrderNo=" + ShiftOrderNo + " and BoxCode=N'" + Settings.CurrentBox + "' and OrderNo=" + txtOrderNo.Text;
mTable2.Delete(s);
for (int i = 0; i < grd.Rows.Count; i++)
{
mTable2.Add_New();
mTable2.SetFiled("Year", Settings.CurrentYear);
mTable2.SetFiled("Branch_ID", Settings.CurrentBranch_ID);
mTable2.SetFiled("BoxCode", Settings.CurrentBox);
mTable2.SetFiled("OrderNo", txtOrderNo.Text);
mTable2.SetFiled("ShiftOrderNo", ShiftOrderNo);
mTable2.SetFiled("Ser", i);
mTable2.SetFiled("ShiftOrderNo2", grd.Rows[i].Cells["OrderNo"].Value.ToString());
mTable2.SetFiled("OrderDate2", Convert.ToDateTime(grd.Rows[i].Cells["OrderDate"].Value));
if (grd.Rows[i].Cells["TimeIn"].Value.ToString() != "")
{
mTable2.SetFiled("AttIn", Convert.ToDateTime(grd.Rows[i].Cells["TimeIn"].Value));
}
else
{
mTable2.SetFiled("AttIn", DBNull.Value);
}
if (grd.Rows[i].Cells["TIMEOUT"].Value.ToString() != "")
{
mTable2.SetFiled("AttOUT", Convert.ToDateTime(grd.Rows[i].Cells["TIMEOUT"].Value));
}
else
{
mTable2.SetFiled("AttOUT", DBNull.Value);
}
mTable2.SetFiled("ActulMinute", grd.Rows[i].Cells["ActulMinute"].Value);
mTable2.SetFiled("Salary", grd.Rows[i].Cells["Salary"].Value);
mTable2.Update();
}
mTable.ExecuteNonQuery("COMMIT TransACTION " + Name);
NewRecord = false;
if (SaveMsgDontShow)
{
btnNew_Click(null, null);
}
else
if (MessageBox.Show("تم حفظ البيانات...هل تريد مستند جديد؟", "حفظ", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
btnNew_Click(null, null);
}
else
{
Retrieve();
}
}
catch (Exception Ex)
{
//mTable.ExecuteNonQuery("Rollback TransACTION " + Name);
MessageBox.Show(Ex.Message);
return;
}
}