コード例 #1
0
ファイル: TaxItemDB.cs プロジェクト: suhasrake/CSLERP
 public static void fillTaxItemGridViewCombo(DataGridViewComboBoxCell cmb)
 {
     cmb.Items.Clear();
     try
     {
         TaxItemDB      taxitemdb = new TaxItemDB();
         List <taxitem> TaxItems  = taxitemdb.getTaxItems();
         foreach (taxitem ti in TaxItems)
         {
             if (ti.status == 1)
             {
                 cmb.Items.Add(ti.TaxItemID + "-" + ti.Description);
             }
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
     }
 }
コード例 #2
0
        public static Boolean InsertSJVHeaderAndDetail(SJVHeader jvh)
        {
            //call when invoice inward is saved
            //Invoice types MRN,Work Order, PO General

            Boolean status    = true;
            string  utString  = "";
            string  updateSQL = "";

            try
            {
                updateSQL = "Delete from SJVHeader where InvDocumentID='" + jvh.InvDocumentID + "'" +
                            " and InvTempNo=" + jvh.InvTempNo +
                            " and InvTempDate='" + jvh.InvTempDate.ToString("yyyy-MM-dd") + "'";
                utString  = utString + updateSQL + Main.QueryDelimiter;
                updateSQL = "Delete from SJVDetail where InvDocumentID='" + jvh.InvDocumentID + "'" +
                            " and InvTempNo=" + jvh.InvTempNo +
                            " and InvTempDate='" + jvh.InvTempDate.ToString("yyyy-MM-dd") + "'";
                utString = utString + updateSQL + Main.QueryDelimiter;
                //--
                updateSQL = "insert into SJVHeader " +
                            "(DocumentID,TemporaryNo,TemporaryDate,JournalNo,JournalDate,Narration," +
                            "InvDocumentID,InvTempNo,InvTempDate,InvReferenceNo," +
                            "Comments,CommentStatus,CreateUser,CreateTime,ForwarderList,DocumentStatus,Status)" +
                            " values (" +
                            "'" + jvh.DocumentID + "'," +
                            jvh.TemporaryNo + "," +
                            "'" + jvh.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
                            jvh.JournalNo + "," +
                            "'" + jvh.JournalDate.ToString("yyyy-MM-dd") + "'," +
                            "'" + jvh.Narration + "'," +
                            "'" + jvh.InvDocumentID + "'," +
                            jvh.InvTempNo + "," +
                            "'" + jvh.InvTempDate.ToString("yyyy-MM-dd") + "'," +
                            jvh.InvReferenceNo + "," +
                            "'" + jvh.Comments + "'," +
                            "'" + jvh.CommentStatus + "'," +
                            "'" + Login.userLoggedIn + "'," +
                            "GETDATE()" + "," +
                            "'" + jvh.ForwarderList + "'," +
                            jvh.DocumentStatus + "," +
                            jvh.status + ")";

                utString = utString + updateSQL + Main.QueryDelimiter;
                //////utString = utString +
                //////ActivityLogDB.PrepareActivityLogQquerString("insert", "SJVHeader", "", updateSQL) +
                //////Main.QueryDelimiter;


                jvaccmapping jvAcc = AutoJVAccMappingDB.getjvaccmappingPerDocument(jvh.DocumentID, jvh.InvDocumentID);
                if (jvAcc.AccountCodeDebit == null || jvAcc.AccountCodeDebit.Trim().Length == 0 || jvAcc.AccountCodeCredit == null || jvAcc.AccountCodeCredit.Length == 0)
                {
                    MessageBox.Show("Debit and credit account not mapped for this document.\n Failed to update sales journal.");
                    return(false);
                }


                updateSQL = "insert into SJVDetail " +
                            "(DocumentID,TemporaryNo,TemporaryDate,AccountCode,AmountDebit,AmountCredit,SLCode,SLType,INVDocumentID,InvTempNo,InvTempDate) " +
                            "values ('" + jvh.DocumentID + "'," +
                            jvh.TemporaryNo + "," +
                            "'" + jvh.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
                            /// "'11111111110248'," +//sundry creditors // credit
                            "'" + jvAcc.AccountCodeDebit + "'," +
                            (jvh.Amtount) + "," +
                            0 + ",'" + jvh.Customer + "','Party','" + jvh.InvDocumentID + "'," +
                            jvh.InvTempNo + "," +
                            "'" + jvh.InvTempDate.ToString("yyyy-MM-dd") + "')";
                utString = utString + updateSQL + Main.QueryDelimiter;
                //////utString = utString +
                //////ActivityLogDB.PrepareActivityLogQquerString("insert", "SJVDetail", "", updateSQL) +
                //////Main.QueryDelimiter;
                //--
                updateSQL = "insert into SJVDetail " +
                            "(DocumentID,TemporaryNo,TemporaryDate,AccountCode,AmountDebit,AmountCredit,SLCode,SLType,INVDocumentID,InvTempNo,InvTempDate) " +
                            "values ('" + jvh.DocumentID + "'," +
                            jvh.TemporaryNo + "," +
                            "'" + jvh.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
                            //"'11111111110557'," + //purchase ac
                            "'" + jvAcc.AccountCodeCredit + "'," +
                            0 + "," +
                            (jvh.Amtount - jvh.TaxAmount) + ",'','','" + jvh.InvDocumentID + "'," +
                            jvh.InvTempNo + "," +
                            "'" + jvh.InvTempDate.ToString("yyyy-MM-dd") + "')";
                utString = utString + updateSQL + Main.QueryDelimiter;
                //////utString = utString +
                //////ActivityLogDB.PrepareActivityLogQquerString("insert", "SJVDetail", "", updateSQL) +
                //////Main.QueryDelimiter;

                //Updating SJV references in INvoice out
                updateSQL = "update InvoiceOutHeader set SJVTNo=" + jvh.TemporaryNo +
                            ", SJVTDate='" + jvh.TemporaryDate.ToString("yyyy-MM-dd") + "'" +
                            ", SJVNo='" + jvh.JournalNo + "'" +
                            ", SJVDate='" + jvh.JournalDate.ToString("yyyy-MM-dd") + "'" +
                            " where DocumentID='" + jvh.InvDocumentID + "'" +
                            " and TemporaryNo=" + jvh.InvTempNo +
                            " and TemporaryDate='" + jvh.InvTempDate.ToString("yyyy-MM-dd") + "'";
                utString = utString + updateSQL + Main.QueryDelimiter;
                ////utString = utString +
                ////ActivityLogDB.PrepareActivityLogQquerString("update", "JournalVoucherHeader", "", updateSQL) +
                ////Main.QueryDelimiter;

                try
                {
                    TaxItemDB      taxitemdb = new TaxItemDB();
                    List <taxitem> TaxItems  = taxitemdb.getTaxItems();

                    string[] lst1 = jvh.TaxDetail.Split('\n');
                    for (int i = 0; i < lst1.Length - 1; i++)
                    {
                        string   taxCode = "Not Found";
                        string[] lst2    = lst1[i].Split('-');
                        int      ind     = searchList(TaxItems, lst2[0]);
                        if (ind >= 0)
                        {
                            taxCode = TaxItems[ind].AccountCodeOUT;
                        }
                        updateSQL = "insert into SJVDetail " +
                                    "(DocumentID,TemporaryNo,TemporaryDate,AccountCode,AmountDebit,AmountCredit,SLCode,SLType,INVDocumentID,InvTempNo,InvTempDate) " +
                                    "values ('" + jvh.DocumentID + "'," +
                                    jvh.TemporaryNo + "," +
                                    "'" + jvh.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
                                    "'" + taxCode + "'," +
                                    0 + "," +
                                    lst2[1] + ",'','','" + jvh.InvDocumentID + "'," +
                                    jvh.InvTempNo + "," +
                                    "'" + jvh.InvTempDate.ToString("yyyy-MM-dd") + "')";
                        utString = utString + updateSQL + Main.QueryDelimiter;
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show("InsertSJVHeaderAndDetail() : Error creating tax entries - " + ex.ToString());
                }
                if (!UpdateTable.UT(utString))
                {
                    status = false;
                }
            }
            catch (Exception ex)
            {
                status = false;
                MessageBox.Show("Transaction Exception Occured");
            }
            return(status);
        }