public ActionResult dosearch(FormCollection form) { var sessionObj = Session["SessionBO"] as UserModel; if (sessionObj != null) { string selected_start = form["selected_start"]; string selected_end = form["selected_end"]; string[] data = selected_end.Split('-'); string new_start = data[1] + '-' + data[0] + '-' + data[2]; string[] data1 = selected_start.Split('-'); string new_start1 = data1[1] + '-' + data1[0] + '-' + data1[2]; DateTime selected_start1 = Convert.ToDateTime(new_start1, System.Globalization.CultureInfo.CurrentCulture); DateTime selected_end1 = Convert.ToDateTime(new_start, System.Globalization.CultureInfo.CurrentCulture); BOMDetails objBOMDetails = new BOMDetails(); objBOMDetails.dosearch(selected_start1, selected_end1, sessionObj.id); GenericTextValue objGenericTextValue = new GenericTextValue(); ViewBag.lstRefinery = objGenericTextValue.GetSubRefineryList(sessionObj.id); ViewBag.IsAuthorized = sessionObj.isAuthorized; ViewBag.LoggedInUser = sessionObj.firstName; return(View("../Admin/MaterialList", objBOMDetails)); } else { return(RedirectToAction("LoginUser", "Login")); } }
internal dynamic GetRefineryList() { SqlCommand cmd; SqlConnection connection = null; BOMDetails objBOMDetails = new BOMDetails(); connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); connection.Open(); List <GenericTextValue> lstGenericTextValue = new List <GenericTextValue>(); SqlDataReader objSqlDataReader = null; cmd = new SqlCommand("GetRefineryList", connection); cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.Add(objSqlParameter[0]); objSqlDataReader = cmd.ExecuteReader(); while (objSqlDataReader.Read()) { GenericTextValue objGenericTextValue = new GenericTextValue(); objGenericTextValue.RID = Convert.ToString(objSqlDataReader["RefineryID"]); objGenericTextValue.RName = Convert.ToString(objSqlDataReader["RefineryName"]); lstGenericTextValue.Add(objGenericTextValue); objGenericTextValue = null; } objSqlDataReader.Close(); connection.Close(); return(lstGenericTextValue); }
public JsonResult ValidateActualDatePO(string ActualStartDate, string ActualstartTime, string SubRefinery) { var sessionObj = Session["SessionBO"] as UserModel; if (sessionObj != null) { BOMDetails objBOMDetails = new BOMDetails(); try { string result = objBOMDetails.ValidateActualDatePO(ActualStartDate, ActualstartTime, SubRefinery); return(Json(new { value = result }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { value = "Exception Occured" }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { status = false }, JsonRequestBehavior.AllowGet)); } }
public JsonResult SubmtPODetails(string ActualStartDate, string ActualStartTime, string ActualEndDate, string ActualEndTime, string roles, string data, string ManualEntryResult, string PONO, int IDOCNumber, string PostingDate, string ProductionDate) { var sessionObj = Session["SessionBO"] as UserModel; if (sessionObj != null) { BOMDetails objBOMDetails = new BOMDetails(); Characteristic objCharacteristic = new Characteristic(); bool charResult = objCharacteristic.SaveCharacteristics(data, PONO, sessionObj.id, IDOCNumber); bool manualResult = objBOMDetails.SaveChemicalManualEntry(ManualEntryResult, PONO, sessionObj.id, IDOCNumber); bool result = objBOMDetails.SubmitPODetails(ActualStartDate, ActualStartTime, ActualEndDate, ActualEndTime, roles, PONO, sessionObj.id, IDOCNumber, PostingDate, ProductionDate); if (manualResult && result) { return(Json(new { value = "Successfully Submitted!" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = false }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { status = false }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// DropDownForClient /// Calls [usp_GetUpdatedByListFromBOMIdList] /// </summary> public static BOM GetUpdatedByListFromBOMIdList(System.String BOMIdList) { BOMDetails lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.BOM.GetUpdatedByListFromBOMIdList(BOMIdList); // BOM lst = new BOM(); Rebound.GlobalTrader.BLL.BOM obj = new Rebound.GlobalTrader.BLL.BOM(); obj.BOMName = lstDetails.BOMName; obj.UpdatedByList = lstDetails.UpdatedByList; lstDetails = null; return(obj); }
//[002] code start here /// <summary> /// GetListReadyForClient /// Calls [usp_selectAll_BOM] /// </summary> public override List <BOMDetails> GetBomList(System.Int32?clientId, System.Boolean?isPoHUB, System.Int32?topToSelect, System.Int32?bomStatus, System.Int32?updatedBy) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_selectAll_BOM", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 50; cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId; cmd.Parameters.Add("@TopToSelect", SqlDbType.Int).Value = topToSelect; cmd.Parameters.Add("@IsPoHUB", SqlDbType.Bit).Value = isPoHUB; cmd.Parameters.Add("@BomStatus", SqlDbType.Int).Value = bomStatus; cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = updatedBy; cn.Open(); DbDataReader reader = ExecuteReader(cmd); List <BOMDetails> lst = new List <BOMDetails>(); while (reader.Read()) { BOMDetails obj = new BOMDetails(); obj.BOMId = GetReaderValue_Int32(reader, "BOMId", 0); obj.BOMCode = GetReaderValue_String(reader, "BOMCode", ""); obj.BOMName = GetReaderValue_String(reader, "BOMName", ""); obj.ClientName = GetReaderValue_String(reader, "ClientName", ""); obj.CompanyName = GetReaderValue_String(reader, "CompanyName", ""); obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); obj.StatusValue = GetReaderValue_Int32(reader, "StatusValue", 0); obj.RequestToPOHubBy = GetReaderValue_Int32(reader, "RequestToPOHubBy", 0); obj.UpdatedBy = GetReaderValue_Int32(reader, "UpdatedBy", 0); obj.QuoteRequired = GetReaderValue_NullableDateTime(reader, "QuoteRequired", null); lst.Add(obj); obj = null; } return(lst); } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get BOM", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
public JsonResult ValidateActualDatePO(string ActualStartDate, string ActualstartTime, string SubRefinery) { BOMDetails objBOMDetails = new BOMDetails(); try { string result = objBOMDetails.ValidateActualDatePO(ActualStartDate, ActualstartTime, SubRefinery); return(Json(new { value = result }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { value = "Exception Occured" }, JsonRequestBehavior.AllowGet)); } }
private static BOM PopulateFromDBDetailsObject(BOMDetails obj) { BOM objNew = new BOM(); objNew.BOMId = obj.BOMId; objNew.ClientNo = obj.ClientNo; objNew.BOMName = obj.BOMName; objNew.Notes = obj.Notes; objNew.BOMCode = obj.BOMCode; objNew.Inactive = obj.Inactive; objNew.UpdatedBy = obj.UpdatedBy; objNew.DLUP = obj.DLUP; objNew.RowNum = obj.RowNum; objNew.RowCnt = obj.RowCnt; return(objNew); }
public ActionResult GetPOList() { var sessionObj = Session["SessionBO"] as UserModel; if (sessionObj != null) { BOMDetails objBOMDetails = new BOMDetails(); objBOMDetails.GetBOMDetailList(sessionObj.id); GenericTextValue objGenericTextValue = new GenericTextValue(); ViewBag.lstRefinery = objGenericTextValue.GetSubRefineryList(sessionObj.id); ViewBag.IsAuthorized = sessionObj.isAuthorized; ViewBag.LoggedInUser = sessionObj.firstName; return(View("../User/MaterialList", objBOMDetails)); } else { return(RedirectToAction("LoginUser", "Login")); } }
// Submitted PO List -> on Preview public ActionResult LoadProcessOrder(string Name) { var sessionObj = Session["SessionBO"] as UserModel; if (sessionObj != null) { BOMDetails objBOMDetails = new BOMDetails(); string[] split = Name.Split(','); string PONumber = split[0]; int IDOCNumber = Convert.ToInt32(split[1]); objBOMDetails = objBOMDetails.getProcessOrder(PONumber, IDOCNumber); ViewBag.IsAuthorized = sessionObj.isAuthorized; ViewBag.LoggedInUser = sessionObj.firstName;// +" " + sessionObj.LastName; return(View("../Admin/ProcessOrder", objBOMDetails)); } else { return(RedirectToAction("LoginUser", "Login")); } }
// Get Submitted PO List public ActionResult GetSubmitedPOList() { var sessionObj = Session["SessionBO"] as UserModel; if (sessionObj != null) { BOMDetails objBOMDetails = new BOMDetails(); // SP -> GetSubmitedPOList objBOMDetails.GetSubmitedPOList(sessionObj.id); ViewBag.IsAuthorized = sessionObj.isAuthorized; ViewBag.LoggedInUser = sessionObj.firstName; // Control go to SubmitedPOList.cshtml page return(View("../Admin/SubmitedPOList", objBOMDetails)); } else { return(RedirectToAction("LoginUser", "Login")); } }
internal dynamic GetSubRefineryList(int userId) { SqlCommand cmd; SqlConnection connection = null; BOMDetails objBOMDetails = new BOMDetails(); List <GenericTextValue> lstGenericTextValue = new List <GenericTextValue>(); SqlDataReader objSqlDataReader = null; try { connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); connection.Open(); SqlParameter[] objSqlParameter = new SqlParameter[1]; objSqlParameter[0] = new SqlParameter(); objSqlParameter[0].ParameterName = "@UserId"; objSqlParameter[0].SqlDbType = SqlDbType.Int; objSqlParameter[0].Value = userId; cmd = new SqlCommand("GetSubRefineryList", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(objSqlParameter[0]); objSqlDataReader = cmd.ExecuteReader(); while (objSqlDataReader.Read()) { GenericTextValue objGenericTextValue = new GenericTextValue(); objGenericTextValue.RID = Convert.ToString(objSqlDataReader["SubRefinery"]); objGenericTextValue.RName = Convert.ToString(objSqlDataReader["SubRefinery"]); lstGenericTextValue.Add(objGenericTextValue); objGenericTextValue = null; } objSqlDataReader.Close(); connection.Close(); } catch (Exception ex) { } return(lstGenericTextValue); }
/// <summary> /// GetIDByNumber /// Calls [usp_select_BOM_ID_by_Name] /// </summary>GetIDByNumber public override BOMDetails GetIDByNumber(System.String bomName, System.Int32?clientNo) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_select_BOM_ID_by_Name", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@BomName", SqlDbType.NVarChar).Value = bomName; cmd.Parameters.Add("@ClientNo", SqlDbType.Int).Value = clientNo; cn.Open(); DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow); if (reader.Read()) { BOMDetails obj = new BOMDetails(); obj.BOMId = GetReaderValue_Int32(reader, "BOMId", 0); return(obj); } else { return(null); } } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get HUBRFQ", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
/// <summary> /// GetForPage /// Calls [usp_select_BOM_for_Page] /// </summary> public override BOMDetails GetForPage(System.Int32?bomId) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_select_BOM_for_Page", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@BOMId", SqlDbType.Int).Value = bomId; cn.Open(); DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow); if (reader.Read()) { //return GetBOMFromReader(reader); BOMDetails obj = new BOMDetails(); obj.BOMId = GetReaderValue_Int32(reader, "BOMId", 0); obj.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); obj.BOMName = GetReaderValue_String(reader, "BOMName", ""); obj.Inactive = GetReaderValue_Boolean(reader, "Inactive", false); obj.BOMStatus = GetReaderValue_String(reader, "Status", ""); obj.RequestToPOHubBy = GetReaderValue_Int32(reader, "RequestToPOHubBy", 0); return(obj); } else { return(null); } } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get BOM", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
/// <summary> /// DropDownForClient /// Calls [usp_dropdown_BOM_for_Client] /// </summary> public override List <BOMDetails> DropDownForClient(System.Int32?clientId, System.Int32?companyId) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_dropdown_BOM_for_Client", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId; cmd.Parameters.Add("@CompanyNo", SqlDbType.Int).Value = companyId; cn.Open(); DbDataReader reader = ExecuteReader(cmd); List <BOMDetails> lst = new List <BOMDetails>(); while (reader.Read()) { BOMDetails obj = new BOMDetails(); obj.BOMId = GetReaderValue_Int32(reader, "BOMId", 0); obj.BOMName = GetReaderValue_String(reader, "BOMName", ""); lst.Add(obj); obj = null; } return(lst); } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get BOMs", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
/// <summary> /// DropDownForClient /// Calls [usp_GetUpdatedByListFromBOMIdList] /// </summary> public override BOMDetails GetUpdatedByListFromBOMIdList(System.String BOMIdList) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_GetUpdatedByListFromBOMIdList", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@BOMIdList", SqlDbType.VarChar).Value = BOMIdList; cn.Open(); DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow); if (reader.Read()) { BOMDetails obj = new BOMDetails(); obj.UpdatedByList = GetReaderValue_String(reader, "UserIds", ""); obj.BOMName = GetReaderValue_String(reader, "BOMName", ""); return(obj); } else { return(null); } } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get BOMs emails", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
public JsonResult CalculateBill(string ActualStartDateTime, string ActualEndDateTime, string SubRefinery, string isSave_status, string PONO, int IDOCNumber) { var sessionObj = Session["SessionBO"] as UserModel; if (sessionObj != null) { BOMMasterTag objBOMMasterTag = new BOMMasterTag(); AFLocaleIndependentFormatProvider myTimeZone = new AFLocaleIndependentFormatProvider(); DateTime ActualStartDate = Convert.ToDateTime(ActualStartDateTime); DateTime ActualEndDate = Convert.ToDateTime(ActualEndDateTime); AFValue strtVal; AFValue endVal; PIPoint strtTag; string exceptionMsg = ""; BOMDetails bomDetails = new BOMDetails(); //List<MasterRefineryModel> lstMasterRefinery = bomDetails.getPlantWiseSubRefineries(SubRefinery); //foreach (MasterRefineryModel RefineryDetails in lstMasterRefinery) //{ // Boolean flag = bomDetails.InsertForUpTime(ActualStartDate, ActualEndDate, RefineryDetails.SubRefineryCode, RefineryDetails.SubRefineryName); //} try { List <BOMMasterTag> lstBOMMasterTag = new List <BOMMasterTag>(); if (isSave_status == "1") { lstBOMMasterTag = objBOMMasterTag.getIsSavedList(PONO, IDOCNumber); List <string> lslComponent = GetIsManualWithTag(ActualStartDateTime, ActualEndDateTime, SubRefinery, isSave_status, PONO, IDOCNumber); foreach (BOMMasterTag objBOMMasterTag1 in lstBOMMasterTag) { foreach (String component in lslComponent) { if (objBOMMasterTag1.component == component) { objBOMMasterTag1.isManual = true; objBOMMasterTag1.isManualWithTag = true; } } } } else { PIServerDetails piServerDetails = new PIServerDetails(); PISystems myPISystems = new PISystems(); PISystem mypiSystem = myPISystems[piServerDetails.PIServerName]; PIServer myPiServer = PIServer.FindPIServer(mypiSystem, piServerDetails.PIServerName); NetworkCredential Credentials = new NetworkCredential(piServerDetails.UserName, piServerDetails.Password); ActualStartDate = ActualStartDate.AddMinutes(-330); AFTime sAFTime = new AFTime(ActualStartDate); ActualEndDate = ActualEndDate.AddMinutes(-330); AFTime eAFTime = new AFTime(ActualEndDate); mypiSystem.Connect(Credentials); //Tag Mapping with BOMMaster. List <BOMMasterTag> lstBOMMasterTag1 = objBOMMasterTag.getMasterBOM(SubRefinery, PONO, IDOCNumber); IDictionary <AFSummaryTypes, AFValue> sm = null; IDictionary <AFSummaryTypes, AFValue> smin = null; List <string> lstComponent = new List <string>(); foreach (BOMMasterTag objBOMMasterTag1 in lstBOMMasterTag1) { lstComponent.Add(objBOMMasterTag1.component); } //string duplicate = ""; //List<string> NonDuplicateList = new List<string>(); //foreach (string s in lstComponent) //{ // if (!NonDuplicateList.Contains(s)) // NonDuplicateList.Add(s); // else // duplicate = s; //} foreach (BOMMasterTag objBOMMasterTag1 in lstBOMMasterTag1) { if (objBOMMasterTag1.isManual || objBOMMasterTag1.PITag == "") { //objBOMMasterTag1.quantity = 00; objBOMMasterTag1.isManual = true; } else { double resultValue = 0; strtTag = PIPoint.FindPIPoint(myPiServer, objBOMMasterTag1.PITag); strtVal = strtTag.RecordedValue(sAFTime, AFRetrievalMode.AtOrAfter); endVal = strtTag.RecordedValue(eAFTime, AFRetrievalMode.AtOrAfter); double strtVal1 = Convert.ToDouble(strtVal.Value); AFTimeRange graphTimeReange = new AFTimeRange(sAFTime, eAFTime); sm = strtTag.Summary(graphTimeReange, AFSummaryTypes.Maximum, 0, 0); smin = strtTag.Summary(graphTimeReange, AFSummaryTypes.Minimum, 0, 0); AFValue mx = sm[AFSummaryTypes.Maximum]; AFValue mn = smin[AFSummaryTypes.Minimum]; Boolean isWrongValue = false; if (endVal.Value.ToString().Equals("No Data") || mx.IsGood == false || strtVal.Value.ToString().Equals("No Data") || mx.IsGood == false) { resultValue = 0.0; isWrongValue = true; } else { if (Convert.ToDouble(endVal.Value) < Convert.ToDouble(mx.Value)) { resultValue = Convert.ToDouble(mx.Value) - Convert.ToDouble(strtVal.Value) + Convert.ToDouble(endVal.Value) - Convert.ToDouble(mn.Value); } else if (Convert.ToDouble(endVal.Value) == Convert.ToDouble(strtVal.Value)) { resultValue = 0; Math.Round(Convert.ToDouble(strtVal.Value), 2); isWrongValue = true; } else { resultValue = Convert.ToDouble(endVal.Value) - Convert.ToDouble(strtVal.Value); } } if (resultValue <= 0 || isWrongValue) { objBOMMasterTag1.isManual = true; objBOMMasterTag1.isManualWithTag = true; } objBOMMasterTag1.quantity = (float)resultValue; } lstBOMMasterTag.Add(objBOMMasterTag1); //if (duplicate != "") //{ // if (objBOMMasterTag1.BOMCategory == "Raw-Material") // { // if (duplicate == objBOMMasterTag1.component) // { // lstBOMMasterTag.Remove(objBOMMasterTag1); // } // } //} } } JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); string json = javaScriptSerializer.Serialize(lstBOMMasterTag); JsonResult js = Json(new { value = json }, JsonRequestBehavior.AllowGet); return(js); } catch (Exception e) { return(Json(new { value = exceptionMsg }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { status = false }, JsonRequestBehavior.AllowGet)); } }
public JsonResult LoadGraph(string PlantStartDateTime, string PlantEndDateTime, string SubRefinery) { var sessionObj = Session["SessionBO"] as UserModel; if (sessionObj != null) { string PlantStartDateTime1 = PlantStartDateTime; string PlantEndDateTime1 = PlantEndDateTime; BOMDetails objBOMDetails = new BOMDetails(); AFLocaleIndependentFormatProvider myTimeZone = new AFLocaleIndependentFormatProvider(); // DateTime StartDate = Convert.ToDateTime(PlantStartDateTime1); // DateTime EndDate = Convert.ToDateTime(PlantEndDateTime1); DateTime StartDate = Convert.ToDateTime(PlantStartDateTime1, System.Globalization.CultureInfo.CurrentCulture); DateTime EndDate = Convert.ToDateTime(PlantEndDateTime1, System.Globalization.CultureInfo.CurrentCulture); PIPoint feedInTag; PIPoint feedOutTag; AFValues feedInVal; AFValues feedOutVal; AFValues filteredfeedInVal = new AFValues(); AFValues filteredoutInVal = new AFValues(); try { PIServerDetails piServerDetails = new PIServerDetails(); PISystems myPISystems = new PISystems(); PISystem mypiSystem = myPISystems[piServerDetails.PIServerName]; PIServer myPiServer = PIServer.FindPIServer(mypiSystem, piServerDetails.PIServerName); NetworkCredential Credentials = new NetworkCredential(piServerDetails.UserName, piServerDetails.Password); mypiSystem.Connect(Credentials); StartDate = StartDate.AddMinutes(-330); AFTime sAFTime = new AFTime(StartDate); //DateTime endDT = Convert.ToDateTime(szDTend); EndDate = EndDate.AddMinutes(-330); AFTime eAFTime = new AFTime(EndDate); AFTimeRange GraphTimeRange = new AFTimeRange(sAFTime, eAFTime); // mypiSystem.Connect(Credentials); objBOMDetails = objBOMDetails.getFeedInFeedOutTag(SubRefinery); feedInTag = PIPoint.FindPIPoint(myPiServer, objBOMDetails.feedInTag); feedInVal = feedInTag.RecordedValues(GraphTimeRange, 0, null, true, 0); foreach (AFValue val in feedInVal) { if (val.IsGood) { filteredfeedInVal.Add(val); } else { val.Value = 0; filteredfeedInVal.Add(val); } } feedOutTag = PIPoint.FindPIPoint(myPiServer, objBOMDetails.feedOutTag); feedOutVal = feedOutTag.RecordedValues(GraphTimeRange, 0, null, true, 0); foreach (AFValue val in feedOutVal) { if (val.IsGood) { filteredoutInVal.Add(val); } else { val.Value = 0; filteredoutInVal.Add(val); } } int inLenArray = filteredfeedInVal.Count; object[] feedInValArr = new object[inLenArray]; DateTime[] feedInDateArr = new DateTime[inLenArray]; AFValueStatus[] feedInValStatus = new AFValueStatus[inLenArray]; filteredfeedInVal.GetValueArrays(out feedInValArr, out feedInDateArr, out feedInValStatus); int outLenArray = feedOutVal.Count; object[] feedOutValArr = new object[outLenArray]; DateTime[] feedOutDateArr = new DateTime[outLenArray]; AFValueStatus[] feedOutValStatus = new AFValueStatus[outLenArray]; filteredoutInVal.GetValueArrays(out feedOutValArr, out feedOutDateArr, out feedOutValStatus); List <KeyValuePair <string, double> > fInlist = new List <KeyValuePair <string, double> >(); List <KeyValuePair <string, double> > fOutlist = new List <KeyValuePair <string, double> >(); // double[] fInDateValdouble = new double[inLenArray]; double[] fOutDateVal = new double[outLenArray]; double[] fInDateVal = new double[inLenArray]; for (int i = 0; i < feedInValArr.Length; i++) { //string fIn = feedInValArr[i].ToString(); double fint = Convert.ToInt32(feedInValArr[i]); if (fint == 0.0) { fInDateVal[i] = -99999; } else if (fint < 0.0) { fInDateVal[i] = -99999; } else { fInDateVal[i] = Math.Round(Convert.ToDouble(feedInValArr[i]), 2); } } string[] fInDateArr = new string[inLenArray]; for (int i = 0; i < feedInDateArr.Length; i++) { fInDateArr[i] = feedInDateArr[i].ToString("MM-dd-yyyy HH:mm:ss"); var element = new KeyValuePair <string, double>(fInDateArr[i], fInDateVal[i]); fInlist.Add(element); } string[] fOutDateArr = new string[outLenArray]; for (int i = 0; i < feedOutDateArr.Length; i++) //feedOutDateArr { //string fOut = feedOutValArr[i].ToString(); //fOutDateArr double fout = Convert.ToInt32(feedOutValArr[i]); if (fout == 0.0) { fOutDateVal[i] = -99999; } else if (fout < 0.0) { fOutDateVal[i] = -99999; } else { fOutDateVal[i] = Math.Round(Convert.ToDouble(feedOutValArr[i]), 2); } } // string[] fOutDateArr = new string[inLenArray]; for (int i = 0; i < feedOutDateArr.Length; i++) { fOutDateArr[i] = feedOutDateArr[i].ToString("MM-dd-yyyy HH:mm:ss"); var element1 = new KeyValuePair <string, double>(fOutDateArr[i], fOutDateVal[i]); fOutlist.Add(element1); } Dictionary <string, List <KeyValuePair <string, double> > > dec = new Dictionary <string, List <KeyValuePair <string, double> > >(); dec.Add("feedIn", fInlist); dec.Add("feedOut", fOutlist); JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); // string json = javaScriptSerializer.Serialize(feedInDateArr); JsonResult js = Json(new { value = dec }, JsonRequestBehavior.AllowGet); return(js); // return Json(new { value = dec }, JsonRequestBehavior.AllowGet); } catch (Exception e) { return(Json(new { value = "Exception Occured" }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { status = false }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// DataListNugget /// Calls [usp_datalistnugget_BOM] /// </summary> public override List <BOMDetails> DataListNugget(System.Int32?clientId, System.Int32?teamId, System.Int32?divisionId, System.Int32?loginId, System.Int32?orderBy, System.Int32?sortDir, System.Int32?pageIndex, System.Int32?pageSize, System.String bomCode, System.String bomName, System.Boolean?isPOHub, System.Int32?selectedClientNo, int?bomStatus, int?IsAssignToMe, int?assignedUser, System.Int32?intDivision, System.Int32?salesPerson) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); if (isPOHub == true) { if (IsAssignToMe == 0) { cmd = new SqlCommand("usp_datalistnugget_PHBOM", cn); } if (IsAssignToMe == 1) { pageSize = 1000;//Set the max page size dynamically. cmd = new SqlCommand("usp_datalistnugget_PHBOMAssign", cn); } } else { cmd = new SqlCommand("usp_datalistnugget_BOM", cn); } cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 60; cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId; cmd.Parameters.Add("@TeamId", SqlDbType.Int).Value = teamId; cmd.Parameters.Add("@DivisionId", SqlDbType.Int).Value = divisionId; cmd.Parameters.Add("@LoginId", SqlDbType.Int).Value = loginId; cmd.Parameters.Add("@OrderBy", SqlDbType.Int).Value = orderBy; cmd.Parameters.Add("@SortDir", SqlDbType.Int).Value = sortDir; cmd.Parameters.Add("@PageIndex", SqlDbType.Int).Value = pageIndex; cmd.Parameters.Add("@PageSize", SqlDbType.Int).Value = pageSize; cmd.Parameters.Add("@BOMCode", SqlDbType.NVarChar).Value = bomCode; //cmd.Parameters.Add("@CodeHi", SqlDbType.NVarChar).Value = CodeHi; cmd.Parameters.Add("@BOMName", SqlDbType.NVarChar).Value = bomName; cmd.Parameters.Add("@IsPoHub", SqlDbType.Bit).Value = isPOHub; cmd.Parameters.Add("@ClientNo", SqlDbType.Int).Value = selectedClientNo; cmd.Parameters.Add("@BomStatus", SqlDbType.Int).Value = bomStatus; cmd.Parameters.Add("@SalesPerson", SqlDbType.NVarChar).Value = salesPerson;//[003] if (assignedUser > 0) { cmd.Parameters.Add("@AssignedUser", SqlDbType.Int).Value = assignedUser; } cmd.Parameters.Add("@ClientDivisionNo", SqlDbType.Int).Value = intDivision; cn.Open(); DbDataReader reader = ExecuteReader(cmd); List <BOMDetails> lst = new List <BOMDetails>(); while (reader.Read()) { BOMDetails obj = new BOMDetails(); obj.BOMId = GetReaderValue_Int32(reader, "BOMId", 0); obj.BOMCode = GetReaderValue_String(reader, "BOMCode", ""); obj.BOMName = GetReaderValue_String(reader, "BOMName", ""); obj.RowCnt = GetReaderValue_NullableInt32(reader, "RowCnt", null); obj.CompanyName = GetReaderValue_String(reader, "CompanyName", ""); obj.Inactive = GetReaderValue_Boolean(reader, "Inactive", false); obj.BOMStatus = GetReaderValue_String(reader, "Status", ""); obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); obj.CurrencyNo = GetReaderValue_Int32(reader, "CurrencyId", 0); obj.TotalBomLinePrice = GetReaderValue_Double(reader, "TotalBomLinePrice", 0.00); obj.POCurrencyNo = GetReaderValue_Int32(reader, "POCurrencyNo", 0); obj.DateRequestToPOHub = GetReaderValue_NullableDateTime(reader, "DateRequestToPOHub", null); obj.AssignedUser = GetReaderValue_String(reader, "AssignedUser", ""); obj.DivisionName = GetReaderValue_String(reader, "DivisionName", ""); obj.ClientCode = GetReaderValue_String(reader, "ClientCode", ""); obj.Requestedby = GetReaderValue_String(reader, "Requestedby", ""); obj.SalesmanName = GetReaderValue_String(reader, "SalesmanName", ""); lst.Add(obj); obj = null; } return(lst); } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get BOM", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }