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 r105Implementation(ApprovalExceptionOrdersModel instance)
{
//if (OrderHedID2 == null)
//{
// OrderHedID2 = 0;
//}
// 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;
}
else
{
ordStatus = 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
});
if (ordStatus == 6)
{
//if (OrderHedID2 != instance.OrderHedID)
//{
//[ControllerAction("", "grid1", "Select", ActionPhase.Before)]
//protected void TellTheUserWhatJustHappened()
//{
//if (!IsTagged("UserIsInformed"))
//{
// //Add Result MessageBox
// //Result.ShowAlert("OrderNo : {0} Approved and Sent for Lv2 Approval!", instance.OrderHedID);
// AddTag("UserIsInformed");
// Result.ShowAlert("OrderNo : {0} Approved and Sent for Lv2 Approval!", instance.OrderHedID);
//}
//}
//Result.ShowAlert("OrderNo : {0} Approved and Sent for Lv2 Approval!", instance.OrderHedID);
// OrderHedID2 = instance.OrderHedID;
// //int? @OrderHedID2 = instance.OrderHedID;
//}
}
else
{
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 });
//int effRec1 = SqlText.ExecuteNonQuery("Update OrderDtl Set BasePrice=ProposedBasePrice Where ChangeBasePrice=1 and OrderHedID=@OrderHedID",
// instance.OrderHedID);
//int effRec2 = SqlText.ExecuteNonQuery("Update OrderDtl Set SellingPrice=ProposedSellingPrice Where ChangeSellingPrice=1 and OrderHedID=@OrderHedID",
// instance.OrderHedID);
//int effRec3 = SqlText.ExecuteNonQuery("Update OrderDtl Set Amount=(OrderQty*SellingPrice) Where ChangeSellingPrice=1 and OrderHedID=@OrderHedID",
// instance.OrderHedID);
//if (effRec2 > 0)
//{
// decimal total = (decimal)SqlText.ExecuteScalar("select isnull(Sum(SellingPrice * OrderQty),0) From OrderDtl Where OrderHedID=@OrderHedID ",
// instance.OrderHedID);
// instance.TotalAmount = total;
// int i = SqlText.ExecuteNonQuery("Update OrderHed Set TotalAmount=@total Where OrderHedID=@OrderHedID",
// total, instance.OrderHedID);
//}
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);
}
}
}
else
{
Result.ShowAlert("Please Select Row!");
}
}
