///<summary></summary> public static long Insert(EServiceBilling eServiceBilling) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { eServiceBilling.EServiceBillingNum = Meth.GetLong(MethodBase.GetCurrentMethod(), eServiceBilling); return(eServiceBilling.EServiceBillingNum); } return(Crud.EServiceBillingCrud.Insert(eServiceBilling)); }
///<summary>Must be connected to customers db. Gets itemized charges which have been serialized to specific eServiceBilling row for given regKeyNum and billDate.</summary> public static List <EServiceInvoiceLineItem> GetByRegKeyNumAndBillDate(long regKeyNum, DateTime billDate) { //HQ only. No remoting role needed. string command = "SELECT * FROM eservicebilling WHERE RegistrationKeyNum = " + POut.Long(regKeyNum) + " AND DateOfBill=" + POut.Date(billDate); EServiceBilling esb = Crud.EServiceBillingCrud.SelectOne(command); if (esb == null || string.IsNullOrEmpty(esb.ItemizedCharges)) { return(new List <EServiceInvoiceLineItem>()); } return(JsonConvert.DeserializeObject <List <EServiceInvoiceLineItem> >(esb.ItemizedCharges)); }