private async void gData_CellContentClick(object sender, DataGridViewCellEventArgs e) { var senderGrid = (DataGridView)sender; if (senderGrid.Columns[e.ColumnIndex] is DataGridViewImageColumn && e.RowIndex >= 0) { if (e.ColumnIndex == 7) { if ((await GridDelImageAsync(e.RowIndex)) != null) { using (var context = new KimathiEntities()) { try { context.Entry <Work>(await GridDelImageAsync(e.RowIndex)).State = EntityState.Deleted; context.SaveChanges(); //short Custom Notification alert.Show("Deleted", alert.AlertType.warnig); gData.Rows[e.RowIndex].Visible = false; //Load the grid again GridInitializer(dTimePickerGrid.Value); } catch (Exception exp) { MessageBox.Show("Something went wrong" + exp.Message, "Unsuccessful"); } } } } if (e.ColumnIndex == 0) { if (MetroMessageBox.Show(this, $"Hi do you want to pay {this.gData.Rows[e.RowIndex].Cells[2].Value.ToString()} {this.gData.Rows[e.RowIndex].Cells[5].Value.ToString()}", "Payment", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question) == DialogResult.Yes) { //this employee wages have been payed //get instance of employee and pay Work xx = (await GridDelImageAsync(e.RowIndex)); xx.Payed = 1; try { using (var context = new KimathiEntities()) { context.Entry <Work>(xx).State = EntityState.Modified; context.SaveChanges(); //short Custom Notification alert.Show("Payment Successfull", alert.AlertType.info); //Load the grid again GridInitializer(dTimePickerGrid.Value); } } catch (Exception) { } } } } }
private async void btnSave3_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(tbbrickreg.Text)) { //UI code alert.Show("Required info \n Brick Registered !", alert.AlertType.warnig); return; } if (string.IsNullOrEmpty(tbbrickused.Text)) { //UI code alert.Show("Required info \n Brick Used !", alert.AlertType.warnig); return; } btnSave3.Visible = false; lbltu3.Visible = true; using (var context = new KimathiEntities()) { var stoklist = await Task.Factory.StartNew(() => { return(context.Stocks .OrderBy(x => x.Id) .ToList()); }); var temp1 = stoklist.Where(x => x.RawMaterial.Equals("cement")); var temp2 = stoklist.Where(x => x.RawMaterial.Equals("water")); var temp3 = stoklist.Where(x => x.RawMaterial.Equals("brick")); try { //check if required quantity has changed if (int.Parse(tbbrickreg.Text) == temp3.FirstOrDefault().AmountIn) { temp3.FirstOrDefault().AmountOut += int.Parse(tbbrickused.Text); temp3.FirstOrDefault().Quantity = temp3.FirstOrDefault().AmountIn - temp3.FirstOrDefault().AmountOut; try { context.Entry <Stock>(temp3.FirstOrDefault()).State = EntityState.Modified; context.SaveChanges(); alert.Show("Updated !", alert.AlertType.success); LoadUpGui(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { //now update temp3.FirstOrDefault().AmountIn += int.Parse(tbbrickreg.Text); temp3.FirstOrDefault().AmountOut += int.Parse(tbbrickused.Text); temp3.FirstOrDefault().Quantity = temp3.FirstOrDefault().AmountIn - temp3.FirstOrDefault().AmountOut; try { context.Entry <Stock>(temp3.FirstOrDefault()).State = EntityState.Modified; context.SaveChanges(); alert.Show("Updated !", alert.AlertType.success); LoadUpGui(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } catch (Exception) { } } }
private void btnSave_Click(object sender, EventArgs e) { Work dowork = null; if (theemp != null) { long xx = theemp.IdNum; using (var context = new KimathiEntities()) { var wList = context.Works .OrderBy(a => a.TimeOut) .Where(a => a.IdNum_fk == xx) .ToList(); foreach (var ss in wList.Where(a => a.Employee == theemp)) { if (ss.Id == theemp.IdNum) { //returns the latest work entry dowork = ss; break; } } if (dowork != null) { dowork.TimeIn = dTimePickerIn.Value; dowork.TimeOut = dTimePickerOut.Value; dowork.IdNum_fk = theemp.IdNum; context.Entry <Work>(dowork).State = EntityState.Modified; try { context.SaveChanges(); alert.Show("Updated !", alert.AlertType.success); } catch (Exception) { } } else { Work d = new Work(); d.IdNum_fk = theemp.IdNum; d.TimeIn = dTimePickerIn.Value; d.TimeOut = dTimePickerOut.Value; d.Payed = 0; //d.Employee = theemp; try { context.Works.Add(d); context.SaveChanges(); alert.Show("Saved !", alert.AlertType.success); } catch (Exception ex) { MessageBox.Show(ex.Message); throw; } } } } }