private void FrmEmployees_Load(object sender, EventArgs e) { Pic.Properties.SizeMode = PictureSizeMode.Stretch; Setings.View(); SaveMsgDontShow = Convert.ToBoolean(Setings.GetFiled("SaveMsgDontShow")); BasicDataNo = Convert.ToBoolean(Setings.GetFiled("BasicDataNo")); var ht = new Hashtable(); ht.Add("1", "مبلغ"); ht.Add("2", "نسبة من الراتب الاساسى"); ht.Add("3", "نسبة من الراتب المتغير"); //grdDeduction.Cols["Type"].DataMap = ht; //grdMerit.Cols["Type"].DataMap = ht; ///************************* //grdHoliDays[1, "EnglishName"] = "Saturday"; //grdHoliDays[1, "ArabicName"] = "السبت"; //grdHoliDays[2, "EnglishName"] = "Sunday"; //grdHoliDays[2, "ArabicName"] = "الأحد"; //grdHoliDays[3, "EnglishName"] = "Monday"; //grdHoliDays[3, "ArabicName"] = "الإثنين"; //grdHoliDays[4, "EnglishName"] = "Tuesday"; //grdHoliDays[4, "ArabicName"] = "الثلاثاء"; //grdHoliDays[5, "EnglishName"] = "Wednesday"; //grdHoliDays[5, "ArabicName"] = "الأربعاء"; //grdHoliDays[6, "EnglishName"] = "Thursday"; //grdHoliDays[6, "ArabicName"] = "الخميس"; //grdHoliDays[7, "EnglishName"] = "Friday"; //grdHoliDays[7, "ArabicName"] = "الجمعة"; ///************************* FillShifts(); FillDeduction(); FillMerit(); Tree1.FillTree(); FillCities(); FillReligion(); FillHealthOffices(); FillManagements(); FillJobs(); FillDepts(); FillQualification(); var v = new MATRIX("Employees"); v.FillComboBox(cmbManager); btnNew_Click(null, null); Tree1.CheckEdit1.Checked = true; }
public void Retrieve() { NewRecord = false; s = " Year=" + Settings.CurrentYear + " and OrderNo=" + txtOrderNo.Text; mTable.View(s); if (!mTable.DR.HasRows) { btnNew_Click(null, null); return; } btnSave.Enabled = true; btnDelete.Enabled = true; btnPost.Enabled = true; label7.Text = "تحت الاعتماد"; if (mTable.GetFiled("Posted") == "1") { btnSave.Enabled = false; btnDelete.Enabled = false; btnPost.Enabled = false; label7.Text = "تم الترحيل"; } if (mTable.GetFiled("Posted") == "2") { btnSave.Enabled = false; btnDelete.Enabled = false; btnPost.Enabled = false; label7.Text = "الغاء"; } txtOrderDate.Text = mTable.GetFiled("OrderDate"); }
private void FrmJobs_Load(object sender, EventArgs e) { Setings.View(); SaveMsgDontShow = Convert.ToBoolean(Setings.GetFiled("SaveMsgDontShow")); BasicDataNo = Convert.ToBoolean(Setings.GetFiled("BasicDataNo")); btnNew_Click(null, null); }
private void FrmSetings_Load(object sender, EventArgs e) { HRSetings.View(); if (HRSetings.DR.HasRows) { txtMonthStart.Value = (DateTime)HRSetings["MonthStart"]; txtMonthEnd.Value = (DateTime)HRSetings["MonthEnd"]; } }
private void FrmDeductions_Load(object sender, EventArgs e) { //Settings.OpenShift(); Setings.View(); SaveMsgDontShow = Convert.ToBoolean(Setings.GetFiled("SaveMsgDontShow")); BasicDataNo = Convert.ToBoolean(Setings.GetFiled("BasicDataNo")); FillDeductionsType(); FillEmployees(); btnNew_Click(null, null); }
private void Retrieve() { NewRecord = false; mTable.View("Code=N\'" + txtCode.Text.Trim() + "\'"); if (!mTable.DR.HasRows) { btnNew_Click(null, null); return; } txtCode.Text = mTable.GetFiled("Code"); txtName.Text = mTable.GetFiled("Name"); }
private void Retrieve() { NewRecord = false; mTable.View("Code=N\'" + txtEmployeeCode.Text.Trim() + "\'"); if (!mTable.DR.HasRows) { btnNew_Click(null, null); return; } txtEmployeeName.Text = mTable.GetFiled("Name"); //Convert.ToBoolean(mTable.GetFiled("Type")) }
private void cmbMachines_SelectedIndexChanged(object sender, EventArgs e) { var m = new MATRIX("Machiens"); m.View("Code='" + cmbMachines.SelectedValue + "'"); if (m.DR.HasRows) { txtIP.Text = (string)m["ip"]; txtPort.Text = (string)m["Port"]; } else { txtIP.Text = ""; txtPort.Text = ""; } }
public void Retrieve() { NewRecord = false; s = " Year=" + Settings.CurrentYear + " and OrderNo=" + txtOrderNo.Text; mTable.View(s); if (!mTable.DR.HasRows) { btnNew_Click(null, null); return; } btnSave.Enabled = true; btnDelete.Enabled = true; btnPost.Enabled = true; label7.Text = "تحت الاعتماد"; if (mTable.GetFiled("Posted") == "1") { btnSave.Enabled = false; btnDelete.Enabled = false; btnPost.Enabled = false; label7.Text = "تم الترحيل"; } if (mTable.GetFiled("Posted") == "2") { btnSave.Enabled = false; btnDelete.Enabled = false; btnPost.Enabled = false; label7.Text = "الغاء"; } txtRem.Text = mTable.GetFiled("Rem"); //txtAmount.Text = mTable.GetFiled("Amount"); txtOrderDate.Text = (string)mTable["OrderDate"]; txtStartDate.Text = (string)mTable["StartDate"]; txtEndDate.Text = (string)mTable["EndDate"]; chkWithoutSalary.Checked = (bool)mTable["WithoutSalary"]; DaysCount(); cmbHoliDaysType.SelectedValue = mTable["HoliDaysCode"]; cmbEmployees.SelectedValue = mTable["EmployeeCode"]; }
public void Retrieve() { NewRecord = false; s = " Year=" + Settings.CurrentYear + " and OrderNo=" + txtOrderNo.Text; mTable.View(s); if (!mTable.DR.HasRows) { btnNew_Click(null, null); return; } btnSave.Enabled = true; btnDelete.Enabled = true; btnPost.Enabled = true; label7.Text = "تحت الاعتماد"; if (mTable.GetFiled("Posted") == "1") { btnSave.Enabled = false; btnDelete.Enabled = false; btnPost.Enabled = false; label7.Text = "تم الترحيل"; } if (mTable.GetFiled("Posted") == "2") { btnSave.Enabled = false; btnDelete.Enabled = false; btnPost.Enabled = false; label7.Text = "الغاء"; } txtRem.Text = mTable.GetFiled("Rem"); txtAmount.Text = mTable.GetFiled("Amount"); txtOrderDate.Text = mTable.GetFiled("OrderDate"); cmbDeductionsType.SelectedValue = mTable["DeductionsCode"]; cmbEmployees.SelectedValue = mTable["EmployeeCode"]; }
private void FrmPaymentsEmployeesBetween_Load(object sender, EventArgs e) { //Pub.OpenShift(); Setings.View(); SaveMsgDontShow = Convert.ToBoolean(Setings.GetFiled("SaveMsgDontShow")); BasicDataNo = Convert.ToBoolean(Setings.GetFiled("BasicDataNo")); EmployeesTimeLate = int.Parse(Setings.GetFiled("EmployeesTimeLate")); s = "select *,Kasher=(SELECT NAME FROM dbo.Box WHERE Code =N'" + Settings.CurrentBox + "'),ShiftName=(SELECT NAME FROM dbo.Shifts WHERE Code =ShiftsOpening.ShiftCode ) FROM ShiftsOpening"; s += " WHERE (Branch_ID = N'" + Settings.CurrentBranch_ID + "')"; s += " AND ( Year = " + Settings.CurrentYear + " ) AND ShiftStatus=0"; Settings.ExecuteReader(s); if (Settings.DR.HasRows) { dtpOrderDate.Text = Settings.DR["Orderdate"].ToString(); ShiftOrderNo = Settings.DR["OrderNo"].ToString(); textBox1.Text = Settings.DR["Kasher"].ToString(); textBox2.Text = Settings.DR["ShiftName"].ToString(); } btnNew_Click(null, null); }
public void FillTree(string Find = "") { if (CheckEdit1.Checked == true) { TreeList1.Nodes.Clear(); TreeList1.BeginUnboundLoad(); Setings.View(); if (Convert.ToBoolean(Setings.GetFiled("BasicDataNo"))) { Sql = ("Select Code , CONVERT(INT,code) T_Code , Name,Main , MainNo From " + MasterTable + ((MasterWhere + "".Trim() != "") ? " Where " + MasterWhere : " order by CONVERT(INT, Code) ")); } else { Sql = ("Select Code , Code T_Code,Name, Main,MainNo From " + MasterTable + ((MasterWhere + "".Trim() != "") ? " Where " + MasterWhere : " order by Code")); } DataTable DT = new DataTable(); try { Settings.DR.Close(); } catch (Exception) { } TreeList1.SelectImageList = ImageList1; Settings.CMD.CommandText = Sql; try { Settings.DR = Settings.CMD.ExecuteReader(); DT.Load(Settings.DR); TreeList1.DataSource = DT; TreeList1.KeyFieldName = "Code"; TreeList1.ParentFieldName = "MainNo"; } catch (Exception) { if (Convert.ToBoolean(Setings.GetFiled("BasicDataNo"))) { Settings.CMD.CommandText = "Select CONVERT(INT,Code ) code,CONVERT(INT,code ) T_Code,Name From " + MasterTable + " order by CONVERT(INT,code )"; } else { Settings.CMD.CommandText = "Select Code , code T_Code,Name From " + MasterTable + " order by code "; } Settings.DR = Settings.CMD.ExecuteReader(); int x = 0; while (Settings.DR.Read()) { TreeListNode P = null; TreeListNode xNode = TreeList1.AppendNode(new object(), P); xNode.SetValue(0, Settings.DR["Code"]); xNode.SetValue(1, Settings.DR["Name"]); x++; } } TreeList1.EndUnboundLoad(); } else { TreeList1.Nodes.Clear(); } if (Find.Trim() != "") { TreeList1.FocusedNode = TreeList1.FindNodeByFieldValue("Code", Find); //var node = TreeList1.FindNodeByFieldValue("T_Code",Find ); // if (node != null) // { // node.Expanded = true; // node.Visible = true; // TreeList1.FocusedNode = node; // } } }
private void Retrieve() { NewRecord = false; mTable.View("Code=N\'" + txtCode.Text.Trim() + "\'"); if (!mTable.DR.HasRows) { btnNew_Click(null, null); return; } txtName.Text = "" + mTable["Name"]; txtFingerPrintCode.Text = mTable["FingerPrintCode"] + ""; cmbGender.SelectedIndex = int.Parse("0" + mTable["Gender"]); cmbReligionCode.SelectedValue = mTable["ReligionCode"] + ""; txtDateofBirth.Text = mTable["DateofBirth"] + ""; txtPlaceofBirth.Text = mTable["PlaceofBirth"] + ""; txtMotherName.Text = "" + mTable["MotherName"] + ""; txtFatherName.Text = "" + mTable["FatherName"]; cmbHealthOfficecode.SelectedValue = "" + mTable["HealthOfficecode"]; txtNationalID.Text = "" + mTable["NationalID"]; txtNationalIDDate.Text = "" + mTable["NationalIDDate"]; txtInusranceID.Text = "" + mTable["InusranceID"]; cmbMaterialState.SelectedIndex = int.Parse("0" + mTable["MaterialState"]); cmbMilitaryService.SelectedIndex = int.Parse("0" + mTable["MilitaryService"]); //-------------------- txtHourPrice.Text = mTable["HourPrice"].ToString(); txtAddress.Text = "" + mTable["Address"]; txtTel1.Text = "" + mTable["Tel1"]; txtTel2.Text = "" + mTable["Tel2"]; txtMobile1.Text = "" + mTable["Mobile1"]; txtMobile2.Text = "" + mTable["Mobile2"]; txtEmail.Text = "" + mTable["Email"]; cmbCity.SelectedValue = "" + mTable["CityCode"]; //-------------------- txtVariableSalary.Text = "" + mTable["VariableSalary"]; txtBasicSalary.Text = "" + mTable["BasicSalary"]; cmbJobs.SelectedValue = "" + mTable["JobCode"]; cmbDepts.SelectedValue = "" + mTable["DeptCode"]; cmbManagements.SelectedValue = "" + mTable["ManagementCode"]; cmbQualification.SelectedValue = "" + mTable["Qualification"]; txtSpecialization.Text = "" + mTable["Specialization"]; cmbWorkStatus.SelectedIndex = int.Parse("0" + mTable["WorkStatus"]); mTable.GetFiled(dtbDateofLeavingWork); mTable.GetFiled(dtpDateofAppointment); try { byte[] ap1 = (byte[])mTable.DR["EmployeePicture"]; var ms = new MemoryStream(ap1); Pic.Image = Image.FromStream(ms); ms.Close(); } catch (Exception) { Pic.Image = null; } //-------------------- cmbManager.SelectedValue = "" + mTable["Manager"]; //grdShifts.Rows.Count = 1; //var dr = Settings.GetDataTable(string.Format("select ShiftCode from EmployeesShifts where Employeecode='{0}'", txtCode.Text)); //while (dr.Read()) //{ // grdShifts.Rows.Add(); // grdShifts[grdShifts.Rows.Count - 1, "ShiftName"] = dr["ShiftCode"]; //} //grdShifts.Rows.Add(); //--------------------- //for (int i = 0; i < grdHoliDays.Rows.Count; i++) //{ // grdHoliDays[i, "chk"] = false; //} //dr = Settings.GetDataTable(string.Format("select EnglishName from EmployeesHoliDays where Employeecode='{0}'", txtCode.Text)); //while (dr.Read()) //{ // int i = grdHoliDays.FindRow(dr["EnglishName"], 1, grdHoliDays.Cols["EnglishName"].Index, false); // grdHoliDays[i, "chk"] = true; //} ////--------------------- //dr = Settings.GetDataTable(string.Format("SELECT Code,Type, Qty, Value FROM dbo.Employees2 where DataType=1 and Employeecode='{0}'", txtCode.Text)); //grdDeduction.Rows.Count = 1; //while (dr.Read()) //{// grdShifts[grdShifts.Rows.Count - 1, "ShiftName"] = dr["ShiftCode"]; // grdDeduction.Rows.Add(); // grdDeduction[grdDeduction.Rows.Count - 1, "DeductiontName"] = dr["Code"]; // grdDeduction[grdDeduction.Rows.Count - 1, "Type"] = dr["Type"]; // grdDeduction[grdDeduction.Rows.Count - 1, "Qty"] = dr["Qty"]; // grdDeduction[grdDeduction.Rows.Count - 1, "Value"] = dr["Value"]; //} //grdDeduction.Rows.Add(); //dr = Settings.GetDataTable(string.Format("SELECT Code,Type,Qty,Value FROM dbo.Employees2 where DataType=2 and Employeecode='{0}'", txtCode.Text)); //grdMerit.Rows.Count = 1; //while (dr.Read()) //{ // grdMerit.Rows.Add(); // grdMerit[grdMerit.Rows.Count - 1, "MerittName"] = dr["Code"]; // grdMerit[grdMerit.Rows.Count - 1, "Type"] = dr["Type"]; // grdMerit[grdMerit.Rows.Count - 1, "Qty"] = dr["Qty"]; // grdMerit[grdMerit.Rows.Count - 1, "Value"] = dr["Value"]; //} //grdMerit.Rows.Add(); pnlPic.Controls.Clear(); try { Settings.DR.Close(); } catch (Exception) { } Settings.CMD.CommandText = string.Format("select DocPic from EmployeesDocuments where Employeecode='{0}'", txtCode.Text); Settings.DR = Settings.CMD.ExecuteReader(); while (Settings.DR.Read()) { var n = new PictureBox(); n.BackgroundImageLayout = ImageLayout.Stretch; try { byte[] ap = (byte[])(Settings.DR["DocPic"]); var ms = new MemoryStream(ap); n.Image = Image.FromStream(ms); n.SizeMode = PictureBoxSizeMode.StretchImage; n.BorderStyle = BorderStyle.Fixed3D; ms.Close(); } catch (Exception) { n.BackgroundImage = null; } //n.Size = new Size(175, 175); n.ContextMenuStrip = contextMenuStrip1; n.DoubleClick -= new EventHandler(this.Pic_Click); n.DoubleClick += new EventHandler(this.Pic_Click); pnlPic.Controls.Add(n); } }
public void Retrieve() { NewRecord = false; s = " Year=" + Settings.CurrentYear + " and Branch_ID=N'" + Settings.CurrentBranch_ID + "' and ShiftOrderNo=" + ShiftOrderNo + " and BoxCode=N'" + Settings.CurrentBox + "' and OrderNo=" + txtOrderNo.Text; mTable.View(s); if (!mTable.DR.HasRows) { btnNew_Click(null, null); return; } if (mTable.GetFiled("Posted") == "1") { btnSave.Enabled = true; btnDelete.Enabled = true; label7.Text = "تم الحفظ"; } else if (mTable.GetFiled("Posted") == "2") { btnSave.Enabled = false; btnDelete.Enabled = false; label7.Text = "الغاء"; } dtpOrderDate.Text = mTable.GetFiled("OrderDate"); txtCode.Text = mTable.GetFiled("EmployeesCode"); Employees.View("Code=N'" + txtCode.Text + "'"); txtName.Text = Employees.GetFiled("name"); s = ""; s += "SELECT ShiftOrderNo2, \n"; s += " CONVERT(NVARCHAR(10), OrderDate2, 111) AS OrderDate, \n"; s += " AttIn, \n"; s += " AttOUT, \n"; s += " RIGHT(CONVERT(CHAR(20), PaymentsEmployeesBetween2.AttIn , 22), 11) TimeInm, \n"; s += " RIGHT(CONVERT(CHAR(20), PaymentsEmployeesBetween2.AttOUT , 22), 11) TIMEOUTm, \n"; s += " ActulMinute, \n"; s += " Salary \n"; s += "FROM dbo.PaymentsEmployeesBetween2 "; s += " where Year=" + Settings.CurrentYear + " and Branch_ID=N'" + Settings.CurrentBranch_ID + "' and ShiftOrderNo=" + ShiftOrderNo + " and BoxCode=N'" + Settings.CurrentBox + "' and OrderNo=" + txtOrderNo.Text; grd.Rows.Clear(); try { Settings.DR.Close(); }catch (Exception) { } Settings.CMD.CommandText = s; Settings.DR = Settings.CMD.ExecuteReader(); while (Settings.DR.Read()) { grd.Rows.Add(); grd.Rows[grd.Rows.Count - 1].Cells["OrderNo"].Value = Settings.DR["ShiftOrderNo2"].ToString(); grd.Rows[grd.Rows.Count - 1].Cells["OrderDate"].Value = Settings.DR["OrderDate"].ToString(); grd.Rows[grd.Rows.Count - 1].Cells["TimeIn"].Value = Settings.DR["AttIn"].ToString(); grd.Rows[grd.Rows.Count - 1].Cells["TIMEOUT"].Value = Settings.DR["AttIn"].ToString(); grd.Rows[grd.Rows.Count - 1].Cells["ActulMinute"].Value = Settings.DR["ActulMinute"].ToString(); double X = Math.Round(double.Parse("0" + Settings.DR["ActulMinute"].ToString()) / 60, 2); double Y = (int)X; TimeSpan span = TimeSpan.FromMinutes(X * 60); grd.Rows[grd.Rows.Count - 1].Cells["ActulMinutem"].Value = span.ToString(@"hh\:mm"); grd.Rows[grd.Rows.Count - 1].Cells["TimeInm"].Value = Settings.DR["TimeInm"].ToString(); grd.Rows[grd.Rows.Count - 1].Cells["TIMEOUTm"].Value = Settings.DR["TIMEOUTm"].ToString(); grd.Rows[grd.Rows.Count - 1].Cells["Salary"].Value = Settings.DR["Salary"].ToString(); } SumTotal(); }