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