public WorkTableModel(WorkTable table)
{
this.Id = table.Id;
this.Date = table.Date;
this.IsActive = table.IsActive;
this.PersonId = table.PersonId;
}
private void radGridView1_CommandCellClick(object sender, Telerik.WinControls.UI.GridViewCellEventArgs e)
{
var col = radGridView1.CurrentColumn.Index;
if (col == 7)
{
EditWorkFrm frm = new EditWorkFrm();
WorkTable tb = (WorkTable)radGridView1.CurrentRow.DataBoundItem;
frm.Wtb = tb;
frm.ShowDialog();
}
if (col == 8)
{
if (RadMessageBox.Show(this, "هل تريد حذف السجل", "حذف السجلات", MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes)
{
if (WorkCmd.DeleteWork(((WorkTable)this.radGridView1.CurrentRow.DataBoundItem).Id))
{
}
else
{
RadMessageBox.Show("لا يمكن حذف السجل", "خطأ", MessageBoxButtons.OK, RadMessageIcon.Error);
}
}
}
}
public IEnumerable <WorkTable> GetWorkList()
{
List <WorkTable> WorkData = new List <WorkTable>();
SqlConn();
SqlCommand cmd = new SqlCommand("Select * From Works", conn);
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
WorkTable work = new WorkTable();
work.Id = Convert.ToInt32(rdr["UserId"]);
work.Tittle = rdr["Tittle"].ToString();
work.Explanation = rdr["Explanation"].ToString();
work.Category = rdr["Category"].ToString();
work.Hıw = rdr["Hıw"].ToString();
work.EducationStatus = rdr["EducationStatus"].ToString();
work.Experience = rdr["Experience"].ToString();
work.CompanyName = rdr["CompanyName"].ToString();
work.Address = rdr["Address"].ToString();
work.AddressLongitude = Convert.ToDouble(rdr["AddressLongitude"]);
work.AddressLatitude = Convert.ToDouble(rdr["AddressLatitude"]);
work.CompanyPhone = rdr["CompanyPhone"].ToString();
work.InfoEmployer = rdr["InfoEmployer"].ToString();
WorkData.Add(work);
}
conn.Close();
return(WorkData);
}
private void simpleButton2_Click(object sender, EventArgs e)
{
if (RadMessageBox.Show(this, "هل تريد حفظ التعديلات", "حفظ", MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes)
{
var ListData = WorkCmd.GetWorkInfo(UserClass.XEmpId, DateTime.Now.Date);
foreach (var item in ListData)
{
Startime = DateTime.Parse(item.startTime.ToString());
}
float compMonth = (DateTime.Now.Minute + DateTime.Now.Hour * 60) - (Startime.Minute + Startime.Hour * 60);
float Totaltime = compMonth / 60;
WorkTable tb = new WorkTable()
{
EmpId = UserClass.XEmpId,
WorkDate = DateTime.Now.Date,
startTime = Startime.TimeOfDay,
endtime = DateTime.Parse(DateTime.Now.ToShortTimeString()).TimeOfDay,
RealWorkTimeNo = UserClass.XWorkTime,
WorkTime = Totaltime,
DefernceTime = (Totaltime - UserClass.XWorkTime),
WorkFinsh = "true"
};
WorkCmd.EditWorkUser(tb);
RadMessageBox.Show("تم تسجيل الانصراف", "تمت", MessageBoxButtons.OK, RadMessageIcon.Info);
Loginfrm myForm = (Loginfrm)Application.OpenForms["Loginfrm"];
myForm.Show();
this.Close();
}
}
private void AddBtn_Click(object sender, EventArgs e)
{
#region " CheckFillTextBox "
if (EmpComboBox.Text == "")
{
EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.OrangeRed;
EmpComboBox.Focus();
return;
}
else
{
EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.White;
}
if (EmpComboBox.SelectedValue == null)
{
EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.OrangeRed;
EmpComboBox.Focus();
return;
}
else
{
EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.White;
}
#endregion
var q = WorkCmd.CheckWork(int.Parse(EmpComboBox.SelectedValue.ToString()), radDateTimePicker1.Value.Date);
if (q != null)
{
RadMessageBox.Show("مسجل في هذا التاريخ مسبقاً", "خطأ", MessageBoxButtons.OK, RadMessageIcon.Error);
return;
}
float compMonth = (endtimeTimeEdit.Time.Minute + endtimeTimeEdit.Time.Hour * 60) - (startTimeTimeEdit.Time.Minute + startTimeTimeEdit.Time.Hour * 60);
float Totaltime = compMonth / 60;
WorkTime = Totaltime;
Defernce = WorkTime - WorkHour;
WorkTable tb = new WorkTable()
{
EmpId = int.Parse(EmpComboBox.SelectedValue.ToString()),
WorkDate = radDateTimePicker1.Value.Date,
startTime = startTimeTimeEdit.Time.TimeOfDay,
endtime = endtimeTimeEdit.Time.TimeOfDay,
RealWorkTimeNo = WorkHour,
WorkTime = WorkTime,
DefernceTime = Defernce,
WorkFinsh = "true"
};
WorkCmd.addWork(tb);
RadMessageBox.Show("تمت عملية الحفظ", "تمت", MessageBoxButtons.OK, RadMessageIcon.Info);
EmpComboBox.Focus();
}
public static bool addWork(WorkTable tb)
{
db = new DbDataContext();
db.WorkTables.InsertOnSubmit(tb);
db.SubmitChanges();
return(true);
}
private static void Setup()
{
_settings = GetSettingsFromConfig();
var distributedConnectionString = EVE.Site.DAL.Config.GetConnectionString(DataStore.Distributed);
_distributedDatabase = new DistributedDatabase(distributedConnectionString);
_workTable = new WorkTable(distributedConnectionString);
}
public Response SaveWork(WorkTable work)
{
SqlConn();
Response response = new Response();
try
{
conn.Open();
string sSQL = "insert into Works (UserId,Tittle,Explanation,Category,Hıw,EducationStatus,Experience,CompanyName,CompanyPhone,Address,AddressLongitude,AddressLatitude,InfoEmployer)values(@UserId,@Tittle,@Explanation,@Category,@Hıw,@EducationStatus,@Experience,@CompanyName,@CompanyPhone,@Address,@AddressLongitude,@AddressLatitude,@InfoEmployer)";
var cmd = new SqlCommand(sSQL, conn);
cmd.Parameters.AddWithValue("@UserId", work.Id);
cmd.Parameters.AddWithValue("@Tittle", work.Tittle);
cmd.Parameters.AddWithValue("@Explanation", work.Explanation);
cmd.Parameters.AddWithValue("@Category", work.Category);
cmd.Parameters.AddWithValue("@Hıw", work.Hıw);
cmd.Parameters.AddWithValue("@EducationStatus", work.EducationStatus);
cmd.Parameters.AddWithValue("@Experience", work.Experience);
cmd.Parameters.AddWithValue("@CompanyName", work.CompanyName);
cmd.Parameters.AddWithValue("@CompanyPhone", work.CompanyPhone);
cmd.Parameters.AddWithValue("@Address", work.Address);
cmd.Parameters.AddWithValue("@AddressLongitude", work.AddressLongitude);
cmd.Parameters.AddWithValue("@AddressLatitude", work.AddressLatitude);
cmd.Parameters.AddWithValue("@InfoEmployer", work.InfoEmployer);
int temp = 0;
temp = cmd.ExecuteNonQuery();
if (temp > 0)
{
conn.Close();
response.Message = "Work Added Successfully.";
response.Status = 1;
}
else
{
conn.Close();
response.Message = "Works Add Failed.";
response.Status = 0;
}
}
catch (Exception ex)
{
conn.Close();
response.Message = ex.Message;
response.Status = 0;
}
finally
{
conn.Close();
}
return(response);
}
public static WorkTable CheckWork(int usr, DateTime date1)
{
db = new DbDataContext();
try
{
WorkTable q = db.WorkTables.Where(p => p.EmpId == usr && p.WorkDate == date1).Single();
if (q.EmpId == usr && q.WorkDate == date1)
{
return(q);
}
return(null);
}
catch (Exception)
{
return(null);
}
}
private void button8_Click(object sender, EventArgs e)
{
try
{
model5.NUsername = Log.recby;
using (CCareMSEntities db = new CCareMSEntities())
{
model5 = db.WorkTables.Where(x => x.NUsername == model5.NUsername).FirstOrDefault(x => x.FUsername == requF);
model5.WorkStatus = "Booked";
db.SaveChanges();
MessageBox.Show("Congratulation ! you are haired!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
throw;
}
}
public static bool EditWorkUser(WorkTable tb)
{
db = new DbDataContext();
var q = db.WorkTables.Where(p => p.EmpId == tb.EmpId && p.WorkDate == tb.WorkDate).SingleOrDefault();
q.EmpId = tb.EmpId;
q.WorkDate = tb.WorkDate;
q.startTime = tb.startTime;
q.endtime = tb.endtime;
q.RealWorkTimeNo = tb.RealWorkTimeNo;
q.WorkTime = tb.WorkTime;
q.DefernceTime = tb.DefernceTime;
q.WorkFinsh = tb.WorkFinsh;
db.SubmitChanges();
return(true);
}
public static void InitialiseTables()
{
var distributedConnectionString = EVE.Site.DAL.Config.GetConnectionString(DataStore.Distributed);
_workTable = new WorkTable(distributedConnectionString);
_exhibitDatabaseConnectionString =
EVE.Site.DAL.Config.GetConnectionString(DataStore.Exhibit)
.Replace(EVE.Site.DAL.Config.ExhibitPlaceholder, _exhibitId.ToString(CultureInfo.InvariantCulture));
_fileMetadataTable = new FileMetadataTable(_exhibitDatabaseConnectionString);
_entityTable = new EntityTable(_exhibitDatabaseConnectionString);
_connectionMetadataTable = new ConnectionMetadataTable(_exhibitDatabaseConnectionString);
_mediaTable = new MediaTable(_exhibitDatabaseConnectionString);
_exhibitDatabase = new ExhibitDatabase(_exhibitDatabaseConnectionString);
var distributedDbConnctionString = EVE.Site.DAL.Config.GetConnectionString(DataStore.Distributed);
_distributedDatabase = new DistributedDatabase(distributedDbConnctionString);
}
private void dgvnoti_Click(object sender, EventArgs e)
{
try {
if (dgvnoti.CurrentRow.Index != -1)
{
FamilyUser = Convert.ToString(dgvnoti.CurrentRow.Cells["dgvFuser"].Value);
NannyUser = Convert.ToString(dgvnoti.CurrentRow.Cells["dgvNanny"].Value);
model.FUsername = Convert.ToString(dgvnoti.CurrentRow.Cells["dgvFuser"].Value);
using (CMSEntities db = new CMSEntities())
{
model = db.WorkTables.Where(x => x.FUsername == model.FUsername).FirstOrDefault(x => x.NUsername == NannyUser);
}
}
}
catch
{
MessageBox.Show("Invalid");
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
WorkTable tb = new WorkTable()
{
EmpId = UserClass.XEmpId,
WorkDate = DateTime.Now.Date,
startTime = DateTime.Parse(DateTime.Now.ToShortTimeString()).TimeOfDay,
endtime = DateTime.Parse(DateTime.Now.ToShortTimeString()).TimeOfDay,
RealWorkTimeNo = UserClass.XWorkTime,
WorkTime = 0,
DefernceTime = (0 - UserClass.XWorkTime)
};
WorkCmd.addWork(tb);
RadMessageBox.Show("تم تسجيل الحضور", "تمت", MessageBoxButtons.OK, RadMessageIcon.Info);
Loginfrm myForm = (Loginfrm)Application.OpenForms["Loginfrm"];
myForm.Show();
this.Close();
}
/// <summary>
/// Generate csomor for table
/// </summary>
/// <param name="table">Work table</param>
/// <param name="persons">Person list</param>
/// <param name="workId">Work Id</param>
/// <param name="maxHour">Maximum work hour</param>
/// <param name="counter">Counter against infinite loop</param>
private void GenerateToDate(ref WorkTable table, ref List <Person> persons, string workId, int maxHour, int counter = 0)
{
var person = this.GetValidRandomPerson(persons);
if (person == null)
{
return;
}
if (this.WorkerIsValid(person, table.Date, workId, maxHour))
{
table.PersonId = person.Id;
var date = table.Date;
var pTable = person.Tables.FirstOrDefault(x => this.CompareDates(date, x.Date));
if (pTable == null)
{
throw new ArgumentException("Table is missing");
}
pTable.WorkId = workId;
person.Hours--;
}
else if (counter < this.GenerateLimit)
{
if (counter > 100)
{
// TODO: Worker switch
Console.WriteLine("Bigger than 100");
}
else
{
this.GenerateToDate(ref table, ref persons, workId, maxHour, counter++);
}
}
}
// Start is called before the first frame update
void Start()
{
workTableScript = ServiceLocator.Get <WorkTable>();
}
internal void SaveWorkbook()
{
try
{
using (SaveFileDialog saveDialog = new SaveFileDialog())
{
saveDialog.CreatePrompt = false;
saveDialog.OverwritePrompt = true;
saveDialog.RestoreDirectory = false;
saveDialog.InitialDirectory = System.IO.Path.GetDirectoryName(FilenameTextBox.Text);
saveDialog.FileName = System.IO.Path.GetFileNameWithoutExtension(FilenameTextBox.Text);
saveDialog.Filter = Properties.Resources.FILE_SAVEFILE_FILTER;
saveDialog.DefaultExt = Constants.FILE_SAVEFILE_EXTENSION;
saveDialog.FilterIndex = 2;
if (saveDialog.ShowDialog() == DialogResult.OK)
{
System.IO.Stream dtStream;
if ((dtStream = saveDialog.OpenFile()) != null)
{
Cursor.Current = Cursors.WaitCursor;
dtStream.Close();
if (System.Threading.Tasks.Task.Run(() => { return(ExportDataTableCollection(saveDialog.FileName)); }).Result)
{
FilenameTextBox.Text = saveDialog.FileName;
}
Cursor.Current = Cursors.Default;
}
SaveAsLastFileOpened(saveDialog.FileName);
}
SetSpreadsheetChanges(false);
}
}
catch (System.IO.IOException ex)
{
MessageBox.Show(string.Format(UserHelper.culture, Properties.Resources.NOTIFY_FILESAVE_ERROR, System.IO.Path.GetFileNameWithoutExtension(FilenameTextBox.Text)), Properties.Resources.CAPTION_SAVE_WORKBOOK, MessageBoxButtons.OK, MessageBoxIcon.Error);
if (log != null)
{
log.Error(string.Format(UserHelper.culture, Properties.Resources.NOTIFY_FILESAVE_ERROR, System.IO.Path.GetFileNameWithoutExtension(FilenameTextBox.Text)), ex);
}
}
bool ExportDataTableCollection(string destination)
{
using (System.Data.DataSet ExportDataSet = new System.Data.DataSet())
{
foreach (System.Data.DataTable WorkTable in DataTableCollection)
{
WorkTable.AcceptChanges();
ExportDataSet.Merge(WorkTable);
}
System.Data.DataTableCollection ExportTableCollection = ExportDataSet.Tables;
foreach (System.Data.DataTable ExportTable in ExportTableCollection)
{
ExportTable.Constraints.Clear();
ClassLibraryStandard.DataTableMethods.DeleteColumn(ExportTable, Constants.KEY_COLUMN);
}
return(CreateExcelFile.CreateExcelFile.ExportExcelDocument(ExportTableCollection, destination));
}
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
#region " CheckFillTextBox "
if (EmpComboBox.Text == "")
{
EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.OrangeRed;
EmpComboBox.Focus();
return;
}
else
{
EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.White;
}
if (EmpComboBox.SelectedValue == null)
{
EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.OrangeRed;
EmpComboBox.Focus();
return;
}
else
{
EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.White;
}
if (radDropDownList1.Text == "")
{
radDropDownList1.BackColor = Color.OrangeRed;
radDropDownList1.Focus();
return;
}
else
{
radDropDownList1.BackColor = Color.White;
}
#endregion
var q = WorkCmd.CheckWork(int.Parse(EmpComboBox.SelectedValue.ToString()), LeaveDateTimePicker.Value.Date);
if (q != null)
{
if (RadMessageBox.Show(this, "هل تريد حفظ التغيرات", "تنبيه", MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes)
{
LvTb.EmpId = int.Parse(EmpComboBox.SelectedValue.ToString());
LvTb.LeaveDate = LeaveDateTimePicker.Value.Date;
LvTb.LeaveTime = leaveTimeTimeEdit.Time.TimeOfDay;
LvTb.BackTime = backTimeTimeEdit.Time.TimeOfDay;
LvTb.LeaveType = radDropDownList1.Text;
LeaveCmdClass.EditLeave(LvTb);
}
if (RadMessageBox.Show(this, "هل يتم اعتماد ساعة العودة ساعة الانصراف", "تنبيه", MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes)
{
var ListData = WorkCmd.GetWorkInfo(int.Parse(EmpComboBox.SelectedValue.ToString()), LeaveDateTimePicker.Value.Date);
foreach (var item in ListData)
{
Startime = DateTime.Parse(item.startTime.ToString());
UserClass.XWorkTime = float.Parse(item.RealWorkTimeNo.ToString());
}
float compMonth = (backTimeTimeEdit.Time.Minute + backTimeTimeEdit.Time.Hour * 60) - (Startime.Minute + Startime.Hour * 60);
float Totaltime = compMonth / 60;
WorkTable tb1 = new WorkTable()
{
EmpId = int.Parse(EmpComboBox.SelectedValue.ToString()),
WorkDate = LeaveDateTimePicker.Value.Date,
startTime = Startime.TimeOfDay,
endtime = leaveTimeTimeEdit.Time.TimeOfDay,
RealWorkTimeNo = UserClass.XWorkTime,
WorkTime = Totaltime,
DefernceTime = (Totaltime - UserClass.XWorkTime),
WorkFinsh = "true"
};
WorkCmd.EditWorkUser(tb1);
RadMessageBox.Show("تمت الاضافة واعتماد ساعة الانتهاء من الدوام", "تمت", MessageBoxButtons.OK, RadMessageIcon.Info);
}
RadMessageBox.Show("تمت الاضافة بدون اعتماد ساعةالانتهاء من الدوام", "تمت", MessageBoxButtons.OK, RadMessageIcon.Info);
}
else
{
RadMessageBox.Show("يرجى اولا تسجيل الحضور", "خطأ", MessageBoxButtons.OK, RadMessageIcon.Error);
return;
}
}
/// <summary>
/// Todo tray change
/// </summary>
/// <returns></returns>
public async Task <WaitBlock> WorkAsync()
{
return(await Task.Run(async() =>
{
string log = string.Empty;
try
{
//Task<WaitBlock>[] blocks;
if (_currentCycleId == 0)
{
_currentCycleId = 1;
}
//if (VLoadStation.GetInsideOpticalSensor()==false)
//{
// VLoadStation.LoadATray();
//}
//if (VUnloadStation.GetInsideOpticalSensor() == false)
//{
// VUnloadStation.LoadATray();
//}
//if (LLoadStation.GetInsideOpticalSensor()==false)
//{
// LLoadStation.LoadATray();
//}
do
{
//WorkTable.Fixtures[(int)FixtureId.V].IsEmpty = false;
//WorkTable.Fixtures[(int)FixtureId.V].NG = false;
log = string.Empty;
//Stop production.
if (VRobot.StopProduction)
{
bool allEmpty = true;
foreach (var fixture in WorkTable.Fixtures)
{
if (fixture.IsEmpty == false)
{
allEmpty = false;
}
}
if (allEmpty)
{
break;
}
}
//if (VRobot.LoadTray.CurrentPart.XIndex > VRobot.LoadTray.ColumneCount)
//{
// VLoadTrayEmptyManualResetEvent.Reset();
// VLoadTrayEmptyManualResetEvent.WaitOne();
//}
//blocks = new Task<WaitBlock>[2];
//blocks[0] = VRobot.WorkAsync();
//blocks[1] = LRobot.WorkAsync();
//blocks[2] = UVLight.WorkAsync();
//blocks[0] = VRobot.WorkAsync();
//blocks[0] = LRobot.WorkAsync();
//blocks[1] = UVLight.WorkAsync();
//await blocks[0];
//await blocks[1];
//Task.WaitAll(blocks);
//CheckTaskResults(blocks);
//Helper.CheckTaskResult(blocks[1]);
var vTask = VRobot.WorkAsync(_currentCycleId);
var gpTask = GluePointRobot.WorkAsync(_currentCycleId);
var glTask = GlueLineRobot.WorkAsync(_currentCycleId);
var lTask = LRobot.WorkAsync(_currentCycleId);
var uVTask = UVLight.WorkAsync(_currentCycleId);
await vTask;
await gpTask;
await glTask;
await lTask;
await uVTask;
log += vTask.Result.Message + Environment.NewLine;
log += gpTask.Result.Message + Environment.NewLine;
log += glTask.Result.Message + Environment.NewLine;
log += lTask.Result.Message + Environment.NewLine;
Helper.CheckTaskResult(vTask);
Helper.CheckTaskResult(gpTask);
Helper.CheckTaskResult(glTask);
Helper.CheckTaskResult(lTask);
Helper.CheckTaskResult(uVTask);
var tableTask = WorkTable.TurnsAsync();
await tableTask;
Helper.CheckTaskResult(tableTask);
_currentCycleId++;
} while (KeepThisShitRunning);
return new WaitBlock()
{
Message = "Production stopped."
};
}
catch (Exception ex)
{
return new WaitBlock()
{
Code = ErrorCode.ProductionFail,
Message = "Production interruptted due to: " + ex.Message + " " + log,
};
}
}));
}
