public void r105Implementation(ApprovalNormalOrdersModel instance) { // This is the placeholder for method implementation. if (instance.OrderHedID != null) { int ordStatus = 7; //if (UserIsInRole("SalesManager")) //{ // //6 = Lv2 approval when order is exception // //7 = Approved when order is normal // ordStatus = instance.Exception == true ? 6 : 7; //} SqlText.ExecuteNonQuery("Update OrderHed Set OrderStatusID=@OrderStatusID Where OrderHedID=@OrderHedID ", new { @OrderHedID = instance.OrderHedID, @OrderStatusID = ordStatus }); SqlText.ExecuteNonQuery( "Insert into OrderStatusLog (OrderHedID,UserID,[Comment],[RejectReason],[OtherRemarks],[TranDate]) Values " + "(@OrderHedID,@UserID,@Comment,@RejectReason,@OtherRemarks,@TranDate) " , new { @OrderHedID = instance.OrderHedID, @UserID = UserId, @Comment = "Order Approved", @RejectReason = instance.RejectedReason, @OtherRemarks = instance.RejectedRemarks, @TranDate = DateTime.Now }); EpiRequest SORequest = new EpiRequest(); EpiResponse ObjEpiRes = SORequest.CreateSO((int)instance.OrderHedID); SqlText.ExecuteNonQuery("Update OrderHed Set EpiOrderNum=@EpiOrderNum, EpiError=@EpiError Where OrderHedID=@OrderHedID ", new { @OrderHedID = instance.OrderHedID, @EpiOrderNum = ObjEpiRes.EpiOrderNum, @EpiError = ObjEpiRes.ErrMsg }); if (Arguments.SelectedValues.Count() > 1) { var lastValue = Convert.ToInt32(Arguments.SelectedValues.ToList().LastOrDefault()); //if (lastValue.Equals(instance.OrderHedID)) // Result.ShowAlert("Orders Approval Process Done! "); } else { //Result.ShowAlert("OrderNo : {0} Approved and Created in Epicor EpiOrderNum {1}! " // , instance.OrderHedID, ObjEpiRes.EpiOrderNum); } //Result.ShowAlert("OrderNo : {0} Approved and Created in Epicor EpiOrderNum {1}! " // , instance.OrderHedID, ObjEpiRes.EpiOrderNum); } else { Result.ShowAlert("Please Select Row!"); } }
public void r102Implementation(ApprovalNormalOrdersModel instance) { // This is the placeholder for method implementation. Finsoft.Data.PageRequest page = (Finsoft.Data.PageRequest)Context.Items["PageRequest_Current"]; if (page.View == "editForm1") { if (instance.OrderHedID != null) { var custInfo = SqlText.Execute("select * from vwCustomer a inner join OrderHed b On a.SysRowID=b.CustSysRowID where b.OrderHedID=@OrderHedID", new { OrderHedID = instance.OrderHedID }); if (custInfo != null) { instance.CAddress1 = custInfo[5].ToString(); instance.CAddress2 = custInfo[6].ToString(); instance.CAddress3 = custInfo[7].ToString(); instance.CCity = custInfo[8].ToString(); instance.CState = custInfo[9].ToString(); instance.CZip = custInfo[10].ToString(); instance.CCountry = custInfo[11].ToString(); instance.CreditLimit = Convert.ToDecimal(custInfo[14]); instance.Balance = Convert.ToDecimal(custInfo[13]); instance.UnPaidInvoices = Convert.ToDecimal(custInfo[15]); instance.OutStandingOrders = Convert.ToDecimal(custInfo[16]); instance.UnPostedInvoices = Convert.ToDecimal(custInfo[17]); instance.AgeCurr = Convert.ToDecimal(custInfo[18]); instance.Age30 = Convert.ToDecimal(custInfo[19]); instance.Age60 = Convert.ToDecimal(custInfo[20]); instance.Age90 = Convert.ToDecimal(custInfo[21]); instance.Age120 = Convert.ToDecimal(custInfo[22]); instance.Age150 = Convert.ToDecimal(custInfo[23]); instance.TermsExceed = Convert.ToBoolean(custInfo[24]); instance.PhoneNum = custInfo[26].ToString(); instance.FaxNum = custInfo[27].ToString(); } } if (instance.OrderHedID != null) { var shipInfo = SqlText.Execute("select * from vwShipTo a inner join OrderHed b On a.SysRowID=b.ShipToSysRowID where b.OrderHedID=@OrderHedID", new { OrderHedID = instance.OrderHedID }); if (shipInfo != null) { instance.SAddress1 = shipInfo[6].ToString(); instance.SAddress2 = shipInfo[7].ToString(); instance.SAddress3 = shipInfo[8].ToString(); instance.SCity = shipInfo[9].ToString(); instance.SState = shipInfo[10].ToString(); instance.SZip = shipInfo[11].ToString(); instance.SCountry = shipInfo[12].ToString(); instance.SPhoneNum = shipInfo[14].ToString(); instance.SFaxNum = shipInfo[15].ToString(); } } } }
public void r106Implementation(ApprovalNormalOrdersModel instance) { // This is the placeholder for method implementation. if (instance.OrderHedID != null) { //8 is reject the Order int ordStatus = 8; SqlText.ExecuteNonQuery("Update OrderHed Set OrderStatusID=@OrderStatusID Where OrderHedID=@OrderHedID ", new { @OrderHedID = instance.OrderHedID, @OrderStatusID = ordStatus }); SqlText.ExecuteNonQuery( "Insert into OrderStatusLog (OrderHedID,UserID,Comment,[RejectReason],[OtherRemarks],[TranDate]) Values " + "(@OrderHedID,@UserID,@Comment,@RejectReason,@OtherRemarks,@TranDate) " , new { @OrderHedID = instance.OrderHedID, @UserID = UserId, @Comment = "Order Rejected", @RejectReason = instance.RejectedReason, @OtherRemarks = instance.RejectedRemarks, @TranDate = DateTime.Now }); if (Arguments.SelectedValues.Count() > 1) { var lastValue = Convert.ToInt32(Arguments.SelectedValues.ToList().LastOrDefault()); if (lastValue.Equals(instance.OrderHedID)) { Result.ShowAlert("Orders Reject Process Done! "); } } else { Result.ShowAlert("OrderNo : {0} Rejected!", instance.OrderHedID); } //Result.ShowAlert("OrderNo : {0} Rejected!", instance.OrderHedID); } else { Result.ShowAlert("Please Select Row!"); } }
public void r109Implementation(ApprovalNormalOrdersModel instance) { // This is the placeholder for method implementation. if (instance.OrderHedID == null) { Result.ShowAlert("Please Select Order!"); } else if (string.IsNullOrEmpty(instance.CompanyName)) { Result.ShowAlert("Company is Empty!"); } else if (string.IsNullOrEmpty(instance.CustID)) { Result.ShowAlert("Customer is Empty!"); } else { string custid = string.Format("{0},{1}", instance.CustID, instance.CustID); Result.NavigateUrl = string.Format("~/CustomReport.ashx?Company={0}&CustId={1}&FileName={2}", instance.CompanyName, custid, instance.CustID); } }
public void r101Implementation(ApprovalNormalOrdersModel instance) { // This is the placeholder for method implementation. }