예제 #1
0
        public int InsertLandArrangement(EMLandarrangement objLandarrangements)
        {
            Hashtable htparams = new Hashtable
            {
                { "@IsCreditNote", objLandarrangements.IsCreditNote },
                { "@LandArrId", objLandarrangements.LandArrId },
                { "@LandSupplier", objLandarrangements.LandSupplier },
                { "@Services", objLandarrangements.Services },
                { "@Type", objLandarrangements.Type },
                { "@PassengerName", objLandarrangements.PassengerName },
                { "@TravelFrDate", objLandarrangements.TravelFrDate },
                { "@TravelToDate", objLandarrangements.TravelToDate },
                { "@BookRefNo", objLandarrangements.BookRefNo },
                { "@Voucher", objLandarrangements.Voucher },
                { "@SuppRef", objLandarrangements.SuppRef },
                { "@SuppInvNo", objLandarrangements.SuppInvNo },
                { "@TotIncl", objLandarrangements.TotIncl },
                { "@ExclVatPer", objLandarrangements.ExclVatPer },
                { "@ExclusiveVatAmount", objLandarrangements.ExclusiveVatAmount },
                { "@VatPer", objLandarrangements.VatPer },
                { "@TotExclu", objLandarrangements.TotExclu },
                { "@Payment", objLandarrangements.Payment },
                { "@CreditCard", objLandarrangements.CreditCard },
                { "@CO2Emis", objLandarrangements.CO2Emis },
                { "@Units", objLandarrangements.Units },
                { "@RateInclu", objLandarrangements.RateInclu },
                { "@CommissionableInclu", objLandarrangements.CommissionableInclu },
                { "@CommabExclu", objLandarrangements.CommabExclu },
                { "@OthCommabInclu", objLandarrangements.OthCommabInclu },
                { "@TotCommabInclu", objLandarrangements.TotCommabInclu },
                { "@NonCommabInclu", objLandarrangements.NonCommabInclu },
                { "@CommPer", objLandarrangements.CommPer },
                { "@CommissionInclu", objLandarrangements.CommissionInclu },
                { "@CommissionExclu", objLandarrangements.CommissionExclu },
                { "@CommissionVatPer", objLandarrangements.CommissionVatPer },
                { "@CommVatAmount", objLandarrangements.CommVatAmount },
                { "@DueTOSupplier", objLandarrangements.DueTOSupplier },
                { "@DueToClient", objLandarrangements.DueToClient },
                { "@LessCommission", objLandarrangements.LessCommission },
                { "@LandProInvId", objLandarrangements.ProInvId },
                { "@LandInvId", objLandarrangements.LandInvId },
                { "@CompanyId", objLandarrangements.CompanyId },
                { "@T5ID", objLandarrangements.T5ID },
                { "@StatusId", objLandarrangements.StatusId },
                { "@BranchId", objLandarrangements.BranchId },
                { "@CreatedBy", objLandarrangements.CreatedBy },
                { "@UpdateBy", objLandarrangements.UpdatedBy },
                { "@CreatedON", objLandarrangements.CreatedON },
                { "@UpdateON", objLandarrangements.UpdatedON },
                { "@LandTempUniqCode", objLandarrangements.LandTempUniqCode },
                { "@InvoiceType", objLandarrangements.InvoiceType },
                { "@SupplOpeningAmount", objLandarrangements.SupplOpenAmount },
                { "@InvDocumentNo", objLandarrangements.invDocumentNo },
                { "@RefundAmount", objLandarrangements.RefundAmount }
            };

            int IsSuccess = ExecuteNonQuery("Landarrangements_Insert", htparams);

            return(IsSuccess);
        }
예제 #2
0
 public int InsertLanadarrangement(EMLandarrangement objLandarrangement)
 {
     return(objDALandarrangement.InsertLandArrangement(objLandarrangement));
 }