public ActionResult Create()
{
string actionName = "Create";
PartsViewModels response = new PartsViewModels();
try
{
_logger.Log(LogLevel.Trace, actionName + " :: started.");
using (var db = new WebAppDbContext())
{
response = new PartsViewModels
{
_tbl_Cage = db.tbl_Cage.ToList(),
_tbl_PartType = db.tbl_PartType.ToList(),
_tbl_MCAT = db.tbl_MCAT.ToList(),
_tbl_Currency = db.tbl_Currency.ToList(),
};
}
}
catch (Exception ex)
{
_logger.Log(LogLevel.Error, actionName + " EXCEPTION :: " + ex.ToString() + " INNER EXCEPTION :: " + ex.InnerException?.ToString());
}
_logger.Log(LogLevel.Trace, actionName + " :: ended.");
return(PartialView("_Create", response));
}
public ActionResult GetSelectedData(int parentPartId)
{
string actionName = "GetSelectedData";
var vm = new PartsViewModels();
try
{
_logger.Log(LogLevel.Trace, actionName + " :: started.");
if (parentPartId != 0)
{
vm = GetData(parentPartId);
}
else
{
_logger.Log(LogLevel.Trace, actionName + " :: ended.");
Alert("Their is something went wrong!!!", NotificationType.error);
return(Json(vm, JsonRequestBehavior.AllowGet));
}
_logger.Log(LogLevel.Trace, actionName + " :: ended.");
return(Json(vm.ChildPartsModel_list, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
_logger.Log(LogLevel.Error, actionName + " EXCEPTION :: " + ex.ToString() + " INNER EXCEPTION :: " + ex.InnerException?.ToString());
Exception(ex);
Alert("Their is something went wrong!!!", NotificationType.error);
return(Json(vm, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit(int id)
{
string actionName = "Edit";
PartsViewModels objPartsViewModels = new PartsViewModels();
try
{
_logger.Log(LogLevel.Trace, actionName + " :: started.");
if (id <= 0)
{
_logger.Log(LogLevel.Trace, actionName + " :: ended.");
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
else
{
objPartsViewModels = GetParts(id);
}
}
catch (Exception ex)
{
_logger.Log(LogLevel.Error, actionName + " EXCEPTION :: " + ex.ToString() + " INNER EXCEPTION :: " + ex.InnerException?.ToString());
}
_logger.Log(LogLevel.Trace, actionName + " :: ended.");
return(PartialView("_Edit", objPartsViewModels));
}
public async Task <IActionResult> CreateParts(string input = null)
{
_logger.LogInformation("admin view create parts");
var viewModel = new PartsViewModels
{
Text = input,
};
return(this.View(viewModel));
}
// new child part
public ActionResult ChildPart()
{
using (var db = new WebAppDbContext())
{
var vm = new PartsViewModels
{
tbl_Parts_list = db.tbl_Parts.Where(x => x.Status == "Active").ToList(),
};
return(View(vm));
}
}
public async Task <IActionResult> CreateParts(PartsViewModels input)
{
_logger.LogInformation("admin creat opinions");
if (!this.ModelState.IsValid)
{
return(this.View(input));
}
var text = create.CreateParts(input);
return(this.RedirectToAction("CreateParts", "Admin", new { input = text }));
}
public async Task <string> CreateParts(PartsViewModels input)
{
dbContext.Add(new PartsCars
{
Type = input.Type,
Name = input.Name,
Price = input.Price,
Strength = input.Strength,
Speed = input.Speed,
});
await dbContext.SaveChangesAsync();
return("Часта е успешно създадено.");
}
private PartsViewModels GetParts(int id)
{
using (var db = new WebAppDbContext())
{
var viewModel = new PartsViewModels()
{
tbl_Parts = db.tbl_Parts.Where(x => x.PartId == id).SingleOrDefault(),
_tbl_Cage = db.tbl_Cage.ToList(),
_tbl_PartType = db.tbl_PartType.ToList(),
_tbl_MCAT = db.tbl_MCAT.ToList(),
_tbl_Currency = db.tbl_Currency.ToList(),
};
return(viewModel);
}
}
public ActionResult EditChildPart(ChildPartsModel model)
{
using (var db = new WebAppDbContext())
{
using (var transaction = db.Database.BeginTransaction())
{
PartsViewModels vm = new PartsViewModels();
try
{
if (!ModelState.IsValid)
{
Alert("Their is something went wrong!!!", NotificationType.error);
return(Json(model, JsonRequestBehavior.AllowGet));
}
if (model.ParentPartId != 0 && model.ChildPartId != 0)
{
var obj = new tbl_ChildParts()
{
ParentPartId = model.ParentPartId,
ChildPartId = model.ChildPartId,
Qty = model.Qty,
};
db.Entry(obj).State = EntityState.Modified;
}
db.SaveChanges();
transaction.Commit();
int?parentPartId = model.ParentPartId;
if (parentPartId != 0)
{
vm = GetData(parentPartId);
}
// Alert("Data Saved Sucessfully!!!", NotificationType.success);
return(Json(vm.ChildPartsModel_list, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
transaction.Rollback();
Exception(ex);
Alert("Their is something went wrong!!!", NotificationType.error);
return(Json(vm));
}
}
}
}
public ActionResult AddChildPart(tbl_ChildParts model)
{
string actionName = "AddChildPart";
_logger.Log(LogLevel.Trace, actionName + " :: started.");
using (var db = new WebAppDbContext())
{
using (var transaction = db.Database.BeginTransaction())
{
PartsViewModels vm = new PartsViewModels();
try
{
if (!ModelState.IsValid)
{
_logger.Log(LogLevel.Trace, actionName + " :: ended.");
Alert("Their is something went wrong!!!", NotificationType.error);
return(Json(model, JsonRequestBehavior.AllowGet));
}
if (model.ParentPartId != 0 && model.ChildPartId != 0)
{
db.tbl_ChildParts.Add(model);
db.SaveChanges();
transaction.Commit();
}
int?parentPartId = model.ParentPartId;
if (parentPartId != 0)
{
vm = GetData(parentPartId);
}
_logger.Log(LogLevel.Trace, actionName + " :: ended.");
// Alert("Data Saved Sucessfully!!!", NotificationType.success);
return(Json(vm.ChildPartsModel_list, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
_logger.Log(LogLevel.Error, actionName + " EXCEPTION :: " + ex.ToString() + " INNER EXCEPTION :: " + ex.InnerException?.ToString());
transaction.Rollback();
Exception(ex);
Alert("Their is something went wrong!!!", NotificationType.error);
return(Json(vm));
}
}
}
}
public PartsViewModels GetData(int?parentPartId)
{
var vm = new PartsViewModels();
using (var db = new WebAppDbContext())
{
if (parentPartId != 0)
{
var result = db.tbl_ChildParts.Where(x => x.ParentPartId == parentPartId).Select(x => new ChildPartsModel
{
ParentPartId = x.ParentPartId,
ChildPartId = x.ChildPartId,
ChildPartName = x.tbl_Parts.PART_NAME,
ChildPartNo = x.tbl_Parts.Part_No,
Qty = x.Qty
}).ToList();
vm.ChildPartsModel_list = result;
}
}
return(vm);
}
public ActionResult Index()
{
string actionName = "Index";
List <GraphData> data = new List <GraphData>();
PartsViewModels vm = new PartsViewModels();
try
{
_logger.Log(LogLevel.Trace, actionName + " :: started.");
using (var db = new WebAppDbContext())
{
vm = new PartsViewModels
{
cageActiveCount = db.tbl_Cage.Where(x => x.Status == "Active").Count(),
partsCount = db.tbl_Parts.Count(),
partTypeCount = db.tbl_PartType.Count(),
};
foreach (var item in vm._tbl_PartType = db.tbl_PartType.ToList())
{
GraphData details = new GraphData();
details.label = item.PartName;
var id = item.PartTypeID;
details.value = db.tbl_Parts.Where(x => x.PartTypeID == id && x.Status == "Active").Count();
data.Add(details);
}
vm.dataList = data;
}
}
catch (Exception ex)
{
_logger.Log(LogLevel.Error, actionName + " EXCEPTION :: " + ex.ToString() + " INNER EXCEPTION :: " + ex.InnerException?.ToString());
}
_logger.Log(LogLevel.Trace, actionName + " :: ended.");
return(View(vm));
}
public void CorrectCreateParts()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString());
var repository = new ApplicationDbContext(options.Options);
var service = new CreateServices(repository);
var car = new CarServices(repository);
var input = new PartsViewModels
{
Type = PartsCarsType.Aerodynamics,
Name = "Aerodynamics",
Price = 1000,
Strength = 100,
Speed = 10,
};
var result = service.CreateParts(input);
Assert.Equal("Часта е успешно създадено.", result);
}
public ActionResult DeleteChildPart(int?childPartId, int?parentPartId)
{
using (var db = new WebAppDbContext())
{
using (var transaction = db.Database.BeginTransaction())
{
var vm = new PartsViewModels();
try
{
if (childPartId != null)
{
var result = db.tbl_ChildParts.Where(x => x.ChildPartId == childPartId).SingleOrDefault();
if (result != null)
{
db.tbl_ChildParts.Remove(result);
db.SaveChanges();
transaction.Commit();
}
}
if (parentPartId != 0)
{
vm = GetData(parentPartId);
}
// Alert("Record Deleted Sucessfully!!!", NotificationType.success);
return(Json(vm.ChildPartsModel_list, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
transaction.Rollback();
Exception(ex);
Alert("Their is something went wrong!!!", NotificationType.error);
return(Json(vm));
}
}
}
}
public ActionResult Edit(int id, tbl_Parts tbl_Parts, FileHelper FileHelper, PartsViewModels vm)
{
string actionName = "Edit";
try
{
_logger.Log(LogLevel.Trace, actionName + " :: started.");
using (var db = new WebAppDbContext())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
if (id <= 0)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (!ModelState.IsValid)
{
_logger.Log(LogLevel.Trace, actionName + " :: ended.");
PartsViewModels objPartsViewModels = GetParts(id);
return(PartialView("_Edit", objPartsViewModels));
}
if (FileHelper.File != null)
{
string savaPath = "";
string tempPath = "";
tempPath = "~/Images/Parts";
savaPath = Server.MapPath(tempPath);
if (!Directory.Exists(savaPath))
{
Directory.CreateDirectory(savaPath);
}
if (tbl_Parts.File_Path != null && tbl_Parts.PICTURE_FILE_NAME != null)
{
var imgPath = tbl_Parts.File_Path + tbl_Parts.PICTURE_FILE_NAME;
if (System.IO.File.Exists(imgPath))
{
System.IO.File.Delete(imgPath);
}
}
var fileName = Path.GetFileNameWithoutExtension(FileHelper.File.FileName);
var fileExtension = Path.GetExtension(FileHelper.File.FileName);
string image = @"\" + fileName + DateTime.Now.Ticks + fileExtension;
tbl_Parts.PICTURE_FILE_NAME = image;
tbl_Parts.FileExtension = fileExtension;
tbl_Parts.File_Path = savaPath;
FileHelper.File.SaveAs(savaPath + image);
}
// Get Current user Id
var userId = System.Web.HttpContext.Current.User.Identity.GetUserId();
tbl_Parts.ModifiedByUser = userId;
//Get Current Date & Time.
tbl_Parts.ModifiedOnDate = DateTime.Now;
tbl_Parts.Status = "Active";
db.Entry(tbl_Parts).State = EntityState.Modified;
db.SaveChanges();
transaction.Commit();
Alert("Record Updated Sucessfully!!!", NotificationType.success);
}
catch (Exception ex)
{
transaction.Rollback();
Exception(ex);
Alert("Their is something went wrong!!!", NotificationType.error);
}
}
}
}
catch (Exception ex)
{
_logger.Log(LogLevel.Error, actionName + " EXCEPTION :: " + ex.ToString() + " INNER EXCEPTION :: " + ex.InnerException?.ToString());
}
_logger.Log(LogLevel.Trace, actionName + " :: ended.");
return(RedirectToAction("Index"));
}
public ActionResult Create(tbl_Parts tbl_Parts, FileHelper FileHelper)
{
string actionName = "Create";
try
{
if (tbl_Parts != null)
{
_logger.Log(LogLevel.Trace, actionName + " :: started.");
using (var db = new WebAppDbContext())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
if (!ModelState.IsValid)
{
var vm = new PartsViewModels
{
_tbl_Cage = db.tbl_Cage.ToList(),
_tbl_PartType = db.tbl_PartType.ToList(),
_tbl_MCAT = db.tbl_MCAT.ToList(),
_tbl_Currency = db.tbl_Currency.ToList(),
};
return(PartialView("_Create", vm));
}
if (FileHelper.File != null)
{
string savaPath = "";
string tempPath = "";
tempPath = "~/Images/Parts";
savaPath = Server.MapPath(tempPath);
if (!Directory.Exists(savaPath))
{
Directory.CreateDirectory(savaPath);
}
var fileName = Path.GetFileNameWithoutExtension(FileHelper.File.FileName);
var fileExtension = Path.GetExtension(FileHelper.File.FileName);
string image = @"\" + fileName + DateTime.Now.Ticks + fileExtension;
tbl_Parts.PICTURE_FILE_NAME = image;
tbl_Parts.FileExtension = fileExtension;
tbl_Parts.File_Path = savaPath;
FileHelper.File.SaveAs(savaPath + image);
}
var cage = db.tbl_Cage.Where(x => x.CageCode == tbl_Parts.CageCode).FirstOrDefault();
tbl_Parts.CageId = cage.CageId;
// Get Current user Id
var userId = System.Web.HttpContext.Current.User.Identity.GetUserId();
tbl_Parts.CreatedByUser = userId;
tbl_Parts.ModifiedByUser = userId;
//Get Current Date & Time.
tbl_Parts.CreatedOnDate = DateTime.Now;
tbl_Parts.ModifiedOnDate = DateTime.Now;
tbl_Parts.Status = "Active";
db.tbl_Parts.Add(tbl_Parts);
db.SaveChanges();
transaction.Commit();
Alert("Data Saved Sucessfully!!!", NotificationType.success);
}
catch (Exception ex)
{
transaction.Rollback();
Exception(ex);
Alert("Their is something went wrong!!!", NotificationType.error);
}
}
}
}
}
catch (Exception ex)
{
_logger.Log(LogLevel.Error, actionName + " EXCEPTION :: " + ex.ToString() + " INNER EXCEPTION :: " + ex.InnerException?.ToString());
}
_logger.Log(LogLevel.Trace, actionName + " :: ended.");
return(RedirectToAction("Index"));
}
