public void GetAvailTaskSets(out string NewList)
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
EngWB.GetAvailTaskSets(out NewList);
EpicClose();
}
/// <summary>
///
/// </summary>
/// <param name="ipGroupID">ECO Group ID</param>
public void GroupLock(string ipGroupID)
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
EngWB.GroupLock(ipGroupID);
EpicClose();
}
public static void CheckInPart(string GroupID, string PartNumber, string Revision)
{
EngWorkBench EngWb = new EngWorkBench(EpicConn);
string opMessage;
EngWb.CheckIn(GroupID, PartNumber, Revision, "", DateTime.Now, false, false, true, true, false, "FOR EPICOR INTEGRATION MODULE", out opMessage);
EpicClose();
}
public DataSet GetProjectRoles()
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
DataSet MethodReturned = EngWB.GetProjectRoles();
EpicClose();
return(MethodReturned);
}
public string GetCodeDescList()
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
string ReturnMethod = EngWB.GetCodeDescList("ECORev", "ProcessMode");
EpicClose();
return(ReturnMethod);
}
/// <summary>
///
/// </summary>
/// <param name="ipGroupID">ECO Group ID</param>
/// <param name="ipCheckOutStatus">Normally should be true</param>
/// <returns></returns>
public EngWorkBenchDataSet GetECORevData(string ipGroupID, bool ipCheckOutStatus)
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
EngWorkBenchDataSet ReturnMethod = EngWB.GetECORevData(ipGroupID, ipCheckOutStatus);
EpicClose();
return(ReturnMethod);
}
/// <summary>
///
/// </summary>
/// <param name="ipGroupID">ECO Group ID</param>
/// <param name="ipPartNum">Part Number</param>
/// <param name="ipRevisionNum">Revision Number</param>
/// <param name="ipAltMethod">Normally Null string</param>
/// <param name="ipAsOfDate">Current Date/Time</param>
/// <param name="ipCompleteTree">Normally False</param>
/// <param name="ipUseMEthodForParts">Normally True</param>
/// <returns></returns>
public EngWorkBenchDataSet GetDatasetForTree(string ipGroupID, string ipPartNum, string ipRevisionNum, string ipAltMethod, DateTime?ipAsOfDate, bool ipCompleteTree, bool ipUseMEthodForParts)
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
EngWorkBenchDataSet MethodReturned = EngWB.GetDatasetForTree(ipGroupID, ipPartNum, ipRevisionNum, ipAltMethod, ipAsOfDate, ipCompleteTree, ipUseMEthodForParts);
EpicClose();
return(MethodReturned);
}
public EngWorkBenchDataSet CheckOut(string ipGroupID, string ipPartNum, string ipRevisionNum, string ipAltMethod, DateTime?ipAsOfDate, bool ipCompleteTree, bool ipValidPassword, bool ipReturn, bool ipGetDatasetForTree, bool ipUseMethodForParts, out string opCheckedOutRevisionNum, out string altMethodMsg, out bool altMethodFlg)
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
EngWorkBenchDataSet ReturnMethod = EngWB.CheckOut(ipGroupID, ipPartNum, ipRevisionNum, ipAltMethod, ipAsOfDate, ipCompleteTree, ipValidPassword, ipReturn, ipGetDatasetForTree, ipUseMethodForParts, out opCheckedOutRevisionNum, out altMethodMsg, out altMethodFlg);
EpicClose();
return(ReturnMethod);
}
public static DataSet EngWB_DS(string GroupID, string PartNumber, string Rev)
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
EngWorkBenchDataSet EngWBDS = new EngWorkBenchDataSet();
EngWBDS = EngWB.GetDatasetForTree(GroupID, PartNumber, Rev, "", DateTime.Today, false, false);
return((DataSet)EngWBDS);
}
public static DataSet GroupIDDataSet()
{
bool MorePages;
EngWorkBench EngBench = new EngWorkBench(EpicConn);
DataSet ds = (DataSet)EngBench.GetList(" BY GroupID", 100, 0, out MorePages);
EpicClose();
return(ds);
}
public ECOGroupListDataSet GetList(string ipGroupID)
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
bool morePages;
ECOGroupListDataSet ReturnMethod = EngWB.GetList("GroupID = '" + ipGroupID + "' BY GroupID", 0, 0, out morePages);
EpicClose();
return(ReturnMethod);
}
public static void CheckOutPart(string GroupID, string PartNumber, string Revision)
{
string CheckedOutRevNum;
string altMethodMsg;
bool altMethodFlg;
EngWorkBench EngWb = new EngWorkBench(EpicConn);
EngWb.CheckOut(GroupID, PartNumber, Revision, "", DateTime.Today, false, false, false, true, false, out CheckedOutRevNum, out altMethodMsg, out altMethodFlg);
EpicClose();
}
public static void ApprovePart(EngWorkBenchDataSet EngDataSet, string GroupID, string PartNumber, string Revision)
{
EngWorkBench EngWb = new EngWorkBench(EpicConn);
EngDataSet = EngWb.GetDatasetForTree(GroupID, PartNumber, Revision, "", DateTime.Now, false, false);
EngDataSet.Tables["ECORev"].Rows[0]["Approved"] = true;
EngWb.CheckECORevApproved(true, false, EngDataSet);
EngWb.Update(EngDataSet);
EpicClose();
}
private void confirm_btn_Click(object sender, EventArgs e)
{
EngWorkBench EngWb = new EngWorkBench(DataList.EpicConn);
EngWorkBenchDataSet ds = new EngWorkBenchDataSet();
ds = EngWb.GetDatasetForTree(gid_cbo.Text, partnumber_txt.Text, rev_txt.Text, "", DateTime.Today, false, false);
DataList.EpicClose();
try
{
DataList.ApprovePart(gid_cbo.Text, partnumber_txt.Text, rev_txt.Text);
DataList.CheckInPart(gid_cbo.Text, partnumber_txt.Text, rev_txt.Text);
}
catch (Exception ex) { MessageBox.Show("Could not check in part\n\n" + ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); }
finally { this.Close(); }
}
private void undo_btn_Click(object sender, EventArgs e)
{
EngWorkBench EngWB = new EngWorkBench(DataList.EpicConn);
EngWorkBenchDataSet EngWBDS = new EngWorkBenchDataSet();
//string Message;
//EngWB.CheckIn("AZ", "Test12", "C", "", null, false, true, false, false, false, "Test", out Message);
//EngWB.CheckOut("AZ", "Test12", "A", "", null, false, false, false, false, false, out Rev, out Method, out altMethodFlg);
EngWBDS = EngWB.GetDatasetForTree(gid_txt.Text, pnum_txt.Text, rev_txt.Text, "", null, false, false);
EngWB.UndoCheckOut(gid_txt.Text, pnum_txt.Text, rev_txt.Text, "", null, false, false, false, false, EngWBDS);
MessageBox.Show("Complete!");
}
private void undo_btn_Click(object sender, EventArgs e)
{
EngWorkBench EngWB = new EngWorkBench(DataList.EpicConn);
EngWorkBenchDataSet EngWBDS = new EngWorkBenchDataSet();
//string Message;
//EngWB.CheckIn("AZ", "Test12", "C", "", null, false, true, false, false, false, "Test", out Message);
//EngWB.CheckOut("AZ", "Test12", "A", "", null, false, false, false, false, false, out Rev, out Method, out altMethodFlg);
EngWBDS = EngWB.GetDatasetForTree(gid_txt.Text, pnum_txt.Text, rev_txt.Text, "", null, false, false);
EngWB.UndoCheckOut(gid_txt.Text, pnum_txt.Text, rev_txt.Text, "", null, false, false, false, false, EngWBDS);
MessageBox.Show("Complete!");
}
public static void UndoCheckOutPart(string GroupID, string PartNumber, string Revision)
{
EngWorkBench EngWb = new EngWorkBench(EpicConn);
EngWorkBenchDataSet ds = new EngWorkBenchDataSet();
ds = EngWb.GetDatasetForTree(GroupID,PartNumber,Revision,"",DateTime.Today,false,true);
EngWb.UndoCheckOut(GroupID, PartNumber, Revision,"", DateTime.Today, false, false, false, true, ds);
}
public static void CheckInPart(string GroupID, string PartNumber, string Revision)
{
EngWorkBench EngWb = new EngWorkBench(EpicConn);
string opMessage;
EngWb.CheckIn(GroupID, PartNumber, Revision, "", DateTime.Now, false, false, true, true, false, "FOR EPICOR INTEGRATION MODULE", out opMessage);
EpicClose();
}
public static void CheckOutPart(string GroupID, string PartNumber, string Revision)
{
string CheckedOutRevNum;
string altMethodMsg;
bool altMethodFlg;
EngWorkBench EngWb = new EngWorkBench(EpicConn);
EngWb.CheckOut(GroupID, PartNumber, Revision, "", DateTime.Today, false, false, false, true, false, out CheckedOutRevNum, out altMethodMsg, out altMethodFlg);
EpicClose();
}
public static DataSet EngWB_DS(string GroupID, string PartNumber, string Rev)
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
EngWorkBenchDataSet EngWBDS = new EngWorkBenchDataSet();
EngWBDS = EngWB.GetDatasetForTree(GroupID,PartNumber,Rev, "", DateTime.Today, false, false);
return (DataSet)EngWBDS;
}
public static DataSet GroupIDDataSet()
{
bool MorePages;
EngWorkBench EngBench = new EngWorkBench(EpicConn);
DataSet ds = (DataSet)EngBench.GetList(" BY GroupID", 100, 0, out MorePages);
EpicClose();
return ds;
}
public EngWorkBenchDataSet CheckOut(string ipGroupID, string ipPartNum, string ipRevisionNum, string ipAltMethod, DateTime? ipAsOfDate, bool ipCompleteTree, bool ipValidPassword, bool ipReturn, bool ipGetDatasetForTree, bool ipUseMethodForParts, out string opCheckedOutRevisionNum, out string altMethodMsg, out bool altMethodFlg)
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
EngWorkBenchDataSet ReturnMethod = EngWB.CheckOut(ipGroupID, ipPartNum, ipRevisionNum, ipAltMethod, ipAsOfDate, ipCompleteTree, ipValidPassword, ipReturn, ipGetDatasetForTree, ipUseMethodForParts, out opCheckedOutRevisionNum, out altMethodMsg, out altMethodFlg);
EpicClose();
return ReturnMethod;
}
public void GetAvailTaskSets(out string NewList)
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
EngWB.GetAvailTaskSets(out NewList);
EpicClose();
}
public string GetCodeDescList()
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
string ReturnMethod = EngWB.GetCodeDescList("ECORev", "ProcessMode");
EpicClose();
return ReturnMethod;
}
/// <summary>
///
/// </summary>
/// <param name="ipGroupID">ECO Group ID</param>
/// <param name="ipPartNum">Part Number</param>
/// <param name="ipRevisionNum">Revision Number</param>
/// <param name="ipAltMethod">Normally Null string</param>
/// <param name="ipAsOfDate">Current Date/Time</param>
/// <param name="ipCompleteTree">Normally False</param>
/// <param name="ipUseMEthodForParts">Normally True</param>
/// <returns></returns>
public EngWorkBenchDataSet GetDatasetForTree(string ipGroupID, string ipPartNum, string ipRevisionNum, string ipAltMethod, DateTime? ipAsOfDate, bool ipCompleteTree, bool ipUseMEthodForParts)
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
EngWorkBenchDataSet MethodReturned = EngWB.GetDatasetForTree(ipGroupID,ipPartNum,ipRevisionNum,ipAltMethod,ipAsOfDate,ipCompleteTree,ipUseMEthodForParts);
EpicClose();
return MethodReturned;
}
/// <summary>
///
/// </summary>
/// <param name="ipGroupID">ECO Group ID</param>
/// <param name="ipCheckOutStatus">Normally should be true</param>
/// <returns></returns>
public EngWorkBenchDataSet GetECORevData(string ipGroupID, bool ipCheckOutStatus)
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
EngWorkBenchDataSet ReturnMethod = EngWB.GetECORevData(ipGroupID, ipCheckOutStatus);
EpicClose();
return ReturnMethod;
}
public ECOGroupListDataSet GetList(string ipGroupID)
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
bool morePages;
ECOGroupListDataSet ReturnMethod = EngWB.GetList("GroupID = '" + ipGroupID + "' BY GroupID", 0, 0, out morePages);
EpicClose();
return ReturnMethod;
}
public DataSet GetProjectRoles()
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
DataSet MethodReturned = EngWB.GetProjectRoles();
EpicClose();
return MethodReturned;
}
/// <summary>
///
/// </summary>
/// <param name="ipGroupID">ECO Group ID</param>
public void GroupLock(string ipGroupID)
{
EngWorkBench EngWB = new EngWorkBench(EpicConn);
EngWB.GroupLock(ipGroupID);
EpicClose();
}
public static void ApprovePart(EngWorkBenchDataSet EngDataSet,string GroupID,string PartNumber, string Revision)
{
EngWorkBench EngWb = new EngWorkBench(EpicConn);
EngDataSet = EngWb.GetDatasetForTree(GroupID, PartNumber, Revision, "", DateTime.Now, false, false);
EngDataSet.Tables["ECORev"].Rows[0]["Approved"] = true;
EngWb.CheckECORevApproved(true, false, EngDataSet);
EngWb.Update(EngDataSet);
EpicClose();
}
