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);
}
