public ActionResult CreateAction(ActionTableModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
else
{
tbl_actions tbl = new tbl_actions();
tbl.Controller = model.Controller;
tbl.Value = model.Value;
tbl.Text = model.Text;
Kdb.tbl_actions.Add(tbl);
Kdb.SaveChanges();
}
return(RedirectToAction("ListAction", "Misc"));
}
public ActionResult AddActions(string empno, string actionitemcode, HttpPostedFileBase imagefile, string remarks = "", string requestforreview = "")
{
string actioncode = get_acode();
string actionimage = "";
//////////////////////
if (imagefile != null)
{
if (imagefile.ContentLength > 0)
{
try
{
tbl_images im = new tbl_images();
string path = System.IO.Path.Combine(Server.MapPath("~/fileImages"), System.IO.Path.GetFileName(imagefile.FileName));
path = Server.MapPath("~/fileImages/" + actionitemcode + "/" + actioncode);
if (!Directory.Exists(path))
{
DirectoryInfo di = Directory.CreateDirectory(path);
}
//var im = new tbl_images();
//db.images.Add(im);
string ext = System.IO.Path.GetExtension(imagefile.FileName);
string newfilename = actioncode;
string tosave = path + "/" + newfilename + ext;
int i = 0;
while (System.IO.File.Exists(tosave))
{
i++;
newfilename = actioncode + "_" + i;
tosave = path + "/" + newfilename + ext;
}
actionimage = actionitemcode + "/" + actioncode + "/" + newfilename + ext;
imagefile.SaveAs(tosave);
im = new tbl_images(newfilename, actionimage, actionimage);
dbi.images.Add(im);
dbi.SaveChanges();
}
catch
{
}
}
}
////////////////
var ac = new tbl_actions();
ac.remarks = remarks;
ac.itemcode = actionitemcode;
ac.actioncode = actioncode;
ac.actionimage = actionimage;
ac.p_actioncode = "00000";
ac.empno = empno;
db.d_actions.Add(ac);
db.SaveChanges();
//check if request for review
if (requestforreview == "forreview")
{
tbl_dataFindings d_item = db.dataFindings.Single(p => p.itemcode == actionitemcode);
d_item.status = 2;
db.SaveChanges();
}
// get gi_code || areaincharge
string gicode = db.dataFindings.Where(s => s.itemcode == actionitemcode).Select(s => s.areaincharge).Single();
//get list of incharge
var loi = db.emaildept.Where(s => s.gi_code == gicode).ToList();
string[] eset;
eset = new string[loi.Count];
if (loi.Count > 0)
{
int x = 0;
foreach (var emp in loi)
{
try {
string email = curuser.users.Single(p => p.empno == emp.empno).email.ToString();
eset[x] = email;
x++;
}
catch (Exception e) { Response.Write(e.Message); }
}
}
// get_emails
if (eset.Length > 0)
{
SendEmail(eset, actionitemcode, remarks);
}
return(RedirectToAction("Details", new { @id = actionitemcode }));
}
