public ActionResult CreateRequest(DirectPurchaseRequest model)
{
if (!ModelState.IsValid)
{
FillSO();
FillJC();
GetMaterials();
return(View("Create", model));
}
FillSO();
FillJC();
model.OrganizationId = OrganizationId;
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = UserID.ToString();
string referenceNo = new DirectPurchaseRepository().InsertDirectPurchaseRequest(model);
if (referenceNo != "")
//if (new DirectPurchaseRepository().InsertDirectPurchaseRequest(model) > 0)
{
TempData["success"] = "Saved successfully. Reference No. is " + referenceNo;
TempData["error"] = "";
return(RedirectToAction("CreateRequest"));
}
else
{
GetMaterials();
TempData["success"] = "";
TempData["error"] = "Some error occured. Please try again.";
return(View("Create", model));
}
}
public ActionResult ViewPurchaseIndent(int id = 0)
{
try
{
if (id == 0)
{
TempData["error"] = "That was an invalid/unknown request. Please try again.";
return(RedirectToAction("Index", "Home"));
}
var model = new DirectPurchaseRepository().GetPurchaseIndent(id, OrganizationId);
Session["purchaseIndent"] = model;
if (model == null)
{
TempData["error"] = "Could not find the requested Purchase Indent. Please try again.";
return(RedirectToAction("Index", "Home"));
}
FillPartNo();
GetMaterials();
return(View("View", model));
}
catch (Exception)
{
TempData["error"] = "Some error occured. Please try again.";
return(RedirectToAction("PurchaseIndents"));
}
}
public ActionResult Delete(int Id)
{
ViewBag.Title = "Delete";
var result1 = new DirectPurchaseRepository().CHECK(Id);
if (result1 > 0)
{
TempData["error"] = "Sorry!!..Already Used!!";
TempData["PurchaseRequestNo"] = null;
return(RedirectToAction("Edit", new { id = Id }));
}
else
{
var result2 = new DirectPurchaseRepository().DeleteDirectPurchaseDT(Id);
var result3 = new DirectPurchaseRepository().DeleteDirectPurchaseHD(Id, UserID.ToString());
if (Id > 0)
{
TempData["Success"] = "Deleted Successfully!";
//return RedirectToAction("PreviousList");
return(RedirectToAction("Index"));
}
else
{
TempData["error"] = "Oops!!..Something Went Wrong!!";
TempData["SupplyOrderNo"] = null;
return(RedirectToAction("Edit", new { id = Id }));
}
}
}
public ActionResult Edit(DirectPurchaseRequest model)
{
ViewBag.Title = "Edit";
model.OrganizationId = OrganizationId;
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = UserID.ToString();
FillSO();
FillJC();
GetMaterials();
var repo = new DirectPurchaseRepository();
var result1 = new DirectPurchaseRepository().CHECK(model.DirectPurchaseRequestId);
if (result1 > 0)
{
TempData["error"] = "Sorry!!..Already Used!!";
TempData["PurchaseRequestNo"] = null;
return(View("Edit", model));
}
else
{
try
{
var result2 = new DirectPurchaseRepository().DeleteDirectPurchaseDT(model.DirectPurchaseRequestId);
var result3 = new DirectPurchaseRepository().DeleteDirectPurchaseHD(model.DirectPurchaseRequestId, UserID.ToString());
string id = new DirectPurchaseRepository().InsertDirectPurchaseRequest(model);
TempData["success"] = "Updated successfully. Direct Purchase Request Reference No. is " + id;
TempData["error"] = "";
return(RedirectToAction("Index"));
}
catch (SqlException sx)
{
TempData["error"] = "Some error occured while connecting to database. Please check your network connection and try again.|" + sx.Message;
}
catch (NullReferenceException nx)
{
TempData["error"] = "Some required data was missing. Please try again.|" + nx.Message;
}
catch (Exception ex)
{
TempData["error"] = "Some error occured. Please try again.|" + ex.Message;
}
return(RedirectToAction("CreateRequest"));
}
}
public JsonResult GetPurchaseLimit()
{
string str;
try
{
int organizationId = OrganizationId;
str = new DirectPurchaseRepository().GetPurchaseLimit(organizationId);
}
catch (Exception)
{
str = "error";
}
return(Json(str, JsonRequestBehavior.AllowGet));
}
public ActionResult DeletePurchaseIndent(int id = 0)
{
try
{
if (id == 0)
{
return(RedirectToAction("Index", "Home"));
}
string result = new DirectPurchaseRepository().DeletePurchaseIndent(id);
TempData["Success"] = "Deleted Successfully!";
return(RedirectToAction("PurchaseIndents"));
}
catch (Exception)
{
TempData["error"] = "Some error occured while deleting. Please try again.";
return(RedirectToAction("PurchaseIndent", new { id = id }));
}
}
public ActionResult Edit(int id = 0)
{
try
{
if (id != 0)
{
FillSO();
FillJC();
GetMaterials();
FillPartNo();
DirectPurchaseRequest DirectPurchaseRequest = new DirectPurchaseRequest();
DirectPurchaseRequest = new DirectPurchaseRepository().GetDirectPurchaseRequest(id);
DirectPurchaseRequest.items = new DirectPurchaseRepository().GetDirectPurchaseRequestItems(id);
return(View(DirectPurchaseRequest));
}
else
{
TempData["error"] = "That was an invalid/unknown request. Please try again.";
TempData["success"] = "";
}
}
catch (InvalidOperationException iox)
{
TempData["error"] = "Sorry, we could not find the requested item. Please try again.|" + iox.Message;
}
catch (SqlException sx)
{
TempData["error"] = "Some error occured while connecting to database. Please try again after sometime.|" + sx.Message;
}
catch (NullReferenceException nx)
{
TempData["error"] = "Some required data was missing. Please try again.|" + nx.Message;
}
catch (Exception ex)
{
TempData["error"] = "Some error occured. Please try again.|" + ex.Message;
}
TempData["success"] = "";
return(RedirectToAction("CreateRequest"));
}
public JsonResult ValidateForm(string requestNo, int total = 0)
{
int val1 = new DirectPurchaseRepository().isNotExist(requestNo);
int val2 = new DirectPurchaseRepository().validateTotal(total);
string str = "";
if (val1 != 1)
{
str += "Purchase request number already exists";
}
if (val2 != 1)
{
str += "|Total amount should not exceed the purchase limit";
}
if (str.Length == 0)
{
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
return(Json(new { status = false, message = str }, JsonRequestBehavior.AllowGet));
}
public ActionResult EditPurchaseIndent(DirectPurchaseRequest model)
{
try
{
model.CreatedBy = UserID.ToString();
model.CreatedDate = DateTime.Today;
var success = new DirectPurchaseRepository().UpdatePurchaseIndent(model);
if (success <= 0)
{
throw new Exception();
}
TempData["success"] = "Updated successfully (" + model.PurchaseRequestNo + ")";
return(RedirectToAction("PurchaseIndents"));
}
catch (Exception)
{
TempData["error"] = "Some error occured while saving. Please try again.";
FillPartNo();
GetMaterials();
return(View("PurchaseIndent", model));
}
}
public ActionResult PurchaseIndent(DirectPurchaseRequest model)
{
try
{
model.CreatedBy = UserID.ToString();
model.OrganizationId = OrganizationId;
model.CreatedDate = DateTime.Today;
string ref_no = new DirectPurchaseRepository().InsertPurchaseIndent(model);
if (ref_no.Length > 0)
{
TempData["success"] = "Saved Successfully. Reference No. is " + model.PurchaseRequestNo;
return(RedirectToAction("PurchaseIndent"));
}
else
{
throw new Exception();
}
}
catch (Exception)
{
TempData["error"] = "Some error occurred while saving. Please try again.";
return(View(model));
}
}
public ActionResult LoadQuickView()
{
if (Session["user"] == null)
{
return(RedirectToAction("LogOff", "Account"));
}
QuickView view = new QuickView();
view.PendingDirectPurchaseRequests = true;
view.PendingTransQuotations = true;
view.PendingProjectQuotations = true;
view.PendingSupplyOrders = true;
view.PendingWorkshopRequests = true;
view.PendingProjectSaleOrdersForJobCard = true;
view.PendingTransSaleOrdersForJobCard = true;
view.MaterialStockBelowMinLevel = true;
view.PendingVechicleInpass = true;
view.PendingWRForStoreIssue = true;
view.PendingJobcardQC = true;
view.PendingMaterialReqPRS = true;
if (view.PendingProjectQuotations)
{
SalesQuotationRepository repo = new SalesQuotationRepository();
var res = repo.GetSalesQuotationApproveList(1, 0, OrganizationId);
view.NoOfProjectQuotations = res.Count;
}
if (view.PendingTransQuotations)
{
SalesQuotationRepository repo = new SalesQuotationRepository();
var res = repo.GetSalesQuotationApproveList(0, 0, OrganizationId);
view.NoOfTransQuotations = res.Count;
}
if (view.PendingSupplyOrders)
{
var repo = new GRNRepository();
var res = repo.GetGRNPendingList(0);
view.NoOfSupplyOrders = res.Count();
}
if (view.PendingDirectPurchaseRequests)
{
var res = new DirectPurchaseRepository().GetUnApprovedRequests(UserID);
view.NoOfPurchaseRequests = res.Count;
}
if (view.PendingWorkshopRequests)
{
var rep = new SaleOrderRepository();
var slist = rep.GetSaleOrdersPendingWorkshopRequest(OrganizationId, 0);
view.NoOfWorkShopRequests = slist.Count;
}
if (view.PendingProjectSaleOrdersForJobCard)
{
var list = new JobCardRepository().GetPendingSO(1, OrganizationId, 0);
view.NoOfProjectSaleOrdersForJobCard = list.Count();
}
if (view.PendingTransSaleOrdersForJobCard)
{
var list = new JobCardRepository().GetPendingSO(0, OrganizationId, 0);
view.NoOfTransSaleOrdersForJobCard = list.Count();
}
if (view.MaterialStockBelowMinLevel)
{
var list = new ItemRepository().GetCriticalMaterialsBelowMinStock(OrganizationId);
view.NoOfMaterialStockBelowMinLevel = list.Count();
//view.NoOfMaterialStockBelowMinLevel = new ItemRepository().GetCriticalMaterialsBelowMinStock(OrganizationId);
}
if (view.PendingVechicleInpass)
{
var list = new VehicleInPassRepository().PendingVehicleInpassforAlert(OrganizationId);
view.NoOfVechicleInpass = list.Count();
}
if (view.PendingWRForStoreIssue)
{
var list = new WorkShopRequestRepository().PendingWorkshopRequests("", "", "", "");
view.NoOfWRForStoreIssue = list.Count();
}
if (view.PendingJobcardQC)
{
var list = new DeliveryChallanRepository().PendingDelivery(OrganizationId);
view.NoOfJobcardQC = list.Count();
}
if (view.PendingMaterialReqPRS)
{
var list = new PurchaseRequestRepository().GetWorkShopRequestPending(OrganizationId, 0, "", "all");
view.NoOfPendingMaterialReqPRS = list.Count();
}
IEnumerable <ERPAlerts> Alerts;
if (Session["alertpermissions"] == null)
{
UserRepository repo = new UserRepository();
Alerts = repo.GetAlerts(UserID);
Session["alertpermissions"] = Alerts;
}
else
{
Alerts = (IEnumerable <ERPAlerts>)Session["alertpermissions"];
Session["alertpermissions"] = Alerts;
}
AlertPermission alertpermission = new AlertPermission();
foreach (var item in Alerts)
{
if (item.HasPermission == 1)
{
switch (item.AlertId)
{
case 1:
alertpermission.ProjectQuotApproval = true;
break;
case 2:
alertpermission.TransportQuotApproval = true;
break;
case 3:
alertpermission.PendingSupplyOrdForGrn = true;
break;
case 4:
alertpermission.DirectPurchaseReqDorApproval = true;
break;
case 5:
alertpermission.PendingSOForWorkshopReq = true;
break;
//case 6:
// alertpermission.PendingProjectSaleOrdersForJobCard = true;
// break;
//case 7:
// alertpermission.PendingTransSaleOrdersForJobCard = true;
// break;
case 6:
alertpermission.MaterialStockBelowMinLevel = true;
break;
case 7:
alertpermission.PendingVechicleInpass = true;
break;
case 8:
alertpermission.PendingWRForStoreIssue = true;
break;
case 9:
alertpermission.PendingJobcardQC = true;
break;
case 10:
alertpermission.PendingMaterialReqPRS = true;
break;
default:
break;
}
}
}
ViewBag.AlertPermissions = alertpermission;
return(PartialView("_QuickView", view));
}
