//CharteredAccounts public int UpdChartAccounts(EMClients objClients) { Hashtable htparams = new Hashtable { { "@ChartedAccName", objClients.ChartedAccName }, { "@RefType", objClients.RefType }, { "@RefId", objClients.RefId }, }; int IsSuccess = ExecuteNonQuery("CharteredAccounts_Update", htparams); return(IsSuccess); }
//CreditCard public int InsUpdCreditCardDetails(EMClients objClients) { Hashtable htparams = new Hashtable { { "@CreditCardId", objClients.CreditCardId }, { "@CreditCardCode", objClients.CreditCardCode }, { "@CreditCardType", objClients.CreditCardType }, { "@CreditCardAccNo", objClients.CreditCardAccNo }, { "@CreditCardAccHolder", objClients.CreditCardAccHolder }, { "@CreditCardExpireMonth", objClients.CreditCardExpireMonth }, { "@CreditCardExpireYear", objClients.CreditCardExpireYear }, { "@ClientId", objClients.ClientId } }; int IsSuccess = ExecuteNonQuery("CreditCardDetails_InsUpdate", htparams); return(IsSuccess); }
//Contact public int InsertUpdContact(EMClients objClients) { Hashtable htparams = new Hashtable { { "@ContactId", objClients.ContactId }, { "@ContactKey", objClients.ContactKey }, { "@ContactName", objClients.ContactName }, { "@Position", objClients.Position }, { "@Telephone", objClients.Telephone }, { "@EmailAddress", objClients.EmailAddress }, { "@AutoMail", objClients.AutoMail }, { "@LSupplierId", objClients.LSupplierId }, { "@ClientId", objClients.ClientId }, { "@UserCategory", objClients.UserCategory }, { "@ConCellNo", objClients.ConCellNo }, { "@ConFax", objClients.ConFax }, { "@ConDeactivate", objClients.ConDeactivate }, }; int IsSuccess = ExecuteNonQuery("ContactDetails_InsUpdate", htparams); return(IsSuccess); }
//CharteredAccounts public int InsUpdChartAccounts(EMClients objClients) { Hashtable htparams = new Hashtable { { "@ChartedAccId", objClients.ChartedAccId }, { "@ChartedAccName", objClients.ChartedAccName }, { "@ChartedMasterAccName", objClients.ChartedMasterAccName }, { "@Type", objClients.Type }, { "@AccCode", objClients.AccCode }, { "@CompanyId", objClients.CompanyId }, { "@BranchId", objClients.BranchId }, { "@CreatedBy", objClients.CreatedBy }, { "@DepartmentId", objClients.DepartmentId }, { "@BaseCurrency", objClients.BaseCurrency }, { "@TranCurrency", objClients.TranCurrency }, { "@CategoryId", objClients.CategoryId }, { "@RefType", objClients.RefType }, { "@RefId", objClients.RefId }, { "@IsClient", objClients.IsClient } }; int IsSuccess = ExecuteNonQuery("CharteredAccounts_Insert", htparams); return(IsSuccess); }
//Charted Account name Update public int UpdateChartAccounts(EMClients objClients) { return(objDAClients.UpdChartAccounts(objClients)); }
//CharteredAccounts public int InsUpdChartAccounts(EMClients objClients) { return(objDAClients.InsUpdChartAccounts(objClients)); }
//credidcard public int InsUpdCreditCardDetails(EMClients objClients) { return(objDAClients.InsUpdCreditCardDetails(objClients)); }
//Contact public int InsertUpdContact(EMClients objClients) { return(objDAClients.InsertUpdContact(objClients)); }
public int InsUpdClients(EMClients objClients) { Hashtable htparams = new Hashtable { { "@ClientId", objClients.ClientId }, { "@ClientType", objClients.ClientType }, { "@ClientAccountNo", objClients.ClientAccountNo }, { "@ClientName", objClients.ClientName }, { "@IsActive", objClients.IsActive }, { "@ClientGroup", objClients.ClientGroup }, { "@ClientConsultant", objClients.ClientConsultant }, { "@ClientDepartment", objClients.ClientDepartment }, { "@ClientDivision", objClients.ClientDivision }, { "@ClientVatRegNo", objClients.ClientVatRegNo }, { "@ClientNoVatNo", objClients.ClientNoVatNo }, { "@ClientTelephone", objClients.ClientTelephone }, { "@ClientFax", objClients.ClientFax }, { "@ClientContactPerson", objClients.ClientContactPerson }, { "@ClientEmail", objClients.ClientEmail }, { "@ClientPostalAddress", objClients.ClientPostalAddress }, { "@ClientPhysicalAddress", objClients.ClientPhysicalAddress }, { "@YearEnd", objClients.YearEnd }, { "@Logo", objClients.Logo }, { "@HtmlWidth", objClients.HtmlWidth }, { "@HtmlHeight", objClients.HtmlHeight }, { "@Align", objClients.Align }, { "@IsDisableAutoPrintManual", objClients.IsDisableAutoPrintManual }, { "@IsDisableAutoPrintTicket", objClients.IsDisableAutoPrintTicket }, { "@DefaultOrderNo", objClients.DefaultOrderNo }, { "@IsForceOrderNo", objClients.IsForceOrderNo }, { "@IsForceExternalVoucher", objClients.IsForceExternalVoucher }, { "@ClientDuplicateOrderNo", objClients.ClientDuplicateOrderNo }, { "@ActionIsNoServiceFee", objClients.ActionIsNoServiceFee }, { "@ClientOpenItemLoad", objClients.ClientOpenItemLoad }, { "@ClientBroughtFwdBreakDwn", objClients.ClientBroughtFwdBreakDwn }, { "@ClientLineItemBreakDwn", objClients.ClientLineItemBreakDwn }, { "@ClientDbOrCd", objClients.ClientDbOrCd }, { "@ClientSuppressNilVal", objClients.ClientSuppressNilVal }, { "@ClientTotalCharge", objClients.ClientTotalCharge }, { "@ClientCreditCard", objClients.ClientCreditCard }, { "@ClientTransactionRef", objClients.ClientTransactionRef }, { "@ClientAllocPaidItems", objClients.ClientAllocPaidItems }, { "@ClientCustmDetail", objClients.ClientCustmDetail }, { "@ClientExcludeFmPrint", objClients.ClientExcludeFmPrint }, { "@ClientCreditLimit", objClients.ClientCreditLimit }, { "@ClientLimitAction", objClients.ClientLimitAction }, { "@ClientMaxInvoiceVal", objClients.ClientMaxInvoiceVal }, { "@ClientCreditTerms", objClients.ClientCreditTerms }, { "@ClientTermsAction", objClients.ClientTermsAction }, { "@IsForce", objClients.IsForce }, { "@ClientCalAir", objClients.ClientCalAir }, { "@ClientCalLand", objClients.ClientCalLand }, { "@ClientDirectSettleTrans", objClients.ClientDirectSettleTrans }, { "@ClientCCForCashTrans", objClients.ClientCCForCashTrans }, { "@IsTicketOrLandCreditCard", objClients.IsTicketOrLandCreditCard }, { "@CreditCardImportedTickets", objClients.CreditCardImportedTickets }, { "@ClientNotes", objClients.ClientNotes }, { "@ClientMessage", objClients.ClientMessage }, { "@CreatedBy", objClients.CreatedBy }, { "@LogoPath", objClients.LogoPath }, { "@CContactKey", objClients.CContactKey }, { "@CContactName", objClients.CContactName }, { "@CPosition", objClients.CPosition }, { "@CTelephone", objClients.CTelephone }, { "@CEmailAddress", objClients.CEmailAddress }, { "@CAutoMail", objClients.CAutoMail }, { "@CCellNo", objClients.CCellNo }, { "@CFax", objClients.CFax }, { "@CDeactivate", objClients.CDeactivate }, { "@ClientAccCode", objClients.ClientAccCode }, { "@ClientTypeAccCode", objClients.ClientTypeAccCode }, { "@ClientAccCode", objClients.CompanyId }, { "@ClientTypeAccCode", objClients.BranchId } }; int IsSuccess = ExecuteNonQuery("Clients_InsertUpdate", htparams, "@return"); return(IsSuccess); }