public ActionResult Create([Bind(Include = "DetailID,PieceCount,FKSubPieceID")] Detail detail)
{
ViewBag.UserID = Session["UserID"];
int ID = Convert.ToInt32(Session["UserID"]);
if (ModelState.IsValid)
{
ViewBag.FKSubPieceID = new SelectList(db.SubPiece, "SubPieceID", "SubPieceName", detail.FKSubPieceID);
db.Detail.Add(new Detail
{
PieceCount = detail.PieceCount,
CreatedDate = DateTime.Now,
FKSubPieceID = detail.FKSubPieceID,
FKUserID = ID
});
db.SaveChanges();
}
return(RedirectToAction("Index"));
//ViewBag.FKUserID = new SelectList(db.User, "UserID", "UserName", detail.);
}
public ActionResult Create([Bind(Include = "SubPieceID,SubPieceName,ToolLife,Now,FKPieceID,FKUserID,Type")] SubPiece subPiece)
{
ViewBag.UserID = Session["UserID"];
int ID = Convert.ToInt32(Session["UserID"]);
if (ModelState.IsValid)
{
db.SubPiece.Add(new SubPiece()
{
SubPieceName = subPiece.SubPieceName,
ToolLife = subPiece.ToolLife,
FKPieceID = subPiece.FKPieceID,
Type = subPiece.Type,
FKUserID = ID
});
//db.SubPiece.Add(subPiece);
db.SaveChanges();
return(RedirectToAction("TakimOmru", "Home"));
}
ViewBag.FKPieceID = new SelectList(db.Piece, "PieceID", "PieceName", subPiece.FKPieceID);
ViewBag.FKUserID = new SelectList(db.User, "UserID", "UserName", subPiece.FKUserID);
return(View(subPiece));
}
public ActionResult CreateNoteTakim(FormCollection form, [Bind(Include = "NoteID,NoteHeader,NoteDescription,CreatedDate,FkPieceID,FkSubPieceID,FkUserID")] Note note)
{
var takimid = Convert.ToInt32(form["nottakimid"]);
var typetakim = Convert.ToBoolean(form["typetakim"]);
ViewBag.UserID = Session["UserID"];
int ID = Convert.ToInt32(Session["UserID"]);
if (ModelState.IsValid)
{
db.Notes.Add(new Note()
{
NoteHeader = note.NoteHeader,
NoteDescription = note.NoteDescription,
CreatedDate = note.CreatedDate.GetValueOrDefault(DateTime.Now),
FkPieceID = takimid,
FkSubPieceID = note.FkSubPieceID,
FkUserID = ID,
Type = typetakim
});
db.SaveChanges();
return(RedirectToAction("TakimOmru", "Home"));
}
ViewBag.FkPieceID = new SelectList(db.Piece, "PieceID", "PieceName", note.FkPieceID);
ViewBag.FkSubPieceID = new SelectList(db.SubPiece, "SubPieceID", "SubPieceName", note.FkSubPieceID);
ViewBag.FkUserID = new SelectList(db.User, "UserID", "UserName", note.FkUserID);
return(View(note));
}
public ActionResult Create([Bind(Include = "NotificationID,Notification_Description,Count,Notification_Date,FKUserId")] Notification notification)
{
if (ModelState.IsValid)
{
db.Notification.Add(notification);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.FKUserId = new SelectList(db.User, "UserID", "UserName", notification.FKUserId);
return(View(notification));
}
public ActionResult UserEdit([Bind(Include = "UserID,UserName,Password,FirstName,LastName,Company,CompanyLogo,Email")] User user)
{
TakimOmruDBEntities db = new TakimOmruDBEntities();
if (ModelState.IsValid)
{
if (Request.Files.Count > 0)
{
//Guid nesnesini benzersiz dosya adı oluşturmak için tanımladık ve Replace ile aradaki “-” işaretini atıp yan yana yazma işlemi yaptık.
string DosyaAdi = Guid.NewGuid().ToString().Replace("-", "");
//Kaydetceğimiz resmin uzantısını aldık.
string uzanti = System.IO.Path.GetExtension(Request.Files[0].FileName);
string TamYolYeri = "/Images/" + DosyaAdi + uzanti;
//Eklediğimiz Resni Server.MapPath methodu ile Dosya Adıyla birlikte kaydettik.
Request.Files[0].SaveAs(Server.MapPath(TamYolYeri));
//Ve veritabanına kayıt için dosya adımızı değişkene aktarıyoruz.
user.CompanyLogo = DosyaAdi + uzanti;
}
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Profil", "Home"));
}
return(View(user));
}
public ActionResult DeletePiece(int?id)
{
TakimOmruDBEntities db = new TakimOmruDBEntities();
Piece piece = db.Piece.Find(id);
db.Piece.Remove(piece);
db.SaveChanges();
return(RedirectToAction("Indexx"));
}
public ActionResult DeleteConfirmed(int id)
{
TakimOmruDBEntities db = new TakimOmruDBEntities();
Note note = db.Notes.Find(id);
db.Notes.Remove(note);
db.SaveChanges();
return(RedirectToAction("Note"));
}
public ActionResult ParcaSil(FormCollection form)
{
var id = Convert.ToInt32(form["parcaid"]);
using (var ctx = new TakimOmruDBEntities())
{
SubPiece sub = ctx.SubPiece.Find(id);
ctx.SubPiece.Remove(sub);
ctx.SaveChanges();
}
return(RedirectToAction("TakimOmru", "Home"));
}
public ActionResult Upload(FormCollection formCollection)
{
var subpieceList = new List <Kapasitematik_TakimOmru_v3.SubPiece>();
if (Request != null)
{
HttpPostedFileBase file = Request.Files["UploadedFile"];
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
string fileName = file.FileName;
string fileContentType = file.ContentType;
byte[] fileBytes = new byte[file.ContentLength];
var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength));
using (var package = new ExcelPackage(file.InputStream))
{
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
for (int rowIterator = 1; rowIterator <= noOfRow; rowIterator++)
{
var subpiece = new Kapasitematik_TakimOmru_v3.SubPiece();
subpiece.SubPieceName = workSheet.Cells[rowIterator, 1].Value.ToString();
subpiece.ToolLife = Convert.ToInt32(workSheet.Cells[rowIterator, 2].Value);
subpieceList.Add(subpiece);
}
}
}
}
using (TakimOmruDBEntities db = new TakimOmruDBEntities())
{
foreach (var item in subpieceList)
{
db.SubPiece.Add(new SubPiece()
{
SubPieceName = item.SubPieceName,
ToolLife = item.ToolLife,
FKPieceID = Convert.ToInt32(formCollection["id"]),
Type = Convert.ToBoolean("false")
});
}
db.SaveChanges();
}
return(RedirectToAction("TakimOmru", "Home"));
}
public ActionResult ParcaGuncelle(SubPiece subPiece, FormCollection form)
{
TakimOmruDBEntities db = new TakimOmruDBEntities();
var id = Convert.ToInt32(form["par"]);
var existingsubpiece = db.SubPiece.Where(s => s.SubPieceID == id).FirstOrDefault();
if (existingsubpiece != null)
{
existingsubpiece.SubPieceName = subPiece.SubPieceName;
existingsubpiece.ToolLife = subPiece.ToolLife;
db.SaveChanges();
}
return(RedirectToAction("TakimOmru", "Home"));
}
public ActionResult Create([Bind(Include = "SubPieceID,SubPieceName,ToolLife,Now,FKPieceID,FKUserID,Type")] SubPiece subPiece)
{
//ViewBag.Data = new SelectList(db.PimsunDeviceNoes, "DeviceNo", "MachineName", piece.FKDeviceID);
TakimOmruDBEntities db = new TakimOmruDBEntities();
if (ModelState.IsValid)
{
db.SubPiece.Add(subPiece);
db.SaveChanges();
return(RedirectToAction("TakimOmru", "Home"));
}
ViewBag.FKPieceID = new SelectList(db.Piece, "PieceID", "PieceName", subPiece.FKPieceID);
ViewBag.FKUserID = new SelectList(db.User, "UserID", "UserName", subPiece.FKUserID);
return(RedirectToAction("TakimOmru", "Home"));
}
public ActionResult Edit([Bind(Include = "PieceID,PieceName,FKUserID,CreatedDate,Adet")] Piece piece)
{
ViewBag.UserID = Session["UserID"];
int ID = Convert.ToInt32(Session["UserID"]);
TakimOmruDBEntities db = new TakimOmruDBEntities();
if (ModelState.IsValid)
{
piece.FKUserID = ID;
piece.Adet = 0;
piece.CreatedDate = DateTime.Now;
db.Entry(piece).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Indexx"));
}
ViewBag.FKUserID = new SelectList(db.User, "UserID", "UserName", piece.FKUserID);
return(View(piece));
}
public ActionResult AddUser(FormCollection form)
{
TakimOmruDBEntities db = new TakimOmruDBEntities();
User user = new User();
//eğer dosya gelmişse işlemleri yap
if (Request.Files.Count > 0)
{
//Guid nesnesini benzersiz dosya adı oluşturmak için tanımladık ve Replace ile aradaki “-” işaretini atıp yan yana yazma işlemi yaptık.
string DosyaAdi = Guid.NewGuid().ToString().Replace("-", "");
//Kaydetceğimiz resmin uzantısını aldık.
string uzanti = System.IO.Path.GetExtension(Request.Files[0].FileName);
string TamYolYeri = "/Images/" + DosyaAdi + uzanti;
//Eklediğimiz Resni Server.MapPath methodu ile Dosya Adıyla birlikte kaydettik.
Request.Files[0].SaveAs(Server.MapPath(TamYolYeri));
//Ve veritabanına kayıt için dosya adımızı değişkene aktarıyoruz.
user.CompanyLogo = DosyaAdi + uzanti;
}
user.Company = form["company"];
user.FirstName = form["firstname"];
user.LastName = form["lastname"];
user.Email = form["email"];
user.UserName = form["username"];
//user.Password = hs.PassHass(form["password"]);
user.Password = form["password"];
db.User.Add(user);
db.SaveChanges();
return(Redirect("Login"));
//using (var client = new HttpClient())
//{
// client.BaseAddress = new Uri("https://1ns5809cw0.execute-api.eu-west-2.amazonaws.com/Prod/");
// client.DefaultRequestHeaders.Accept.Clear();
// client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
// HttpResponseMessage response = client.PostAsJsonAsync("api/Login/AddUser", user).Result;
// if (response.IsSuccessStatusCode)
// {
// return RedirectToAction("Login");
// }
// return null;
//}
}
public ActionResult ParcaEklee(Piece piece)
{
var sessionId = Convert.ToInt32(Session["UserID"]);
TakimOmruDBEntities db = new TakimOmruDBEntities();
ViewBag.Data = new SelectList(db.PimsunDeviceNoes, "DeviceNo", "MachineName", piece.FKDeviceID);
try
{
db.Piece.Add(new Piece()
{
PieceName = piece.PieceName,
CreatedDate = piece.CreatedDate.GetValueOrDefault(DateTime.Now),
FKUserID = sessionId,
FKDeviceID = piece.FKDeviceID
});
db.SaveChanges();
return(RedirectToAction("Indexx"));
}
catch (Exception)
{
return(RedirectToAction("ParcaEkle"));
}
}
public ActionResult TakimOmru(Notification noti, [Bind(Include = "NoteID,NoteHeader,NoteDescription,CreatedDate,FkPieceID,FkSubPieceID,FkUserID")] Note note)
{
//ActionResult result = null;
TakimOmruDBEntities db = new TakimOmruDBEntities();
ViewBag.FKPieceID = new SelectList(db.Piece, "PieceID", "PieceName");
//ViewBag.FkSubPieceID = new SelectList(db.SubPiece, "SubPieceID", "SubPieceName");
//ViewBag.FkUserID = new SelectList(db.User, "UserID", "UserName");
if (Session["UserID"] == null)
{
return(RedirectToAction("Login", "Login"));
}
ViewBag.UserID = Session["UserID"];
ViewBag.Company = Session["Company"];
ViewBag.Logo = Session["Logo"];
ViewBag.Name = Session["FirstName"];
int UserId = Convert.ToInt32(Session["UserID"]);
ThreeModel tm = new ThreeModel();
tm.notification = db.Notification.ToList();
tm.pieces = db.Piece.ToList();
tm.subpieces = db.SubPiece.ToList();
tm.notes = db.Notes.ToList();
ViewBag.FkPieceIDd = new SelectList(db.Piece, "PieceID", "PieceName", note.FkPieceID);
ViewBag.FkSubPieceID = new SelectList(db.SubPiece, "SubPieceID", "SubPieceName", note.FkSubPieceID);
ViewBag.FkUserID = new SelectList(db.User, "UserID", "UserName", note.FkUserID);
var altkategori = from s in db.SubPiece
join dt in db.Detail on s.SubPieceID equals dt.FKSubPieceID
where s.FKUserID == UserId
select new
{
SubPieceId = s.SubPieceID,
SubPieceName = s.SubPieceName,
ToolLife = s.ToolLife,
PieceID = s.FKPieceID,
PieceCount = dt.PieceCount,
};
var data = altkategori.GroupBy(x => x.SubPieceId).Select(x => new
{
SubPieceId = x.FirstOrDefault().SubPieceId,
SubPieceName = x.FirstOrDefault().SubPieceName,
ToolLife = x.FirstOrDefault().ToolLife,
PieceID = x.FirstOrDefault().PieceID,
PieceCount = x.Sum(y => y.PieceCount),
}).Where(v => v.PieceCount > (v.ToolLife * 2) / 3);
if (data != null && data.Any())
{
foreach (var item in data)
{
db.Notification.Add(new Notification()
{
NotificationID = noti.NotificationID,
Notification_Description = noti.Notification_Description = (item.SubPieceName) + " " + "parçasının ömrü tükenmek üzere Kalan parça sayısı " + (item.ToolLife - item.PieceCount),
Count = noti.Count = 0,
FKUserId = UserId,
Notification_Date = noti.Notification_Date.GetValueOrDefault(DateTime.Now),
});
}
db.SaveChanges();
}
//var noti = db.Notification.ToList();
//ViewBag.PieceID = new SelectList(db.Piece, "PieceId", "PieceName", subPiece.FKPieceID);
//ViewBag.Message = "Your application description page.";
//ViewBag.Piece = new SelectList(db.Piece, "PieceId", "PieceName");
//var prodecure= db.SP_Notification_Update_Counter_v1(UserId);
return(View(tm));
}