private void DataToScorerViewer()
{
Position positionFilter = comboBox_PositionFilter.SelectedItem as Position;
if (positionFilter == null)
{
positionFilter = Position.Empty;
}
Interviewer interviewerFilter = comboBox_InterviewerFilter.SelectedItem as Interviewer;
if (interviewerFilter == null)
{
interviewerFilter = Interviewer.Empty;
}
Nominee nomineeFilter = comboBox_NomineeFilter.SelectedItem as Nominee;
if (nomineeFilter == null)
{
nomineeFilter = Nominee.Empty;
}
NomineeScoreTypeArr nomineeScoreTypeArr = new NomineeScoreTypeArr();
nomineeScoreTypeArr.Fill();
nomineeScoreTypeArr = nomineeScoreTypeArr.Filter(interviewerFilter, nomineeFilter, positionFilter, dateTimePicker_FromFilter.Value, dateTimePicker_ToFilter.Value);
scorer_View.SetDataSource(nomineeScoreTypeArr, interviewerFilter);
}
public async Task <IActionResult> AddNew(AddNewNomineeViewModel model, IFormFile image)
{
if (ModelState.IsValid)
{
var nominee = new Nominee()
{
StageName = model.StageName,
School = model.School,
Gender = model.Gender
};
using (var memoryStream = new MemoryStream())
{
await image.CopyToAsync(memoryStream);
nominee.Image = memoryStream.ToArray();
nominee.ImageMime = image.ContentType;
}
var newNominee = this.Services.SaveNominee(nominee);
if (newNominee != null)
{
return(RedirectToAction("Index", "NomineesMVC"));
}
}
return(BadRequest(ModelState));
}
private void button_OpenScoreKeeping_Click(object sender, EventArgs e)
{
if (label_DBID.Text == "0")
{
return;
}
NomineeArr nomineeArr = new NomineeArr();
nomineeArr.Fill();
Nominee curNominee = nomineeArr.GetNomineeByDBId(int.Parse(label_DBID.Text));
ScoreKeeping scoreKeeping = new ScoreKeeping(curInterviewer, curNominee);
scoreKeeping.ShowDialog();
NomineeScoreTypeArr newNomineeScoreTypeArr = scoreKeeping.FormToNomineeScoreTypeArr();
NomineeScoreTypeArr OldNomineeScoreTypeArr = new NomineeScoreTypeArr();
OldNomineeScoreTypeArr.Fill();
OldNomineeScoreTypeArr = OldNomineeScoreTypeArr.Filter(curInterviewer, curNominee, ScoreType.Empty, 0, DateTime.MinValue, DateTime.MaxValue);
OldNomineeScoreTypeArr.DeleteArr();
newNomineeScoreTypeArr.InsertArr();
}
public void gridNominee_RowCommand(Object sender, GridViewCommandEventArgs e)
{
try
{
using (var context = new DatabaseContext())
{
if (e.CommandName == "NominateEmployee")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow selectedRow = gridNominee.Rows[index];
TableCell employeeNumber = selectedRow.Cells[0];
string empNo = employeeNumber.Text;
string code = Variables.code;
int id = Variables.shopTrainingId;
Nominee newNominee = new Nominee()
{
EmployeeNumber = empNo,
ShopTrainingId = id,
Status = "On Waiting List"
};
context.Nominees.Add(newNominee);
context.SaveChanges();
ReloadGrid();
int count = context.Nominees.Where(c => c.ShopTrainingId == id).ToList().Count;
lblTotalNominee.Text = count.ToString();
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "sweetAlertWarning('" + ex.Message + "');", true);
}
}
private void button_Delete_Click(object sender, EventArgs e)
{
Nominee delete = FormToNominee();
if (delete.DBId == 0)
{
MessageBox.Show("לא נבחר לקוח למחיקה!", "שגיאה", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (MessageBox.Show("פעולה זאת הינה בלתי ניתנת לשיחזור!\nהאם אתה בטוח שברצונך להמשיך?", "אזהרה!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading) == DialogResult.Yes)
{
if (true)
{
//delete this nominee from the database
if (delete.Delete())
{
NomineeArr nomineearr = new NomineeArr();
nomineearr.Fill(GetCurNomineeArrState());
SetCV(delete.DBId);
listBox_Nominee.DataSource = nomineearr;
NomineeToForm(null);
}
else
{
MessageBox.Show("קרתה תקלה בזמן המחיקה של המועמד מבסיס הנתונים", "תקלה", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
}
}
}
}
}
public List <Nominee> d_nominees(int userid)
{
List <Nominee> nomineelist = new List <Nominee>();
using (SqlConnection c = new SqlConnection("Data Source=DESKTOP-UH8UV7B;Initial Catalog=IBS;Integrated Security=True"))
{
c.Open();
SqlCommand cmd2 = new SqlCommand();
cmd2.Connection = c;
cmd2.CommandText = "select * from Nominees where UserID = @uid";
cmd2.Parameters.AddWithValue("@uid", userid);
SqlDataReader rd2 = cmd2.ExecuteReader();
while (rd2.Read())
{
Nominee n = new Nominee();
n.NomineeName = rd2.GetString(1);
n.NomineeRelation = rd2.GetString(2);
n.NomineeAge = rd2.GetInt32(3);
n.NomineeGender = rd2.GetString(4);
n.NomineeMobileNumber = rd2.GetInt64(5);
n.NomineeAddress = rd2.GetString(6);
nomineelist.Add(n);
}
c.Close();
}
return(nomineelist);
}
public void AddNominee(NomineeScoreTypeArr nomineeScoreTypeArr, Nominee nominee)
{
GroupBox groupBox = new GroupBox();
groupBox.Anchor = AnchorStyles.Top | AnchorStyles.Right;
groupBox.Location = new Point(0, 0);
groupBox.RightToLeft = RightToLeft.Yes;
groupBox.Size = new Size(tableLayoutPanel.Width - 2, 500);
groupBox.TabStop = false;
groupBox.Text = nominee.ToString();
Scorer scorer = new Scorer(false);
scorer.Location = new Point(0, 40);
scorer.RightToLeft = RightToLeft.Yes;
scorer.Size = groupBox.ClientSize;
/*scorer.Width -= 2;*/
scorer.Dock = DockStyle.Fill;
scorer.SetDataSource(nomineeScoreTypeArr);
groupBox.Controls.Add(scorer);
tableLayoutPanel.Controls.Add(groupBox);
tableLayoutPanel.SetRow(groupBox, tableLayoutPanel.RowCount);
}
private PositionNomineeArr FormToPositionNomineeArr(Nominee curNom)
{
//יצירת אוסף המוצרים להזמנה מהטופס
//מייצרים זוגות של הזמנה-מוצר, ההזמנה - תמיד אותה הזמנה )הרי מדובר על הזמנה אחת(, המוצר - מגיע מרשימת
//המוצרים שנבחרו
PositionArr positionArr = (textBox_Positions.Tag as PositionArr);
PositionNomineeArr positionNomineeArr = new PositionNomineeArr();
//יצירת אוסף הזוגות הזמנה-מוצר
PositionNominee positionNominee;
//סורקים את כל הערכים בתיבת הרשימה של המוצרים שנבחרו להזמנה
for (int i = 0; i < positionArr.Count; i++)
{
positionNominee = new PositionNominee();
//ההזמנה הנוכחית היא ההזמנה לכל הזוגות באוסף
positionNominee.Nominee = curNom;
//מוצר נוכחי לזוג הזמנה-מוצר
positionNominee.Position = positionArr[i] as Position;
//הוספת הזוג הזמנה - מוצר לאוסף
positionNomineeArr.Add(positionNominee);
}
return(positionNomineeArr);
}
// DELETE: api/Nominee/5
public IHttpActionResult Delete(int id)
{
Nominee result = nomineeList.Where(p => p.ID == id).FirstOrDefault();
var resultflag = nomineeList.Remove(result);
return(Ok(resultflag));
}
public IHttpActionResult PutNominee(int id, Nominee nominee)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != nominee.Id)
{
return(BadRequest());
}
db.Entry(nominee).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!NomineeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult AddNominee(Nominee newNominee)
{
context.Nominees.Add(newNominee);
context.SaveChanges();
return(RedirectToAction("Index"));
}
// PUT: api/Nominee/5
public IHttpActionResult Put(int id, Nominee value)
{
Nominee result = nomineeList.Where(p => p.ID == id).FirstOrDefault();
result.FirstNomineeName = value.FirstNomineeName;
result.FirstNomineeRelationWithEmp = value.FirstNomineeRelationWithEmp;
result.SecondNomineeName = value.SecondNomineeName;
result.SecondNomineeRelationWithEmp = value.SecondNomineeRelationWithEmp;
return(Ok(result));
}
public IHttpActionResult GetNominee(int id)
{
Nominee nominee = db.Nominees.Find(id);
if (nominee == null)
{
return(NotFound());
}
return(Ok(nominee));
}
public NomineesPosition_Form(Nominee nominee)
{
InitializeComponent();
//לשונית פריטים להזמנה
//תיבת רשימה - פריטים בהזמנה
//מוצאים את הפריטים בהזמנה הנוכחית
// כל הזוגות פריט -הזמנה
if (nominee != Nominee.Empty)
{
PositionNomineeArr positionNomineeArr = new PositionNomineeArr();
positionNomineeArr.Fill();
//סינון לפי הזמנה נוכחית
positionNomineeArr = positionNomineeArr.Filter(nominee, Position.Empty);
//רק אוסף הפריטים מתוך אוסף הזוגות פריט -הזמנה
PositionArr positionArrInNominee = positionNomineeArr.ToPositionArr();
PositionArrToForm(positionArrInNominee, listBox_ChosenPositions);
//תיבת רשימה - פריטים פוטנציאלים
//כל הפריטים - פחות אלו שכבר נבחרו
PositionArr positionArrNotInNominee = new PositionArr();
positionArrNotInNominee.Fill();
//הורדת הפריטים שכבר קיימים בהזמנה
positionArrNotInNominee.Remove(positionArrInNominee);
PositionArrToForm(positionArrNotInNominee, listBox_AvailablePositions);
}
else
{
PositionArrToForm(new PositionArr(), listBox_ChosenPositions);
PositionArr positionArrNotInNominee = new PositionArr();
positionArrNotInNominee.Fill();
//הורדת הפריטים שכבר קיימים בהזמנה
PositionArrToForm(positionArrNotInNominee, listBox_AvailablePositions);
}
button_Add.Enabled = false;
button_Remove.Enabled = false;
listBox_AvailablePositions.ClearSelected();
listBox_ChosenPositions.ClearSelected();
}
protected void gvNomDetail_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridViewRow gvRow = null;
if (((Button)e.CommandSource).Text.Equals("View"))
{
gvRow = (GridViewRow)((Button)e.CommandSource).NamingContainer;
hdNomSlno.Value = ((HiddenField)gvRow.FindControl("hdNomineeSlno")).Value;
Issue oIssue = (Issue)Session[Constants.SES_CURRENT_ISSUE];
Nominee oNominee = oIssue.NomineeList.Where(n => n.SlNo.Equals(Convert.ToInt32(hdNomSlno.Value))).SingleOrDefault();
//DateTime parsedDate;
//DateTime.TryParseExact(gvRow.Cells[7].Text, Constants.DateTimeFormats, null, DateTimeStyles.None, out parsedDate);
string sNomDetails = "";
sNomDetails += "<fieldset><legend>Nominee Details</legend>";
sNomDetails += "<table class=\"tableBody\" border=\"0\">";
sNomDetails += "<tr><td>Name: </td><td>" + oNominee.NomineeName + "</td><tr>";
sNomDetails += "<tr><td>Relation: </td><td>" + oNominee.Relation + "</td><tr>";
sNomDetails += "<tr><td>Present Address: </td><td>" + oNominee.Address + "</td><tr>";
sNomDetails += "<tr><td>Parmanent Address: </td><td>" + oNominee.ParmanentAddress + "</td><tr>";
sNomDetails += "<tr><td>Share: </td><td>" + oNominee.NomineeShare.ToString("N2") + "</td><tr>";
sNomDetails += "<tr><td>Amount: </td><td>" + oNominee.Amount.ToString("N2") + "</td><tr>";
if (oNominee.DateOfBirth.Year > 1900)
{
sNomDetails += "<tr><td>DOB:</td><td>" + oNominee.DateOfBirth.ToString(Constants.DATETIME_dd_MMM_yyyy) + "</td><tr>";
}
else
{
sNomDetails += "<tr><td>DOB:</td><td></td><tr>";
}
sNomDetails += "<tr><td>Gender: </td><td>" + oNominee.Sex + "</td><tr>";
sNomDetails += "<tr><td>Resident: </td><td>" + oNominee.ResidentStatus + "</td><tr>";
sNomDetails += "<tr><td>Country: </td><td>" + oNominee.Resident_Country + "</td><tr>";
sNomDetails += "<tr><td>NationalID: </td><td>" + oNominee.NationalID + "</td><tr>";
sNomDetails += "<tr><td>NationalID Country: </td><td>" + oNominee.NationalID_Country + "</td><tr>";
sNomDetails += "<tr><td>PassportNo: </td><td>" + oNominee.PassportNo + "</td><tr>";
sNomDetails += "<tr><td>PassportNo Country: </td><td>" + oNominee.PassportNo_Country + "</td><tr>";
sNomDetails += "<tr><td>BirthCertificateNo: </td><td>" + oNominee.BirthCertificateNo + "</td><tr>";
sNomDetails += "<tr><td>BirthCertificateNo Country: </td><td>" + oNominee.BirthCertificateNo_Country + "</td><tr>";
sNomDetails += "<tr><td>TIN: </td><td>" + oNominee.TIN + "</td><tr>";
sNomDetails += "<tr><td>Phone: </td><td>" + oNominee.Phone + "</td><tr>";
sNomDetails += "<tr><td>Email: </td><td>" + oNominee.EmailAddress + "</td><tr>";
sNomDetails += "</table>";
sNomDetails += "</fieldset>";
UCMessageInfo.OpenMessage(sNomDetails, Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel6, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
public void NomineeScoreTypeToTable(Interviewer interviewer, Nominee nominee)
{
//listView_Nominee
NomineeScoreTypeArr nomineeScoreTypeArr = new NomineeScoreTypeArr();
nomineeScoreTypeArr.Fill();
nomineeScoreTypeArr = nomineeScoreTypeArr.Filter(interviewer, nominee, Position.Empty, DateTime.MinValue, DateTime.MaxValue);
SortedDictionary <string, string> dictionary = nomineeScoreTypeArr.GetSortedDictionary();
UpdateListView_Interviewer_Nominee(dictionary);
}
public IHttpActionResult PostNominee(Nominee nominee)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Nominees.Add(nominee);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = nominee.Id }, nominee));
}
public IHttpActionResult DeleteNominee(int id)
{
Nominee nominee = db.Nominees.Find(id);
if (nominee == null)
{
return(NotFound());
}
db.Nominees.Remove(nominee);
db.SaveChanges();
return(Ok(nominee));
}
public ScoreKeeping(Interviewer interviewer, Nominee nominee)
{
InitializeComponent();
Text = "ציונים עבור " + nominee.ToString();
NomineeScoreTypeArr nomineeScoreTypeArr = new NomineeScoreTypeArr();
nomineeScoreTypeArr.Fill();
nomineeScoreTypeArr = nomineeScoreTypeArr.Filter(interviewer, nominee, ScoreType.Empty, 0, DateTime.MinValue, DateTime.MaxValue);
nomineeScoreTypeArr = FillData(nomineeScoreTypeArr, nominee, interviewer);
scorer1.SetDataSource(nomineeScoreTypeArr);
}
// save a nominee
public Nominee SaveNominee(Nominee model)
{
if (model.Id == 0)
{
Context.Nominees.Add(model);
}
else if (model.Id > 0)
{
// do the updating
}
Context.SaveChanges();
return(model);
}
public async Task <IActionResult> Edit(Nominee nominee)
{
if (ModelState.IsValid)
{
nominee.UpdatedBy = User.Identity.Name;
nominee.UpdatedDate = DateTime.Now;
_db.Entry(nominee).State = EntityState.Modified;
await _db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(nominee));
}
public IActionResult Post([FromBody] Nominee value)
{
try
{
if (ModelState.IsValid)
{
var nominee = Services.SaveNominee(value);
return(CreatedAtAction("Get", new { id = value.Id }, nominee));
}
return(BadRequest(ModelState));
}
catch (Exception e)
{
return(BadRequest(e));
}
}
public void PostNominee()
{
// Arrange
NomineeController controller = new NomineeController();
Nominee NomineeObj = new Nominee
{
FirstNomineeName = "Jhon",
FirstNomineeRelationWithEmp = "Father",
};
var actResult = controller.Post(NomineeObj);
// Act
var result = actResult as OkNegotiatedContentResult <Nominee>;
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Content.ID > 0);
}
public void PutNominee()
{
// Arrange
NomineeController controller = new NomineeController();
Nominee NomineeObj = new Nominee
{
FirstNomineeName = "Put request sucessfull",
ID = 1
};
var actResult = controller.Put(1, NomineeObj);
// Act
var result = actResult as OkNegotiatedContentResult <Nominee>;
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Content.FirstNomineeName.Equals("Put request sucessfull"));
}
private List <Nominee> NomineesFromSunlightNominees(SunlightVoteResult.SunlightNominee[] sunlightNominees)
{
var nominees = new List <Nominee>();
if (sunlightNominees == null)
{
_logger.Warn("Cannot retrive nominees from SunlightNominees because the value is null!");
return(nominees);
}
foreach (var n in sunlightNominees)
{
var nominee = new Nominee(n.name ?? string.Empty, n.position ?? string.Empty, n.state);
nominees.Add(nominee);
}
return(nominees);
}
private Nominee FormToNominee()
{
Nominee nominee = new Nominee();//Create a new instance of the Nominee class.
//insert the data to the object
nominee.DBId = int.Parse(label_DBID.Text);
nominee.Disabled = label_ShowDisabled.Visible;
nominee.FirstName = textBox_FirstName.Text;
nominee.LastName = textBox_LastName.Text;
nominee.Id = textBox_ID.Text;
nominee.Email = textBox_Email.Text;
nominee.BirthYear = textBox_BirthYear.Text == "" ? 0 : int.Parse(textBox_BirthYear.Text);
nominee.CellAreaCode = comboBox_CellAreaCode.Text;
nominee.CellPhone = textBox_Cel.Text;
nominee.City = comboBox_City.SelectedItem != null ? comboBox_City.SelectedItem as City : City.Empty;
nominee.Male = checkBox_Sex.Checked;
return(nominee);
}
public IActionResult Put(int id, [FromBody] Nominee value)
{
if (id != value.Id)
{
return(BadRequest($"{value.Id} does not match with {id} "));
}
try
{
if (ModelState.IsValid)
{
var nominee = Services.SaveNominee(value);
return(CreatedAtAction("Get", new { id = value.Id }, nominee));
}
return(BadRequest(ModelState));
}
catch (Exception e)
{
return(BadRequest(e));
}
}
public HttpResponseMessage Post([FromBody] Nominee nominee)
{
try
{
using (TrustyloandbEntities entities = new TrustyloandbEntities())
{
entities.Configuration.ProxyCreationEnabled = false;
entities.Nominees.Add(nominee);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, nominee);
message.Headers.Location = new Uri(Request.RequestUri + nominee.ID.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public async Task <IActionResult> Create(Nominee nominee)
{
if (ModelState.IsValid)
{
if (_db.Nominees.Any(p => p.Username == User.Identity.Name))
{
var nomi = _db.Nominees.FirstOrDefault(p => p.Username == User.Identity.Name);
nomi.NomineeName = nominee.NomineeName;
nomi.DateOfBirth = nominee.DateOfBirth;
nomi.Relation = nominee.Relation;
nomi.Contact = nominee.Contact;
nomi.Address1 = nominee.Address1;
nomi.Address2 = nominee.Address2;
nomi.City = nominee.City;
nomi.State = nominee.State;
nomi.Pincode = nominee.Pincode;
nomi.UpdatedBy = User.Identity.Name;
nomi.UpdatedDate = DateTime.Now;
_db.Entry(nomi).State = EntityState.Modified;
await _db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
else
{
nominee.CreatedBy = User.Identity.Name;
nominee.CreatedDate = DateTime.Now;
nominee.Username = User.Identity.Name;
_db.Nominees.Add(nominee);
await _db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
}
return(View(nominee));
}
private void button_ChangeDisabled_Click(object sender, EventArgs e)
{
Nominee nom = FormToNominee();
if (nom.DBId == 0)
{
MessageBox.Show("לא נבחר לקוח תקין!", "שגיאה", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (!nom.Disabled)
{
if (MessageBox.Show("המועמד הולך להפוך ללא זמין?\nהאם אתה בטוח שברצונך להמשיך?", "אזהרה!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading) == DialogResult.Yes)
{
//make this nominee disabled
nom.Disable();
NomineeArr nomineearr = new NomineeArr();
nomineearr.Fill(GetCurNomineeArrState());
listBox_Nominee.DataSource = nomineearr;
NomineeToForm(null);
}
}
else
{
if (MessageBox.Show("המועמד הולך להפוך שוב לזמין?\nהאם אתה בטוח שברצונך להמשיך?", "אזהרה!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading) == DialogResult.Yes)
{
//make this nominee enabled
nom.Enable();
NomineeArr nomineearr = new NomineeArr();
nomineearr.Fill(GetCurNomineeArrState());
listBox_Nominee.DataSource = nomineearr;
NomineeToForm(null);
}
}
}
