public int AddAccTypeWiseTarget(AccTypeWiseTarget _AccTypeWiseTarget)
{
try
{
var _max = _IUoW.Repository <AccTypeWiseTarget>().GetMaxValue(x => x.TargetSlNo) + 1;
_AccTypeWiseTarget.TargetSlNo = _max.ToString().PadLeft(3, '0');
_AccTypeWiseTarget.AuthStatusId = "U";
_AccTypeWiseTarget.LastAction = "ADD";
_AccTypeWiseTarget.MakeDT = System.DateTime.Now;
_AccTypeWiseTarget.MakeBy = "mtaka";
var result = _IUoW.Repository <AccTypeWiseTarget>().Add(_AccTypeWiseTarget);
#region Auth Log
if (result == 1)
{
_IAuthLogService = new AuthLogService();
long _outMaxSlAuthLogDtl = 0;
result = _IAuthLogService.AddAuthLog(_IUoW, null, _AccTypeWiseTarget, "ADD", "0001", _AccTypeWiseTarget.FunctionId, 1, "AccTypeWiseTarget", "MTK_SP_CUS_TYPE", "AccTypeWiseTargetId", _AccTypeWiseTarget.TargetSlNo, _AccTypeWiseTarget.UserName, _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl);
}
#endregion
if (result == 1)
{
_IUoW.Commit();
}
return(result);
}
catch (Exception ex)
{
_ObjErrorLogService = new ErrorLogService();
_ObjErrorLogService.AddErrorLog(ex, string.Empty, "AddAccTypeWiseTarget(obj)", string.Empty);
return(0);
}
}
public HttpResponseMessage GetTargetInfoForGraph(HttpRequestMessage reqObject)
{
string walletaccNo = string.Empty;
AccTypeWiseTarget _AccTypeWiseTarget = new AccTypeWiseTarget();
//_businessData = _IDataManipulation.GetBusinessData(reqObject);
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
_AccTypeWiseTarget = JsonConvert.DeserializeObject <AccTypeWiseTarget>(_requestedDataObject.BusinessData);
}
var result = _IAccTypeWiseTargetService.GetTargetInfoForGraph(_AccTypeWiseTarget);
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 <AccTypeWiseTargetView> GetTargetInfoForGraph(AccTypeWiseTarget _AccTypeWiseTarget)
{
try
{
int i = 0;
List <AccTypeWiseTargetView> UserNameList = new List <AccTypeWiseTargetView>();
dynamic Actual = _IUoW.mTakaDbQuery().ActualAmount_LQ(_AccTypeWiseTarget);
if (Actual == null)
{
return(null);
}
var _ListAccTypeWiseTarget = _IUoW.Repository <AccTypeWiseTarget>().Get(x => x.AccCategoryId == _AccTypeWiseTarget.AccCategoryId &&
x.AccTypeId == _AccTypeWiseTarget.AccTypeId &&
x.DefineServiceId == _AccTypeWiseTarget.DefineServiceId &&
x.District == _AccTypeWiseTarget.District &&
x.Area == _AccTypeWiseTarget.Area &&
x.CalenderPrdId == _AccTypeWiseTarget.CalenderPrdId &&
x.AuthStatusId == "A" &&
x.LastAction != "DEL").
Select(s => s.Amount).ToList();
if (_AccTypeWiseTarget.AccTypeId == "004")
{
UserNameList = _IUoW.Repository <CustomerAccProfile>().Get(x => x.PermanentDistrict == _AccTypeWiseTarget.District &&
x.AccTypeId == _AccTypeWiseTarget.AccTypeId &&
x.PermanentArea == _AccTypeWiseTarget.Area)
.Select(s => new AccTypeWiseTargetView {
name = s.UserName,
market1 = 1,
market2 = Convert.ToInt32(s.PermanentDistrict),
target = Convert.ToInt32(_ListAccTypeWiseTarget[0])
}).ToList();
}
foreach (var element in UserNameList)
{
UserNameList[i].actual = Actual[i];
i++;
}
return(UserNameList);
}
catch (Exception ex)
{
_ObjErrorLogService = new ErrorLogService();
_ObjErrorLogService.AddErrorLog(ex, string.Empty, "GetTargetInfoForGraph()", string.Empty);
return(null);
}
}
public HttpResponseMessage AddAccTypeWiseTarget(HttpRequestMessage reqObject)
{
int result = 0;
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
_AccTypeWiseTarget = JsonConvert.DeserializeObject <AccTypeWiseTarget>(_requestedDataObject.BusinessData);
result = _IAccTypeWiseTargetService.AddAccTypeWiseTarget(_AccTypeWiseTarget);
}
if (result == 1)
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "information has been added successfully");
}
else
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "Information hasn't been added");
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
public AccTypeWiseTarget GetAccTypeWiseTargetBy(AccTypeWiseTarget _AccTypeWiseTarget)
{
throw new NotImplementedException();
}
public int DeleteAccTypeWiseTarget(AccTypeWiseTarget _AccTypeWiseTarget)
{
throw new NotImplementedException();
}
