public JsonResult GetReqNoticountres()
{
ReqList obj = new ReqList();
DataSet ds = obj.Show_Reqnoticount1();
List <RequestVM> listreq = new List <RequestVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
listreq.Add(new RequestVM
{
count = Convert.ToInt32(dr["NotiCount"])
});
}
return(Json(listreq, JsonRequestBehavior.AllowGet));
}
public ActionResult GetLineChartData(int?y)
{
ReqList r = new ReqList();
DataSet ds = r.Get_Months(y);
List <PoVM> list = new List <PoVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new PoVM
{
month = DateTimeFormatInfo.CurrentInfo.GetAbbreviatedMonthName(Convert.ToInt32(dr["month"])),
total = Convert.ToDecimal(dr["Total"])
});
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
public List <ProcureVM> GetReturnDetails(int?id)
{
ReqList li = new ReqList();
DataSet ds = li.Show_returniteminreport(id);
List <ProcureVM> procure = new List <ProcureVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
procure.Add(new ProcureVM
{
ItemName = dr["ItemName"].ToString(),
DeliveredQuantity = Convert.ToInt32(dr["DeliveredQuantity"]),
RejectedQuantity = Convert.ToInt32(dr["RejectedQuantity"])
});
}
return(procure);
}
public List <ProcureVM> GetPODetails(int?id)
{
ReqList li = new ReqList();
DataSet ds = li.Show_poiteminreport(id);
List <ProcureVM> procure = new List <ProcureVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
procure.Add(new ProcureVM
{
ItemName = dr["ItemName"].ToString(),
Quantity = Convert.ToInt32(dr["Quantity"]),
Total = Convert.ToDecimal(dr["TotalPrice"])
});
}
return(procure);
}
public JsonResult GetEmpProres()
{
ReqList obj = new ReqList();
DataSet ds = obj.Show_Emppronoti();
List <PositionVM> listpro = new List <PositionVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
listpro.Add(new PositionVM
{
Position = dr["Position"].ToString(),
Experience = dr["Experience"].ToString(),
EmployeeId = Convert.ToInt32(dr["EmployeeId"])
});
}
return(Json(listpro, JsonRequestBehavior.AllowGet));
}
public ActionResult GetGRDataforReturnddl(int id)
{
ReqList li = new ReqList();
DataSet ds = li.Show_GRdataforrdddl(id);
List <ProcureVM> list = new List <ProcureVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new ProcureVM
{
ItemId = Convert.ToInt32(dr["ItemId"]),
ItemName = dr["ItemName"].ToString()
});
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
public ActionResult GetBarChartData()
{
ReqList r = new ReqList();
DataSet ds = r.Get_TotalStock();
List <PoVM> list = new List <PoVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new PoVM
{
ItemName = dr["ItemName"].ToString(),
AvailableStock = Convert.ToInt32(dr["Availablestock"]),
QualityStock = Convert.ToInt32(dr["Qualityinspectionstock"]),
ReorderPoint = Convert.ToInt32(dr["ReorderPoint"])
});
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
// GET: RequestPayment
public ActionResult Index(int?i)
{
using (ABC_DBEntities1 db = new ABC_DBEntities1())
{
int BalanceModel = Int32.Parse(Session["userID"].ToString());
var BalanceDetail = db.Balances.Where(x => x.Client_ID == BalanceModel).FirstOrDefault();
intRemainingBalance = BalanceDetail.Balance1;
ClientID = BalanceDetail.Balance_ID;
}
ViewBag.UserID = Session["FullName"];
ViewBag.Balance = intRemainingBalance.ToString();
IEnumerable <RequestPList> ReqList;
HttpResponseMessage response = GlobalVariable.WebApiClient.GetAsync("RequestPLists").Result;
ReqList = response.Content.ReadAsAsync <IEnumerable <RequestPList> >().Result;
return(View(ReqList.ToPagedList(i ?? 1, 10)));
}
public ActionResult GetQuantityDataforrdm(int id)
{
var checkStatusofGr = obj.GetDoc().Where(x => x.DocumentNo == id && x.DocStatus == "Open").FirstOrDefault();
if (checkStatusofGr != null)
{
ReqList li = new ReqList();
DataSet ds = li.Show_QtyMissingDataingridforrdm(id);
List <ProcureVM> list = new List <ProcureVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new ProcureVM
{
ItemName = dr["ItemName"].ToString(),
RejectedQuantity = Convert.ToInt32(dr["MissingQuantity"]),
ApprovedQuantity = Convert.ToInt32(dr["AvailableQuantity"])
});
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
else
{
ReqList li = new ReqList();
DataSet ds = li.Show_QtyMissingDataingrid(id);
List <ProcureVM> list = new List <ProcureVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new ProcureVM
{
ItemName = dr["ItemName"].ToString(),
RejectedQuantity = Convert.ToInt32(dr["MissingQuantity"]),
ApprovedQuantity = Convert.ToInt32(dr["ApprovedQuantity"])
});
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetReturnDataforGR(int id)
{
var checkstatus = obj.GetDoc().Where(x => x.DocumentNo == id && x.Status == "Partial Delivery").FirstOrDefault();
if (checkstatus != null)
{
ReqList li = new ReqList();
DataSet ds = li.Show_ReturndataforGRPartial(id);
List <ProcureVM> list = new List <ProcureVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new ProcureVM
{
ItemType = dr["ItemType"].ToString(),
ItemName = dr["ItemName"].ToString(),
Quantity = Convert.ToInt32(dr["RemainingQuantity"])
});
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
else
{
ReqList li = new ReqList();
DataSet ds = li.Show_ReturndataforGR(id);
List <ProcureVM> list = new List <ProcureVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new ProcureVM
{
ItemType = dr["ItemType"].ToString(),
ItemName = dr["ItemName"].ToString(),
Quantity = Convert.ToInt32(dr["RejectedQuantity"])
});
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetQuantityDataforrd(int id)
{
ReqList li = new ReqList();
DataSet ds = li.Show_QtyRejectedDataingrid(id);
List <ProcureVM> list = new List <ProcureVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new ProcureVM
{
ItemName = dr["ItemName"].ToString(),
RejectedQuantity = Convert.ToInt32(dr["ReturnQuantity"]),
ApprovedQuantity = Convert.ToInt32(dr["ApprovedQuantity"])
});
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
public ActionResult RemoveGRDataforReturnforrdm(int id)
{
var checkStatusofGr = obj.GetDoc().Where(x => x.DocumentNo == id && x.DocStatus == "Open").FirstOrDefault();
if (checkStatusofGr != null)
{
ReqList li = new ReqList();
DataSet ds = li.Remove_GRdataforrdm(id);
List <ProcureVM> list = new List <ProcureVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new ProcureVM
{
ItemName = dr["ItemName"].ToString(),
Quantity = Convert.ToInt32(dr["ApprovedQtybyQuality"])
});
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
else
{
ReqList li = new ReqList();
DataSet ds = li.Remove_GRdataforrd(id);
List <ProcureVM> list = new List <ProcureVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new ProcureVM
{
ItemName = dr["ItemName"].ToString(),
Quantity = Convert.ToInt32(dr["DeliveredQuantity"])
});
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetGRDataforReturnddlforrdm(int id)
{
var checkStatusofGr = obj.GetDoc().Where(x => x.DocumentNo == id && x.DocStatus == "Open").FirstOrDefault();
if (checkStatusofGr != null)
{
ReqList li = new ReqList();
DataSet ds = li.Show_GRdataforrdmddl(id);
List <ProcureVM> list = new List <ProcureVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new ProcureVM
{
ItemId = Convert.ToInt32(dr["ItemId"]),
ItemName = dr["ItemName"].ToString()
});
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
else
{
ReqList li = new ReqList();
DataSet ds = li.Show_GRdataforrdddl(id);
List <ProcureVM> list = new List <ProcureVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new ProcureVM
{
ItemId = Convert.ToInt32(dr["ItemId"]),
ItemName = dr["ItemName"].ToString()
});
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetReorderpointnoti()
{
var role = System.Web.HttpContext.Current.Session["RoleName"].ToString();
if (role == "Inventory Manager")
{
ReqList obj = new ReqList();
DataSet ds = obj.Show_Reorderpointnoti();
List <ProcureVM> listreq = new List <ProcureVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
listreq.Add(new ProcureVM
{
ItemName = dr["ItemName"].ToString()
});
}
return(Json(listreq, JsonRequestBehavior.AllowGet));
}
return(Json(JsonRequestBehavior.AllowGet));
}
public JsonResult GetReqNoti()
{
ReqList obj = new ReqList();
DataSet ds = obj.Show_Reqnotidata();
List <RequestVM> listreq = new List <RequestVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
listreq.Add(new RequestVM
{
CityName = dr["CityName"].ToString(),
RequestId = Convert.ToInt32(dr["RequestId"]),
EmployeeId = Convert.ToInt32(dr["EmployeeId"]),
EmployeeName = dr["EmployeeName"].ToString(),
DateofRequest = Convert.ToDateTime(dr["DateofRequest"]),
RequestType = dr["RequestType"].ToString(),
Position = dr["Position"].ToString()
});
}
return(Json(listreq, JsonRequestBehavior.AllowGet));
}
public JsonResult GetReorderNoticount()
{
var role = System.Web.HttpContext.Current.Session["RoleName"].ToString();
var isadmin = System.Web.HttpContext.Current.Session["isAdmin"].ToString();
if (role == "Inventory Manager")
{
ReqList obj = new ReqList();
DataSet ds = obj.Show_Reordernoticounts();
List <RequestVM> listreq = new List <RequestVM>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
listreq.Add(new RequestVM
{
count = Convert.ToInt32(dr["Totalcount"])
});
}
return(Json(listreq, JsonRequestBehavior.AllowGet));
}
return(Json(JsonRequestBehavior.AllowGet));
}
