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; } }