public HttpResponseMessage SaveTrnCommissionRequest(TrnCommissionRequest commisionrequest)
{
try
{
var TrnCommissionRequestData = from d in db.TrnCommissionRequests
where d.Id == Convert.ToInt32(commisionrequest.Id) select d;
if (TrnCommissionRequestData.Any())
{
if (TrnCommissionRequestData.FirstOrDefault().IsLocked == false)
{
var currentUser = from d in db.MstUsers
where d.AspNetId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var UpdateTrnCommissionRequestData = TrnCommissionRequestData.FirstOrDefault();
UpdateTrnCommissionRequestData.CommissionRequestNumber = commisionrequest.CommissionRequestNumber;
UpdateTrnCommissionRequestData.CommissionRequestDate = Convert.ToDateTime(commisionrequest.CommissionRequestDate);
UpdateTrnCommissionRequestData.BrokerId = commisionrequest.BrokerId;
UpdateTrnCommissionRequestData.SoldUnitId = commisionrequest.SoldUnitId;
UpdateTrnCommissionRequestData.CommissionNumber = commisionrequest.CommissionNumber;
UpdateTrnCommissionRequestData.Amount = commisionrequest.Amount;
UpdateTrnCommissionRequestData.Remarks = commisionrequest.Remarks;
UpdateTrnCommissionRequestData.PreparedBy = commisionrequest.PreparedBy;
UpdateTrnCommissionRequestData.CheckedBy = commisionrequest.CheckedBy;
UpdateTrnCommissionRequestData.ApprovedBy = commisionrequest.ApprovedBy;
UpdateTrnCommissionRequestData.Status = commisionrequest.Status;
UpdateTrnCommissionRequestData.UpdatedBy = currentUser.FirstOrDefault().Id;
UpdateTrnCommissionRequestData.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public HttpResponseMessage UnlockTrnCommissionRequest(TrnCommissionRequest commissionRequest)
{
try
{
var TrnCommissionRequestData = from d in db.TrnCommissionRequests
where d.Id == Convert.ToInt32(commissionRequest.Id)
select d;
if (TrnCommissionRequestData.Any())
{
var currentUser = from d in db.MstUsers
where d.AspNetId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var UnLockCommissionRequesData = TrnCommissionRequestData.FirstOrDefault();
UnLockCommissionRequesData.IsLocked = false;
UnLockCommissionRequesData.UpdatedBy = currentUser.FirstOrDefault().Id;
UnLockCommissionRequesData.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public Int32 PostTrnCommissionRequest(TrnCommissionRequest commissionRequest)
{
try
{
var currentUser = from d in db.MstUsers
where d.AspNetId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
string commissionRequestNumber = "0000000001";
var commissionRequests = from d in db.TrnCommissionRequests.OrderByDescending(d => d.Id) select d;
if (commissionRequests.Any())
{
Int32 nextCommissionRequestNumber = Convert.ToInt32(commissionRequests.FirstOrDefault().CommissionRequestNumber) + 1;
commissionRequestNumber = padNumWithZero(nextCommissionRequestNumber, 10);
}
Int32 soldUnitId = 0;
Int32 brokerId = 0;
var soldUnits = from d in db.TrnSoldUnits where d.IsLocked == true select d;
if (soldUnits.Any())
{
var soldUnit = soldUnits.FirstOrDefault();
soldUnitId = soldUnit.Id;
brokerId = soldUnit.BrokerId;
}
if (soldUnitId > 0 && brokerId > 0)
{
Data.TrnCommissionRequest newTrnCommissionRequest = new Data.TrnCommissionRequest()
{
CommissionRequestNumber = commissionRequestNumber,
CommissionRequestDate = Convert.ToDateTime(commissionRequest.CommissionRequestDate),
BrokerId = brokerId,
SoldUnitId = soldUnitId,
CommissionNumber = commissionRequest.CommissionNumber,
Amount = commissionRequest.Amount,
Remarks = commissionRequest.Remarks,
PreparedBy = currentUser.FirstOrDefault().Id,
CheckedBy = currentUser.FirstOrDefault().Id,
ApprovedBy = currentUser.FirstOrDefault().Id,
Status = commissionRequest.Status,
IsLocked = commissionRequest.IsLocked,
CreatedBy = currentUser.FirstOrDefault().Id,
CreatedDateTime = DateTime.Now,
UpdatedBy = currentUser.FirstOrDefault().Id,
UpdatedDateTime = DateTime.Now
};
db.TrnCommissionRequests.InsertOnSubmit(newTrnCommissionRequest);
db.SubmitChanges();
return(newTrnCommissionRequest.Id);
}
else
{
return(0);
}
}
else
{
return(0);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(0);
}
}