public HttpResponseMessage DailyBillList(HttpRequestMessage reqObject)
{
string walletaccNo = string.Empty;
UsbCollection _UsbCollection = new UsbCollection();
//_businessData = _IDataManipulation.GetBusinessData(reqObject);
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
_UsbCollection = JsonConvert.DeserializeObject <UsbCollection>(_requestedDataObject.BusinessData);
walletaccNo = _UsbCollection.WalletAccountNo;
}
var result = _IUsbReceiveService.DailyBillList(_UsbCollection);
if (result != null)
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "information has been fetched successfully");
}
else
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "Data Not Found...");
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
public IEnumerable <UsbCollection> DailyBillList(UsbCollection _usbCollection)
{
try
{
//GetSysNo(walletAccNo);
var walletAccNo = _usbCollection.WalletAccountNo;
//var Todate = Convert.ToDateTime(_usbCollection.ToDate.ToShortDateString());
var result = _IUoW.Repository <AccMaster>().Get(a => a.WalletAccountNo == walletAccNo).Select(s => s.SystemAccountNo).ToList();
var sys = result[0];
var date = Convert.ToDateTime(DateTime.Now.ToShortDateString());
// var _DailyusbCollection = _IUoW.mTakaDbQuery().DailyusbCollection_LQ();
if (_usbCollection.FormDate != null && _usbCollection.ToDate != null)
{
var FormDate = _usbCollection.FormDate.Value.Date;
var Todate = _usbCollection.ToDate.Value.Date;
var _DailyusbCollection = _IUoW.Repository <UsbCollection>().Get(x => x.TransDate >= FormDate && x.TransDate <= Todate && x.SysAccNo == sys).Select(s => new UsbCollection {
totalPaidAmount = s.totalPaidAmount, TransDate = s.TransDate
}).ToList();
return(_DailyusbCollection);
}
else
{
var _DailyusbCollection = _IUoW.Repository <UsbCollection>().Get(x => x.TransDate == date && x.SysAccNo == sys).Select(s => new UsbCollection {
totalPaidAmount = s.totalPaidAmount, TransDate = s.TransDate
}).ToList();
return(_DailyusbCollection);
}
}
catch (Exception ex)
{
_ObjErrorLogService = new ErrorLogService();
_ObjErrorLogService.AddErrorLog(ex, string.Empty, "DailyusbCollection()", string.Empty);
return(null);
}
}
public HttpResponseMessage SaveUsb(HttpRequestMessage reqObject)
{
int result = 0;
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
UsbCollection _UsbCollection = new UsbCollection();
_UsbCollection = JsonConvert.DeserializeObject <UsbCollection>(_requestedDataObject.BusinessData);
result = _IUsbReceiveService.SaveUsb(_UsbCollection);
}
if (result == 1)
{
_serviceResponse = _IDataManipulation.ResopnseWhenDataFound(result, "information has been added successfully");
}
else
{
_serviceResponse = _IDataManipulation.ResopnseWhenDataNotFound("Account Type Not Found...");
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
public int SaveUsb(UsbCollection _usbCollection)
{
try
{
var AccInfo = _IUoW.Repository <CustomerAccProfile>().GetBy(x => x.WalletAccountNo == _usbCollection.FromSystemAccountNo);
var SpecialOffer = _IUoW.Repository <SpecialOffers>().GetBy(x => x.AccTypeId == AccInfo.AccTypeId &&
x.DefineServiceId == _usbCollection.PvId);
string MainAuthFlag = string.Empty;
var Accresult = _IUoW.Repository <AccMaster>().Get(a => a.WalletAccountNo == _usbCollection.FromSystemAccountNo).Select(s => s.SystemAccountNo).ToList();
var sysAccNo = Accresult[0];
var max = _IUoW.Repository <UsbCollection>().GetMaxValue(x => x.BillSlNo) + 1;
_usbCollection.BillSlNo = max.ToString().PadLeft(3, '0');
_usbCollection.MakeDate = System.DateTime.Now;
_usbCollection.TransDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
_usbCollection.Paid = "1";
_usbCollection.MakeBy = "Kabir";
var Today = Convert.ToDateTime(DateTime.Now.ToShortDateString());
var StartDate = SpecialOffer.StartDate.Value.Date;
var EndDate = SpecialOffer.EndDate.Value.Date;
if (Today >= StartDate && Today <= EndDate)
{
_usbCollection.totalPaidAmount = _usbCollection.totalBillAmount - Convert.ToInt32(SpecialOffer.RateAmount);
}
else
{
_usbCollection.totalPaidAmount = _usbCollection.totalBillAmount;
}
var result = _IUoW.Repository <UsbCollection>().Add(_usbCollection);
#region Auth Log
if (result == 1)
{
string url = ConfigurationManager.AppSettings["LgurdaService_server"] + "/GetAuthPermissionByFunctionId/" + _usbCollection.FunctionId + "/" + _usbCollection.FunctionName + "?format=json";
using (WebClient wc = new WebClient())
{
TransactionRules OBJ_TransactionRules = new TransactionRules();
var json = wc.DownloadString(url);
OBJ_TransactionRules = JsonConvert.DeserializeObject <TransactionRules>(json);
MainAuthFlag = OBJ_TransactionRules.GetAuthPermissionByFunctionIdResult;
}
if (MainAuthFlag == "1")
{
_IAuthLogService = new AuthLogService();
long _outMaxSlAuthLogDtl = 0;
result = _IAuthLogService.AddAuthLog(_IUoW, null, _usbCollection, "ADD", "0001", _usbCollection.FunctionId, 1, "UsbCollection", "MTK_USB_COLLECTION", "CashInId", _usbCollection.FunctionId, "prova", _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl);
}
if (MainAuthFlag == "1")
{
_IAuthLogService = new AuthLogService();
FTAuthLog _ObjAuthLog = new FTAuthLog();
_ObjAuthLog.TableNm = "MTK_USB_COLLECTION";
_ObjAuthLog.AuthStatusId = "A";
_ObjAuthLog.LastAction = "ADD";
_ObjAuthLog.FunctionId = _usbCollection.FunctionId;
_ObjAuthLog.TablePkColVal = _usbCollection.BillSlNo;
result = _IAuthLogService.SetTableObject_FT <UsbCollection>(_IUoW, _ObjAuthLog, _usbCollection);
}
}
#endregion
if (result == 1)
{
_IUoW.Commit();
}
return(result);
}
catch (Exception ex)
{
_ObjErrorLogService = new ErrorLogService();
_ObjErrorLogService.AddErrorLog(ex, string.Empty, "SaveUSb(obj)", string.Empty);
return(0);
}
}
