public async Task <ActionResult <empInfo> > PostempInfo(empInfo empInfo)
{
_context.empTable.Add(empInfo);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetempInfo", new { id = empInfo.empId }, empInfo));
}
public async Task <IActionResult> PutempInfo(int id, empInfo empInfo)
{
if (id != empInfo.empId)
{
return(BadRequest());
}
_context.Entry(empInfo).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!empInfoExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult DeleteConfirmed(int id)
{
empInfo empInfo = db.empObject.Find(id);
db.empObject.Remove(empInfo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "empno,empname,projname,skills,alloc,exper,rmap")] empInfo empInfo)
{
if (ModelState.IsValid)
{
db.Entry(empInfo).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(empInfo));
}
public ActionResult Create([Bind(Include = "empno,empname,projname,skills,alloc,exper,rmap")] empInfo empInfo)
{
if (!ModelState.IsValid)
{
db.empObject.Add(empInfo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(empInfo));
}
// GET: Detail/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
empInfo empInfo = db.empObject.Find(id);
if (empInfo == null)
{
return(HttpNotFound());
}
return(View(empInfo));
}
private void agregarItem(empInfo empInfo)
{
try
{
ListViewItem list = listViewDeviceUsers.Items.Add(empInfo.Badge);
list.UseItemStyleForSubItems = false;
//list.SubItems.Add(s.Split(',')[0]);
list.SubItems.Add(empInfo.Name);
list.SubItems.Add(empInfo.Lastname);
//n.Font = fontListView;
//listViewDeviceUsers.Items.Add(n);
}
catch (Exception ex)
{
Tools.GetInstance().DoLog("Excepcion en agregarItem. Ex: " + ex.ToString());
}
}
//end run report
/// <summary>
/// 3 reports and 1 data update
/// </summary>
/// <returns></returns>
protected string process_discrepancy_reports(string sdate1, string sdate2)
{
//list of returned tmp files
DataSet _ds = new DataSet("all_reports");
string _xml = "";
IList <empInfo> _ids = get_user_ids();
IList <string> _tmp = new List <string>(new string[] { "Orders_With_No_Delivery_Details", "Orders_Without_Customer_Contact",
"Discrepancies_Report_Pre_Shipment", "Discrepancies_Report_Post_Shipment",
"Check_Delivery_Status", "Usborne_ExWorks_Date_Overdue_Report" });
//for each user (probably most of these users will not have any reports to send
//process reports and get tmp filename for each
for (int _ix = 0; _ix < _tmp.Count; _ix++)
{
//check to see if this report is scheduled
if (in_schedule(_tmp[_ix]))
{
DataTable _dt = process_report(_tmp[_ix], sdate1.ToString(), sdate2.ToString()); //append report results to report name
//141112 include all data tables so user knows if 0 rcords found
if (_dt != null)
//if (_dt != null && _dt.Rows.Count > 0)
{
_dt.TableName = _tmp[_ix]; //must have table names or can't parse to xml
_ds.Tables.Add(_dt);
}
}
}
if (_ds.Tables.Count > 0)
{
//now step through users and filter data by user id
for (int _ix = 0; _ix < _ids.Count; _ix++)
{
empInfo _user = _ids[_ix];
IList <Attachment> _csvs = new List <Attachment>();
string _mailto = _user.EmailAddress;
string _controller = _user.Name;
string _html = "";
//step through all query datatables and filter by current user
for (int _dx = 0; _dx < _ds.Tables.Count; _dx++)
{
int _records = 0; //reset for each table for this user
if (_ds.Tables[_dx].Rows.Count > 0)
{
DataRow[] _set = _ds.Tables[_dx].Select("hfControllerID = " + _user.EmployeeID);
//copy table def without rows
DataTable _du = _ds.Tables[_dx].Clone();
//drop filtered rows into sub dataset
foreach (DataRow _dr in _set)
{
_du.ImportRow(_dr);
}
//create email attachment if has rows
if (_du.Rows.Count > 0)
{
// Stream the Excel spreadsheet to the client in a format
// compatible with Excel 97/2000/XP/2003/2007/2010.
System.IO.MemoryStream _stream = new System.IO.MemoryStream(ASCIIEncoding.Default.GetBytes(return_formatted_csv(_du)));
Attachment _a = new Attachment(_stream, _tmp[_dx] + ".csv");
_csvs.Add(_a);
_records = _du.Rows.Count;
}
}
//look for a descriptive note
string _note = "<em>" + wwi_func.get_from_global_resx(_tmp[_dx] + "_Note") + "</em>";
//build summary of results for each query name include report name even if no records found and thereefore no csv for that report
_html += "<li>" + _tmp[_dx].Replace("_", " ") + ": " + _records.ToString() + " records<br/>" + _note + "</li>";
//
}//end loop through datatables
//append list tags
_html = "<ul>" + _html + "</ul>";
//send mail if we have attachments
if (_csvs.Count > 0)
{
string[] _to = { _mailto, "*****@*****.**" };
//string[] _to = { "*****@*****.**" };
//email
send_spreadsheet(_to, "Discrepancy reports " + DateTime.Now.ToShortDateString() + " for " + _controller, _html, _controller, _csvs);
}
} //end loop through users
} //end if table.count
//output xml
_xml = serialize_list(_tmp);
return(_xml);
}
