// GET api/users
public HttpResponseMessage Get(int Id)
{
HttpResponseMessage message = new HttpResponseMessage();
ApiError apiError = null;
APIResponse apiResponse = null;
NSRetail_CloudEntities entities = new NSRetail_CloudEntities();
try
{
var userslist = (from users in entities.TBLUSERs
join branch in entities.BRANCHes on users.BRANCHID equals branch.BRANCHID
where users.USERID == Id && users.DELETEDDATE == null && branch.DELETEDDATE == null
select new { users.USERID, users.USERNAME, users.FULLNAME, users.EMAIL, users.GENDER, branch.BRANCHID, branch.BRANCHNAME, branch.ISWAREHOUSE }).ToList();
if (userslist.Count > 0)
{
apiResponse = new APIResponse(userslist, null);
message = Request.CreateResponse(HttpStatusCode.OK, apiResponse);
}
else
{
apiError = new ApiError("User Not Found", "201");
apiResponse = new APIResponse(null, apiError);
message = Request.CreateResponse(HttpStatusCode.OK, apiResponse);
}
}
catch (Exception ex)
{
apiError = new ApiError("Exception: " + ex.Message, "500");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.OK, apiResponse));
}
return(message);
}
public HttpResponseMessage Get()
{
HttpResponseMessage message = new HttpResponseMessage();
ApiError apiError = null;
APIResponse apiResponse = null;
NSRetail_CloudEntities entities = new NSRetail_CloudEntities();
try
{
var brancheslist = (from branches in entities.BRANCHes
where branches.DELETEDDATE == null
select new
{
branches.BRANCHID,
branches.BRANCHNAME,
branches.BRANCHCODE
}
).ToList();
if (brancheslist.Count > 0)
{
apiResponse = new APIResponse(brancheslist, null);
message = Request.CreateResponse(HttpStatusCode.OK, apiResponse);
}
}
catch (Exception ex)
{
apiError = new ApiError("Exception: " + ex.Message, "500");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.OK, apiResponse));
}
return(message);
}
public HttpResponseMessage getItemName(string itemCode)
{
HttpResponseMessage message = new HttpResponseMessage();
ApiError apiError = null;
APIResponse apiResponse = null;
NSRetail_CloudEntities entities = new NSRetail_CloudEntities();
try
{
//var itemList = (from code in entities.ITEMCODEs
// join item in entities.ITEMs on code.ITEMID equals item.ITEMID
// where code.ITEMCODE1 == itemCode && code.DELETEDDATE == null && item.DELETEDDATE == null
// select new
// {
// code.ITEMCODEID,
// code.ITEMCODE1,
// item.ITEMID,
// item.ITEMNAME
// }).ToList();
var itemList = (from price in entities.ITEMPRICEs
join code in entities.ITEMCODEs on price.ITEMCODEID equals code.ITEMCODEID
join item in entities.ITEMs on code.ITEMID equals item.ITEMID
where code.ITEMCODE1 == itemCode && code.DELETEDDATE == null && item.DELETEDDATE == null && price.DELETEDDATE == null
select new
{
code.ITEMCODEID,
code.ITEMCODE1,
item.ITEMID,
item.ITEMNAME,
price.ITEMPRICEID,
price.MRP,
price.SALEPRICE
}).ToList();
if (itemList.Count > 0)
{
apiResponse = new APIResponse(itemList, null);
message = Request.CreateResponse(HttpStatusCode.OK, apiResponse);
}
else
{
apiError = new ApiError("No Sub Category / Product(s) found", "201");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.OK, apiResponse));
}
}
catch (Exception ex)
{
apiError = new ApiError("Exception: " + ex.Message, "500");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.OK, apiResponse));
}
return(message);
}
public HttpResponseMessage DeleteStockCounting([FromUri] int nStockCounting)
{
HttpResponseMessage message = new HttpResponseMessage();
ApiError apiError = null;
APIResponse apiResponse = null;
using (NSRetail_CloudEntities entities = new NSRetail_CloudEntities())
{
try
{
if (nStockCounting != null || nStockCounting != 0)
{
try
{
{
Nullable <int> output = entities.CLOUD_USP_D_STOCKCOUNTINGDETAIL(nStockCounting);
if (output == 1)
{
apiResponse = new APIResponse(null);
message = Request.CreateResponse(HttpStatusCode.OK, apiResponse);
return(message);
}
else
{
apiError = new ApiError("Record is not deleted", "202");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.BadRequest, apiResponse));
}
}
}
catch (Exception ex)
{
}
}
else
{
apiError = new ApiError("Some parameters missing", "202");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.BadRequest, apiResponse));
}
}
catch (Exception ex)
{
apiError = new ApiError("Exception: " + ex.Message, "500");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.OK, apiResponse));
}
}
return(message);
}
public List <TBLUSER> Login(string email, string password)
{
//HttpResponseMessage message = new HttpResponseMessage();
using (NSRetail_CloudEntities entities = new NSRetail_CloudEntities())
{
string encryptpassword = AesBase64Wrapper.Encrypt(password);
//entities.Configuration.ProxyCreationEnabled = false;
var query = (from users in entities.TBLUSERs
//join roles in entities.Roles on users.RoleID equals roles.RoleID
//from prod2 in prodGroup
where users.USERNAME == email && users.PASSWORDSTRING == encryptpassword && users.DELETEDDATE == null
select users).ToList();
return(query);
}
}
public HttpResponseMessage getBranchDetails(string userID)
{
HttpResponseMessage message = new HttpResponseMessage();
ApiError apiError = null;
APIResponse apiResponse = null;
NSRetail_CloudEntities entities = new NSRetail_CloudEntities();
try
{
string branchID = (from user in entities.TBLUSERs
where user.USERID == Convert.ToInt32(userID)
select new
{
user.BRANCHID
}).ToString();
int nBranchID = Convert.ToInt32(branchID);
var branchname = (from branch in entities.BRANCHes
where branch.BRANCHID == nBranchID && branch.DELETEDDATE == null
select new
{
branch.BRANCHNAME
}).ToList();
if (branchname.Count > 0)
{
apiResponse = new APIResponse(branchname, null);
message = Request.CreateResponse(HttpStatusCode.OK, apiResponse);
}
else
{
apiError = new ApiError("No Sub Category / Product(s) found", "201");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.OK, apiResponse));
}
}
catch (Exception ex)
{
apiError = new ApiError("Exception: " + ex.Message, "500");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.OK, apiResponse));
}
return(message);
}
public HttpResponseMessage getPriceDetails(int itemCodeid)
{
HttpResponseMessage message = new HttpResponseMessage();
ApiError apiError = null;
APIResponse apiResponse = null;
NSRetail_CloudEntities entities = new NSRetail_CloudEntities();
try
{
var itemList = (from price in entities.ITEMPRICEs
join code in entities.ITEMCODEs on price.ITEMCODEID equals code.ITEMCODEID
where price.ITEMCODEID == itemCodeid && price.DELETEDDATE == null && code.DELETEDDATE == null
select new
{
price.ITEMCODEID,
price.ITEMPRICEID,
price.MRP,
price.SALEPRICE
}).ToList();
if (itemList.Count > 0)
{
apiResponse = new APIResponse(itemList, null);
message = Request.CreateResponse(HttpStatusCode.OK, apiResponse);
}
else
{
apiError = new ApiError("No Sub Category / Product(s) found", "201");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.OK, apiResponse));
}
}
catch (Exception ex)
{
apiError = new ApiError("Exception: " + ex.Message, "500");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.OK, apiResponse));
}
return(message);
}
public HttpResponseMessage Get(int stockCountDetailId, int userId, int branchId)
{
HttpResponseMessage message = new HttpResponseMessage();
ApiError apiError = null;
APIResponse apiResponse = null;
try
{
using (NSRetail_CloudEntities entities = new NSRetail_CloudEntities())
{
if (stockCountDetailId > 0)
{
var stockList = (from stockdetail in entities.CLOUD_STOCKCOUNTINGDETAIL
join stockcount in entities.CLOUD_STOCKCOUNTING on stockdetail.STOCKCOUNTINGID equals stockcount.STOCKCOUNTINGID
join price in entities.ITEMPRICEs on stockdetail.ITEMPRICEID equals price.ITEMPRICEID
join code in entities.ITEMCODEs on price.ITEMCODEID equals code.ITEMCODEID
join item in entities.ITEMs on code.ITEMID equals item.ITEMID
where stockdetail.DELETEDDATE == null && price.DELETEDDATE == null && code.DELETEDDATE == null && item.DELETEDDATE == null &&
stockdetail.STOCKCOUNTINGDETAILID == stockCountDetailId && stockcount.BRANCHID == branchId && stockcount.CREATEDBY == userId &&
stockcount.STATUS != true
select new
{
stockdetail.STOCKCOUNTINGDETAILID,
stockdetail.ITEMPRICEID,
stockdetail.QUANTITY,
stockdetail.STOCKCOUNTINGID,
price.MRP,
price.SALEPRICE,
code.ITEMCODE1,
item.ITEMNAME
}).ToList();
if (stockList.Count > 0)
{
apiResponse = new APIResponse(stockList, null);
message = Request.CreateResponse(HttpStatusCode.OK, apiResponse);
}
else
{
apiError = new ApiError("stock counting details are not found", "201");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.OK, apiResponse));
}
}
else
{
var stockList = (from stockdetail in entities.CLOUD_STOCKCOUNTINGDETAIL
join stockcount in entities.CLOUD_STOCKCOUNTING on stockdetail.STOCKCOUNTINGID equals stockcount.STOCKCOUNTINGID
join price in entities.ITEMPRICEs on stockdetail.ITEMPRICEID equals price.ITEMPRICEID
join code in entities.ITEMCODEs on price.ITEMCODEID equals code.ITEMCODEID
join item in entities.ITEMs on code.ITEMID equals item.ITEMID
where stockdetail.DELETEDDATE == null && price.DELETEDDATE == null && code.DELETEDDATE == null && item.DELETEDDATE == null &&
stockcount.BRANCHID == branchId && stockcount.CREATEDBY == userId && stockcount.STATUS != true
select new
{
stockdetail.STOCKCOUNTINGDETAILID,
stockdetail.ITEMPRICEID,
stockdetail.QUANTITY,
stockdetail.STOCKCOUNTINGID,
price.MRP,
price.SALEPRICE,
code.ITEMCODE1,
item.ITEMNAME
}).ToList();
if (stockList.Count > 0)
{
apiResponse = new APIResponse(stockList, null);
message = Request.CreateResponse(HttpStatusCode.OK, apiResponse);
}
else
{
apiError = new ApiError("stock counting details are not found", "201");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.OK, apiResponse));
}
}
}
}
catch (Exception ex)
{
}
return(message);
}
public HttpResponseMessage InsertStockCounting([FromUri] int stockCountingID, [FromUri] int stockCountDetailId, [FromUri] int branchId, [FromUri] int userId,
[FromUri] int itemPriceId, [FromUri] int quantity)
{
HttpResponseMessage message = new HttpResponseMessage();
ApiError apiError = null;
APIResponse apiResponse = null;
Nullable <int> nStockCountOutput = 0, nStockCountDetailOutput = 0;
DateTime dtCreatedDate = DateTime.Now;
using (NSRetail_CloudEntities entities = new NSRetail_CloudEntities())
{
try
{
if (branchId != 0 && userId != 0 && itemPriceId != 0 && quantity != 0)
{
try
{
//string paramValue = Newtonsoft.Json.JsonConvert.SerializeObject(entity);
//DataTable dt = (DataTable)JsonConvert.DeserializeObject(paramValue, (typeof(DataTable)));
if (stockCountingID == 0)
{
nStockCountOutput = entities.CLOUD_USP_CU_STOCKCOUNTING(stockCountingID, branchId, userId, dtCreatedDate).FirstOrDefault();
if (nStockCountOutput != 0)
{
nStockCountDetailOutput = entities.CLOUD_USP_CU_STOCKCOUNTINGDETAIL(stockCountDetailId, nStockCountOutput, itemPriceId, quantity, dtCreatedDate).FirstOrDefault();
}
}
else
{
nStockCountDetailOutput = entities.CLOUD_USP_CU_STOCKCOUNTINGDETAIL(stockCountDetailId, stockCountingID, itemPriceId, quantity, dtCreatedDate).FirstOrDefault();
}
if (nStockCountDetailOutput != 0)
{
apiResponse = new APIResponse(null);
message = Request.CreateResponse(HttpStatusCode.OK, apiResponse);
}
else
{
apiError = new ApiError("Some parameters are missing", "202");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.NoContent, apiResponse));
}
return(message);
}
catch (Exception ex)
{
}
}
else
{
apiError = new ApiError("Some parameters are missing", "202");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.BadRequest, apiResponse));
}
}
catch (Exception ex)
{
apiError = new ApiError("Exception: " + ex.Message, "500");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.OK, apiResponse));
}
}
return(message);
}
public HttpResponseMessage UpdateStatus([FromUri] int nStockCounting)
{
HttpResponseMessage message = new HttpResponseMessage();
ApiError apiError = null;
APIResponse apiResponse = null;
using (NSRetail_CloudEntities entities = new NSRetail_CloudEntities())
{
try
{
if (nStockCounting != null || nStockCounting != 0)
{
try
{
// FIRST create a blank object
CLOUD_STOCKCOUNTING sc = entities.CLOUD_STOCKCOUNTING.Create();
// SECOND set the ID
sc.STOCKCOUNTINGID = nStockCounting;
// THIRD attach the thing (id is not marked as modified)
entities.CLOUD_STOCKCOUNTING.Attach(sc);
// FOURTH set the fields you want updated.
sc.STATUS = true;
// FIFTH save that thing
Nullable <int> output = entities.SaveChanges();
if (output == 1)
{
apiResponse = new APIResponse(null);
message = Request.CreateResponse(HttpStatusCode.OK, apiResponse);
return(message);
}
else
{
apiError = new ApiError("Record is not deleted", "202");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.BadRequest, apiResponse));
}
}
catch (Exception ex)
{
}
}
else
{
apiError = new ApiError("Some parameters missing", "202");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.BadRequest, apiResponse));
}
}
catch (Exception ex)
{
apiError = new ApiError("Exception: " + ex.Message, "500");
apiResponse = new APIResponse(null, apiError);
return(Request.CreateResponse(HttpStatusCode.OK, apiResponse));
}
}
return(message);
}
