internal static decimal Get_TotalPaidAgent(long OrignalAgentID) { decimal d = 0; var a = Table_AdapterTransec.ScalarQuery_TransecAgent_T_ReceivedSum_StoreProcedure_Func(OrignalAgentID); if (a != null) { d = (decimal)a; } return(d); }
internal static decimal Get_TotalRecieveableCustomer(long OrignalCustomerID) { decimal d = 0; var a = Table_AdapterTransec.ScalarQuery_TransecRecieveableTotal_StoreProcedure_Func(OrignalCustomerID); if (a != null) { d = (decimal)a; } return(d); }
internal static Bookings_And_payments_DataSet_appData.TransecRow Get_Transec_Row(string OrignalServiceID) { Bookings_And_payments_DataSet_appData.TransecDataTable ds = new Bookings_And_payments_DataSet_appData.TransecDataTable(); Table_AdapterTransec.FillBy_Transec_RowByServiceID(ds, OrignalServiceID); var gg = (from o in ds where (o.SERVICE_ID == OrignalServiceID) select o).FirstOrDefault(); return(gg); }
internal static void UpdateStatus(bool status, string Orignalserviceid) { Table_AdapterTransec.UpdateQuery_Transec_Status_by_ServiceID_StoreProcedure_Func(status, Orignalserviceid); }
/// <summary> /// Services Names "PROTECTOR", "DUBAI VISIT" ,"SAUDI VISA STAMP" , "TICKET BOOKED", "BOOKING" /// </summary> /// <param name="serviceID"></param> /// <param name="Customerid"></param> /// <param name="OrignalRecieveable"></param> /// <param name="t_Recieved"></param> /// <param name="remaining"></param> /// <param name="serviceName"></param> internal static void NewTransec(string serviceID, string Customerid, string OrignalRecieveable, string t_Recieved, string remaining, string serviceName) { Table_AdapterTransec.Insert(serviceID, long.Parse(Customerid), DateTime.Now, decimal.Parse(OrignalRecieveable), decimal.Parse(t_Recieved), decimal.Parse(remaining), serviceName, true); }