private bool UnLockGroup(string groupID) { GLJrnGrpImpl adapterGLJrnGrp = Ice.Lib.Framework.WCFServiceSupport.CreateImpl <GLJrnGrpImpl>(epicorSession, ImplBase <Erp.Contracts.GLJrnGrpSvcContract> .UriPath); GLJrnGrpDataSet ds = new GLJrnGrpDataSet(); adapterGLJrnGrp.GetByID(groupID); adapterGLJrnGrp.UnlockGroup(groupID); adapterGLJrnGrp.Dispose(); return(true); }
private bool DeleteGroup(string groupID) { GLJrnGrpImpl adapterGLJrnGrp = Ice.Lib.Framework.WCFServiceSupport.CreateImpl <GLJrnGrpImpl>(epicorSession, ImplBase <Erp.Contracts.GLJrnGrpSvcContract> .UriPath); GLJrnGrpDataSet ds = new GLJrnGrpDataSet(); ds = adapterGLJrnGrp.GetByID(groupID); ds.Tables["GLJrnGrp"].Rows[0].Delete(); adapterGLJrnGrp.Update(ds); adapterGLJrnGrp.Dispose(); return(true); }
static void Main(string[] args) { #region "executing config section" Guid SessionId = Guid.Empty; var ConnDet = GlobalSysFunctions.GetConnectionString(ConfigFile); EpicorConnection = ConnDet.Item1; AppSrvUrl = ConnDet.Item2; EndpointBinding = GlobalSysFunctions.GetChannel(ConfigFile); SqlCon = new SqlConnection(Convert.ToString(EpicorConnection)); #endregion "executing config section" CurrentFile = Path.GetFileNameWithoutExtension(CurrentFile); AssignValues(); if (ISSTAllocApplicable == "FALSE") { LogMsg.AppendLine(Environment.NewLine + "Sub Treasury Allocation is not applicable for this client, Please varify Stcl_Sysparam ISSTAllocApplicable"); GlobalSysFunctions.ShowCallerInfoSch(false, Convert.ToString(LogMsg), CurrentFile, StclServerLogPath); LogMsg.Clear(); return; } string CompanyName, PlantID, PlantName, WorkstationID, WorkstationDesc, EmployeeID, CountryGroupCode, CountryCode, TenantID; string AllocationLegalNumberID = string.Empty; string SqlStr = string.Empty; DataTable DtLegalNumCnfg = new DataTable(); SessionModImpl SessionModImpl = CreateBusObj <SessionModImpl>(Guid.Empty, SessionModImpl.UriPath); LogMsg.AppendLine(" ******************************************"); try { Guid sessionId = SessionModImpl.Login(); SessionModImpl.SessionID = sessionId; LogMsg.AppendLine("SessionModImpl.Login / Set current SessionId to SessionModImpl.SessionID Success, DateTime: " + DateTime.Now); //To check sub treasury company only, Do not consolidate foreign mission transactions string Sql2 = "SELECT key1 " + " FROM Ice.UD01 WITH (NOLOCK) " + " WHERE Company = '" + TreasuryCompany + "' " + " AND CheckBox01 = 1 " + //CheckBox01 = IsSubTreasury Flag " AND CheckBox02 = 0 " + //CheckBox02 = IsRAS Flag //CheckBox03 = Active Flag " AND CheckBox03 = 1 "; //CheckBox04 = ST Consolidation Process happned only for checked sub treasry DataTable dtSTCompList = new DataTable(); dtSTCompList.Reset(); dtSTCompList = GetDataSet(Sql2).Tables[0]; LogMsg.AppendLine("Total of Active Sub Treasury Company : " + dtSTCompList.Rows.Count); for (int STComp = 0; STComp < dtSTCompList.Rows.Count; STComp++) { string STCompCode = Convert.ToString(dtSTCompList.Rows[STComp][0]); LogMsg.AppendLine("Processing Sub Treasury : " + STCompCode + " -------------------------"); DataSet PendingSTConsolidations = new DataSet(); PendingSTConsolidations.Reset(); PendingSTConsolidations = GetPendingSTConsolidation(STCompCode); DataTable dtGrpHed = new DataTable(); dtGrpHed.Reset(); dtGrpHed = PendingSTConsolidations.Tables[0]; DataTable dtDetail = new DataTable(); dtDetail.Reset(); dtDetail = PendingSTConsolidations.Tables[1]; LogMsg.AppendLine("No Of Rows in dtGrpHed : " + dtGrpHed.Rows.Count + ", dtDetail : " + dtDetail.Rows.Count); for (int GrpHed = 0; GrpHed < dtGrpHed.Rows.Count; GrpHed++) { //Wait 2 Sec if (GrpHed > 0) { System.Threading.Thread.Sleep(2000); } LogMsg.AppendLine("Processing Group Row : " + (GrpHed + 1) + "/" + dtGrpHed.Rows.Count + " -----------------------"); string Company = Convert.ToString(dtGrpHed.Rows[GrpHed]["Company"]); string GroupID = Convert.ToString(dtGrpHed.Rows[GrpHed]["GroupID"]); string BookID = Convert.ToString(dtGrpHed.Rows[GrpHed]["BookID"]); string JournalCode = Convert.ToString(dtGrpHed.Rows[GrpHed]["JournalCode"]); Int32 RunNbr = Convert.ToInt32(dtGrpHed.Rows[GrpHed]["RunNbr"]); string VoteCode = Convert.ToString(dtGrpHed.Rows[GrpHed]["VoteCode"]); string ConsId = Convert.ToString(dtGrpHed.Rows[GrpHed]["ConsId"]); Int32 ConsNo = Convert.ToInt32(dtGrpHed.Rows[GrpHed]["ConsNo"]); string Description = Convert.ToString(dtGrpHed.Rows[GrpHed]["Description"]); string CurrencyCode = Convert.ToString(dtGrpHed.Rows[GrpHed]["CurrencyCode"]); string SiteID = Convert.ToString(dtGrpHed.Rows[GrpHed]["SiteID"]); LogMsg.AppendLine("ST Company : " + STCompCode + ", MDA Company : " + Company + ", GroupID : " + GroupID + ", BookID : " + BookID + ", RunNbr : " + RunNbr + ", VoteCode : " + VoteCode + ", JournalCode : " + JournalCode + ", SiteID : " + SiteID); string expresion = "Company = '" + Company + "' AND GroupID = '" + GroupID + "'"; DataRow[] foundRows = dtDetail.Select(expresion); LogMsg.AppendLine("foundRows in detail table : " + foundRows.Length + " for the Company : " + Company + " GroupID : " + GroupID); expresion = string.Empty; DataTable tmpdt = new DataTable(); tmpdt.Reset(); tmpdt = foundRows.CopyToDataTable(); foundRows = null; DateTime JEDate = Convert.ToDateTime(tmpdt.Rows[0]["JEDate"]); #region GLJrnGrp GLJrnGrpDataSet DsGLJrnGrp = new GLJrnGrpDataSet(); GLJrnGrpImpl GLJrnGrpImpls = CreateBusObj <GLJrnGrpImpl>(sessionId, GLJrnGrpImpl.UriPath); Int32 FiscalYear = 0; string FiscalYearSuffix = string.Empty; Int32 FiscalPeriod = 0; string FiscalCalendarID = string.Empty; string Msg = string.Empty; bool IsGroupExist = false; bool IsHeaderExist = false; try { SessionModImpl.SetCompany(Company, out CompanyName, out PlantID, out PlantName, out WorkstationID, out WorkstationDesc, out EmployeeID, out CountryGroupCode, out CountryCode, out TenantID); LogMsg.AppendLine("GLJrnGrpImpls, CurrentSession.CompanyID : " + Company); if (IsSiteIDFilterApplicable == "TRUE") { string SiteName = string.Empty; SessionModImpl.SetPlant(SiteID, out SiteName); LogMsg.AppendLine("SessionModImpl.SetPlant, SiteID : " + SiteID + ", SiteName : " + SiteName); } GetFiscalPeriod(Company, BookID, JEDate, out FiscalYear, out FiscalYearSuffix, out FiscalPeriod, out FiscalCalendarID); LogMsg.AppendLine("GetFiscalPeriod Success, FiscalYear : " + FiscalYear + " FiscalYearSuffix : " + FiscalYearSuffix + " FiscalPeriod : " + FiscalPeriod + " FiscalCalendarID : " + FiscalCalendarID); if (FiscalYear == 0 || FiscalPeriod == 0 || FiscalCalendarID == string.Empty) { LogMsg.AppendLine("FiscalYear OR FiscalPeriod OR FiscalCalendarID Not Found In Current Compnay : " + Company); continue; } bool MorePage = false; string WhereCls = " Company = '" + Company + "' AND GroupID = '" + GroupID + "'"; DsGLJrnGrp = GLJrnGrpImpls.GetRows(WhereCls, 0, 0, out MorePage); LogMsg.AppendLine("GLJrnGrpImpls.GetRows Success, DsGLJrnGrp.GLJrnGrp.Rows.Count : " + DsGLJrnGrp.GLJrnGrp.Rows.Count); if (DsGLJrnGrp.GLJrnGrp.Rows.Count > 0) { IsGroupExist = true; LogMsg.AppendLine("GLJrnGrpImpls.GetRows Success, GroupID Exists, Company : " + Company + " GroupID " + GroupID); } if (IsGroupExist == false) { GLJrnGrpImpls.GetNewGLJrnGrp(DsGLJrnGrp); string GrpCmp = DsGLJrnGrp.GLJrnGrp[0].Company; LogMsg.AppendLine("GLJrnGrpImpls.GetNewGLJrnGrp Success @ Company : " + GrpCmp); if (GrpCmp != Company) { LogMsg.AppendLine("Current Company is " + Company + ", But Group created in " + GrpCmp + ", Which is invalid"); return; } DsGLJrnGrp.GLJrnGrp[0].GroupID = GroupID; DsGLJrnGrp.GLJrnGrp[0].FiscalYear = FiscalYear; DsGLJrnGrp.GLJrnGrp[0].FiscalPeriod = FiscalPeriod; DsGLJrnGrp.GLJrnGrp[0].FiscalYearSuffix = FiscalYearSuffix; DsGLJrnGrp.GLJrnGrp[0].FiscalCalendarID = FiscalCalendarID; DsGLJrnGrp.GLJrnGrp[0].JEDate = JEDate; DsGLJrnGrp.GLJrnGrp[0].JournalCode = JournalCode; DsGLJrnGrp.GLJrnGrp[0]["STConsNo_c"] = RunNbr; DsGLJrnGrp.GLJrnGrp[0]["STCompany_c"] = STCompCode; DsGLJrnGrp.GLJrnGrp[0]["SiteID_c"] = SiteID; GLJrnGrpImpls.CheckFiscalYear(DsGLJrnGrp, GroupID, JEDate, out Msg); LogMsg.AppendLine("GLJrnGrpImpls.CheckFiscalYear Success"); GLJrnGrpImpls.ChangeEntryMode("S", DsGLJrnGrp); LogMsg.AppendLine("GLJrnGrpImpls.ChangeEntryMode Success"); GLJrnGrpImpls.ChangeBookID(BookID, DsGLJrnGrp); LogMsg.AppendLine("GLJrnGrpImpls.ChangeBookID Success"); GLJrnGrpImpls.Update(DsGLJrnGrp); LogMsg.AppendLine("GLJrnGrpImpls.Update Success"); } } catch (Exception ex) { //Record error RecordErrorLog("GLJrnGrp", ex.Message.ToString(), Company, FiscalPeriod, FiscalPeriod, RunNbr); LogMsg.AppendLine("GLJrnGrpImpls > GLJrnGrp Update Failed > " + ex.Message.ToString()); continue; } #endregion #region GLJrnHed GLJournalEntryDataSet DsGLJournalEntry = new GLJournalEntryDataSet(); GLJournalEntryImpl GLJournalEntryImpls = CreateBusObj <GLJournalEntryImpl>(sessionId, GLJournalEntryImpl.UriPath); LogMsg.AppendLine("GLJournalEntry.GLJrnHed Success"); try { bool RequiredUserInput = false; bool MorePage = false; string WhereCls = " Company = '" + Company + "' AND GroupID = '" + GroupID + "' AND Posted = 0"; DsGLJournalEntry = GLJournalEntryImpls.GetRows(WhereCls, "", "", "", "", "", "", "", 0, 0, out MorePage); LogMsg.AppendLine("GLJournalEntry.GetRows Success, DsGLJournalEntry.GLJrnHed.Rows.Count : " + DsGLJournalEntry.GLJrnHed.Rows.Count); if (DsGLJournalEntry.GLJrnHed.Rows.Count > 0) { LogMsg.AppendLine("GLJournalEntry.GetRows Success, GLJrnHed Exists, Company : " + Company + " GroupID " + GroupID); IsHeaderExist = true; } if (IsHeaderExist == false) { GLJournalEntryImpls.GetNewGlJrnHedTran(DsGLJournalEntry, GroupID); LogMsg.AppendLine("GLJournalEntry.GetNewGlJrnHedTran Success"); DsGLJournalEntry.GLJrnHed[0].FiscalYear = FiscalYear; DsGLJournalEntry.GLJrnHed[0].JournalCode = JournalCode; DsGLJournalEntry.GLJrnHed[0].FiscalPeriod = FiscalPeriod; DsGLJournalEntry.GLJrnHed[0].Description = Description; DsGLJournalEntry.GLJrnHed[0].JEDate = JEDate; DsGLJournalEntry.GLJrnHed[0].FiscalCalendarID = FiscalCalendarID; DsGLJournalEntry.GLJrnHed[0].CurrencyCode = CurrencyCode; DsGLJournalEntry.GLJrnHed[0].FiscalYearSuffix = FiscalYearSuffix; DsGLJournalEntry.GLJrnHed[0].CommentText = Description; DsGLJournalEntry.GLJrnHed[0]["STConsNo_c"] = RunNbr; DsGLJournalEntry.GLJrnHed[0]["STCompany_c"] = STCompCode; DsGLJournalEntry.GLJrnHed[0]["IsSysGenerated_c"] = false; DsGLJournalEntry.GLJrnHed[0]["Submitted4Appr_c"] = false; DsGLJournalEntry.GLJrnHed[0]["Approved_c"] = false; DsGLJournalEntry.GLJrnHed[0]["SiteID_c"] = SiteID; GLJournalEntryImpls.PreUpdate(DsGLJournalEntry, out RequiredUserInput); LogMsg.AppendLine("GLJournalEntry.GLJrnHed.PreUpdate Success"); GLJournalEntryImpls.Update(DsGLJournalEntry); LogMsg.AppendLine("GLJournalEntry.GLJrnHed.Update Success"); } } catch (Exception ex) { //Record error RecordErrorLog("GLJrnHed", ex.Message.ToString(), Company, FiscalPeriod, FiscalPeriod, RunNbr); LogMsg.AppendLine("DsGLJournalEntry.GLJrnHed > Update Failed > " + ex.Message.ToString()); GLJrnGrpDataSet DsGLJrnGrpDelete = new GLJrnGrpDataSet(); GLJrnGrpImpl GLJrnGrpImplsDelete = CreateBusObj <GLJrnGrpImpl>(sessionId, GLJrnGrpImpl.UriPath); DsGLJrnGrpDelete = GLJrnGrpImplsDelete.GetByID(GroupID); LogMsg.AppendLine("GLJrnGrpDelete > GetByID Success, Company : " + Company + " GroupID : " + GroupID); GLJrnGrpImplsDelete.CheckDocumentIsLocked(GroupID); LogMsg.AppendLine("GLJrnGrpDelete > CheckDocumentIsLocked Success, Company : " + Company + " GroupID : " + GroupID); DsGLJrnGrpDelete.GLJrnGrp[0].RowMod = "D"; DsGLJrnGrpDelete.GLJrnGrp[0].Delete(); GLJrnGrpImplsDelete.Update(DsGLJrnGrpDelete); LogMsg.AppendLine("GLJrnGrpDelete > Update Method > Delete Success, Company : " + Company + " GroupID : " + GroupID); continue; } #endregion #region GLJrnDtlMnl bool IsErrorFound = false; int GLJrnDtlMnlRowIndex = 0; for (int Dtl = 0; Dtl < tmpdt.Rows.Count; Dtl++) { try { if (DsGLJournalEntry.GLJrnDtlMnl.Rows.Count != 0) { //Bcoz its updating on line number 0 to ........ //Getting error message, G/L Account is required GLJrnDtlMnlRowIndex = DsGLJournalEntry.GLJrnDtlMnl.Rows.Count; } decimal TransAmtDtl = Convert.ToDecimal(tmpdt.Rows[Dtl]["TransAmt"]); string SessionBookID = DsGLJournalEntry.GLJrnHed[0].BookID; Int32 SessionFiscalYear = DsGLJournalEntry.GLJrnHed[0].FiscalYear; string SessionFiscalYearSuffix = DsGLJournalEntry.GLJrnHed[0].FiscalYearSuffix; string SessionJournalCode = DsGLJournalEntry.GLJrnHed[0].JournalCode; Int32 SessionJournalNum = DsGLJournalEntry.GLJrnHed[0].JournalNum; string SessionGroupID = DsGLJournalEntry.GLJrnHed[0].GroupID; string Expresion = "Company = '" + Company + "' AND GroupID = '" + GroupID + "' AND GLAccount = '" + Convert.ToString(tmpdt.Rows[Dtl]["GLAccount"]) + "' AND TransAmt = " + TransAmtDtl; DataRow[] RowExist = DsGLJournalEntry.GLJrnDtlMnl.Select(Expresion); LogMsg.AppendLine("GLJournalEntry.GetNewGLJrnDtlMnl[" + GLJrnDtlMnlRowIndex + "], " + Expresion); Expresion = string.Empty; if (RowExist.Length > 0) { LogMsg.AppendLine("GLJournalEntry.GetNewGLJrnDtlMnl[" + GLJrnDtlMnlRowIndex + "], Above GLJrnDtlMnl transaction already exist in system with same filters"); } if (RowExist.Length == 0) { GLJournalEntryImpls.GetNewGLJrnDtlMnl(DsGLJournalEntry, SessionBookID, SessionFiscalYear, SessionFiscalYearSuffix, SessionJournalCode, SessionJournalNum, 0); LogMsg.AppendLine("GLJournalEntry.GetNewGLJrnDtlMnl[" + GLJrnDtlMnlRowIndex + "] Success"); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].Description = Description; DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].GroupID = SessionGroupID; DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].GLAccount = Convert.ToString(tmpdt.Rows[Dtl]["GLAccount"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue1 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue1"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue2 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue2"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue3 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue3"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue4 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue4"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue5 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue5"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue6 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue6"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue7 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue7"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue8 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue8"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue9 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue9"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue10 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue10"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue11 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue11"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue12 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue12"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue13 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue13"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue14 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue14"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue15 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue15"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue16 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue16"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue17 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue17"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue18 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue18"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue19 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue19"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].SegValue20 = Convert.ToString(tmpdt.Rows[Dtl]["SegValue20"]); DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex]["STCompany_c"] = STCompCode; DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex]["STConsNo_c"] = RunNbr; DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex]["IsSTCons_c"] = true; DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].TransAmt = TransAmtDtl; if (TransAmtDtl > 0) { DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].TotDebit = TransAmtDtl; } else { DsGLJournalEntry.GLJrnDtlMnl[GLJrnDtlMnlRowIndex].TotCredit = Math.Abs(TransAmtDtl); } LogMsg.AppendLine("DsGLJournalEntry.GLJrnDtlMnl[" + GLJrnDtlMnlRowIndex + "] Values Assigned Success"); GLJournalEntryImpls.Update(DsGLJournalEntry); LogMsg.AppendLine("GLJournalEntry.GLJrnDtlMnl[" + GLJrnDtlMnlRowIndex + "].Update Success"); GLJrnDtlMnlRowIndex += 1; } } catch (Exception ex2) { //Record error IsErrorFound = true; RecordErrorLog("GLJrnDtlMnl", ex2.Message.ToString(), Company, FiscalPeriod, FiscalPeriod, RunNbr); LogMsg.AppendLine("DsGLJournalEntry.GLJrnDtlMnl > Update Failed > " + ex2.Message.ToString()); GLJournalEntryDataSet DsGLJournalEntryDelete = new GLJournalEntryDataSet(); GLJournalEntryImpl GLJournalEntryDelete = CreateBusObj <GLJournalEntryImpl>(sessionId, GLJournalEntryImpl.UriPath); DsGLJournalEntryDelete = GLJournalEntryDelete.GetByGroupID(GroupID); LogMsg.AppendLine("GLJournalEntryDelete > GetByGroupID Success, Company : " + Company + " GroupID : " + GroupID); DsGLJournalEntryDelete.GLJrnHed[0]["IsSysGenerated_c"] = false; DsGLJournalEntryDelete.GLJrnHed[0]["Submitted4Appr_c"] = false; DsGLJournalEntryDelete.GLJrnHed[0]["Approved_c"] = false; DsGLJournalEntryDelete.GLJrnHed[0].RowMod = "U"; GLJournalEntryDelete.Update(DsGLJournalEntryDelete); LogMsg.AppendLine("GLJournalEntryDelete > Update Method > Delete Success, Company : " + Company + " GroupID : " + GroupID); DsGLJournalEntryDelete.GLJrnHed[0].RowMod = "D"; DsGLJournalEntryDelete.GLJrnHed[0].Delete(); GLJournalEntryDelete.Update(DsGLJournalEntryDelete); LogMsg.AppendLine("GLJournalEntryDelete > Delete Success, Company : " + Company + " GroupID : " + GroupID); GLJrnGrpDataSet DsGLJrnGrpDelete = new GLJrnGrpDataSet(); GLJrnGrpImpl GLJrnGrpImplsDelete = CreateBusObj <GLJrnGrpImpl>(sessionId, GLJrnGrpImpl.UriPath); DsGLJrnGrpDelete = GLJrnGrpImplsDelete.GetByID(GroupID); LogMsg.AppendLine("GLJrnGrpDelete > GetByID Success, Company : " + Company + " GroupID : " + GroupID); GLJrnGrpImplsDelete.CheckDocumentIsLocked(GroupID); LogMsg.AppendLine("GLJrnGrpDelete > CheckDocumentIsLocked Success, Company : " + Company + " GroupID : " + GroupID); DsGLJrnGrpDelete.GLJrnGrp[0].RowMod = "D"; DsGLJrnGrpDelete.GLJrnGrp[0].Delete(); GLJrnGrpImplsDelete.Update(DsGLJrnGrpDelete); LogMsg.AppendLine("GLJrnGrpDelete > Update Method > Delete Success, Company : " + Company + " GroupID : " + GroupID); break; //Do not change, Always use break } } #endregion if (IsErrorFound == false) { UpdateGLJrnDtl(STCompCode, VoteCode, GroupID, FiscalYear, FiscalPeriod, RunNbr); LogMsg.AppendLine("UpdateGLJrnDtl Success, Record updated in sub treasury company"); DsGLJournalEntry.GLJrnHed[0]["IsSysGenerated_c"] = true; DsGLJournalEntry.GLJrnHed[0]["Submitted4Appr_c"] = true; DsGLJournalEntry.GLJrnHed[0]["Approved_c"] = true; GLJournalEntryImpls.Update(DsGLJournalEntry); string GroupID1 = DsGLJrnGrp.GLJrnGrp[0].GroupID; GLJrnGrpImpls.UnlockGroup(GroupID1); LogMsg.AppendLine("GLJrnGrpImpls.UnlockGroup Success-------------"); } GlobalSysFunctions.ShowCallerInfoSch(false, Convert.ToString(LogMsg), CurrentFile, StclServerLogPath); LogMsg.Clear(); } } LogMsg.AppendLine("Process Successfully Completed..........."); } catch (Exception ex) { LogMsg.AppendLine("Error : " + ex.Message); } finally { if (SessionModImpl.SessionID != Guid.Empty) { SessionModImpl.Logout(); LogMsg.AppendLine("SessionModImpl logout Success, DateTime: " + DateTime.Now); } LogMsg.AppendLine("--------------------------------------------------------------"); GlobalSysFunctions.ShowCallerInfoSch(false, Convert.ToString(LogMsg), CurrentFile, StclServerLogPath); LogMsg.Clear(); } }