public VehicleAuctionViewModel GeById(int id)
{
VehicleAuctionViewModel model = ent.VehicleAuctions.Select(x => new VehicleAuctionViewModel()
{
VehicleAuctionId = x.VehicleAuctionId,
DeletedDate = x.DeletedDate,
DeletedBy = x.DeletedBy,
UpdatedBy = x.UpdatedBy,
UpdateDate = x.UpdateDate,
GA_ID = x.GA_ID,
PA_ID = x.PA_ID,
VehicleType = x.VehicleType,
Type = x.Type,
ApplicationRegistrationNumber = x.ApplicationRegistrationNumber,
RegistrationDate = x.RegistrationDate,
RegistrationDatep = x.RegistrationDatep,
DecisionDate = x.DecisionDate,
DecisionDateNp = x.DecisionDateNp,
VehicleNumber = x.VehicleNumber,
SummaryOfDecision = x.SummaryOfDecision,
Remarks = x.Remarks,
CreatedDate = DateTime.Now,
CreatedBy = x.CreatedBy
}).Where(x => x.VehicleAuctionId == id).FirstOrDefault();
return(model);
}
public ActionResult Index()
{
VehicleAuctionViewModel model = new VehicleAuctionViewModel();
model.VehicleAuctionViewModelList = pro.GetList();
return(View(model));
}
public ActionResult InsertUpdate(int?id)
{
VehicleAuctionViewModel model = new VehicleAuctionViewModel();
if (id > 0)
{
model = pro.GeById(id ?? 0);
}
return(View(model));
}
public ActionResult InsertUpdate(VehicleAuctionViewModel model)
{
try
{
var result = pro.InsertVehicleAuction(model);
if (result == true)
{
TempData["SuccessMsg"] = "सफल भयो";
return(RedirectToAction("Index"));
}
}
catch
{
TempData["Msg"] = "असफल भयो ";
return(View());
}
return(View());
}
public ActionResult Details(int id)
{
VehicleAuctionViewModel abc = pro.GeById(id);
return(PartialView(abc));
}
public bool InsertVehicleAuction(VehicleAuctionViewModel model)
{
using (SamajkalyanEntities ent = new SamajkalyanEntities())
{
try
{
var workPermitRow = ent.VehicleAuctions.Where(x => x.VehicleAuctionId == model.VehicleAuctionId).FirstOrDefault();
if (workPermitRow == null)
{
workPermitRow = new VehicleAuction();
}
;
workPermitRow.GA_ID = model.GA_ID;
workPermitRow.PA_ID = model.PA_ID;
workPermitRow.ApplicationRegistrationNumber = model.ApplicationRegistrationNumber;
workPermitRow.VehicleNumber = model.VehicleNumber;
workPermitRow.Type = model.Type;
workPermitRow.VehicleNumber = model.VehicleNumber;
workPermitRow.SummaryOfDecision = model.SummaryOfDecision;
workPermitRow.RegistrationDate = model.RegistrationDate;
workPermitRow.RegistrationDatep = model.RegistrationDatep;
workPermitRow.VehicleType = model.VehicleType;
workPermitRow.Remarks = model.Remarks;
workPermitRow.CreatedBy = model.CreatedBy;
workPermitRow.CreatedDate = model.CreatedDate;
if (model.VehicleAuctionId == 0)
{
ent.VehicleAuctions.Add(workPermitRow);
ent.SaveChanges();
}
else
{
workPermitRow.UpdatedBy = model.UpdatedBy;
workPermitRow.UpdateDate = model.UpdateDate;
ent.VehicleAuctions.Attach(workPermitRow);
ent.Entry(workPermitRow).State = EntityState.Modified;
ent.SaveChanges();
}
//if (model.ImportId <= 0)
//{
// model.ImportId = ent.Database.SqlQuery<WorkPermitViewModel>("select * from WorkPermit where WorkPermitId=(select max (WorkPermitId) from WorkPermit )").ToList().FirstOrDefault().WorkPermitId;
// //employeeRow.EmpId=employeeRow.EmpId != 0 ? employeeRow.EmpId : empModel.EmpId;
//}
}
catch (Exception ex)
{
return(false);
}
}
return(true);
}
