public TaxViewModel()
{
SelectedItem = new ItemModel();
SelectedTax = new TaxManagementModel();
SelectedItem1 = new BusinessLocationModel();
//var COMPANY_ID = Convert.ToInt32(App.Current.Properties["Company_Id"].ToString());
var COMPANY_ID = 1;
SelectedTax = new TaxManagementModel();
GetBussinessList(COMPANY_ID);
//Show_Taxes(COMPANY_ID);
GetTaxList(COMPANY_ID);
}
public DailySalesViewModel()
{
SelectedBusinessLoca = new BusinessLocationModel();
}
public async void GetItemByLocation(BusinessLocationModel SelectedBusinessLoca)
{
try
{
decimal Tot = 0;
HttpClient client = new HttpClient();
client.DefaultRequestHeaders.Accept.Add(
new MediaTypeWithQualityHeaderValue("application/json"));
client.BaseAddress = new Uri(GlobalData.gblApiAdress);
var response = await client.PostAsJsonAsync("api/POAPI/GetAllItemByLocation/", SelectedBusinessLoca);
if (response.IsSuccessStatusCode)
{
data = JsonConvert.DeserializeObject <ItemModel[]>(await response.Content.ReadAsStringAsync());
int x = 0;
for (int i = 0; i < data.Length; i++)
{
x++;
_ListGrid_Temp.Add(new ItemModel
{
SLNO = x,
ITEM_NAME = data[i].ITEM_NAME,
ITEM_ID = data[i].ITEM_ID,
BARCODE = data[i].BARCODE,
ACCESSORIES_KEYWORD = data[i].ACCESSORIES_KEYWORD,
CATAGORY_ID = data[i].CATAGORY_ID,
ITEM_DESCRIPTION = data[i].ITEM_DESCRIPTION,
ITEM_INVOICE_ID = data[i].ITEM_INVOICE_ID,
ITEM_PRICE = data[i].ITEM_PRICE,
ITEM_PRODUCT_ID = data[i].ITEM_PRODUCT_ID,
KEYWORD = data[i].KEYWORD,
MRP = data[i].MRP,
PURCHASE_UNIT = data[i].PURCHASE_UNIT,
PURCHASE_UNIT_PRICE = data[i].PURCHASE_UNIT_PRICE,
SALES_PRICE = data[i].SALES_PRICE,
SALES_UNIT = data[i].SALES_UNIT,
SEARCH_CODE = data[i].SEARCH_CODE,
TAX_COLLECTED = data[i].TAX_COLLECTED,
TAX_PAID = data[i].TAX_PAID,
ALLOW_PURCHASE_ON_ESHOP = data[i].ALLOW_PURCHASE_ON_ESHOP,
CATEGORY_NAME = data[i].CATEGORY_NAME,
DISPLAY_INDEX = data[i].DISPLAY_INDEX,
INCLUDE_TAX = data[i].INCLUDE_TAX,
ITEM_GROUP_NAME = data[i].ITEM_GROUP_NAME,
ITEM_UNIQUE_NAME = data[i].ITEM_UNIQUE_NAME,
OPN_QNT = data[i].OPN_QNT,
REGIONAL_LANGUAGE = data[i].REGIONAL_LANGUAGE,
SALES_PRICE_BEFOR_TAX = data[i].SALES_PRICE_BEFOR_TAX,
MODIFICATION_DATE = data[i].MODIFICATION_DATE,
WEIGHT_OF_CARDBOARD = data[i].WEIGHT_OF_CARDBOARD,
WEIGHT_OF_FOAM = data[i].WEIGHT_OF_FOAM,
WEIGHT_OF_PAPER = data[i].WEIGHT_OF_PAPER,
WEIGHT_OF_PLASTIC = data[i].WEIGHT_OF_PLASTIC,
});
Tot = Tot + data[i].MRP;
}
}
ListGrid = _ListGrid_Temp;
//TOTAL = Tot;
}
catch (Exception ex)
{
throw;
}
}
public HttpResponseMessage BussLocationUpdate(BusinessLocationModel _BusinessLocationModel)
{
try
{
bool conn = false;
conn = db.Database.Exists();
if (!conn)
{
ConnectionTools.changeToLocalDB(db);
conn = db.Database.Exists();
}
if (conn)
{
var loc = (from a in db.TBL_BUSINESS_LOCATION where a.BUSINESS_LOCATION_ID == _BusinessLocationModel.BUSINESS_LOCATION_ID select a).FirstOrDefault();
loc.BUSS_ADDRESS_1 = _BusinessLocationModel.BUSS_ADDRESS_1;
loc.BUSS_ADDRESS_2 = _BusinessLocationModel.BUSS_ADDRESS_2;
loc.CITY = _BusinessLocationModel.CITY;
loc.COMPANY = _BusinessLocationModel.COMPANY;
loc.COMPANY_ID = _BusinessLocationModel.COMPANY_ID;
loc.COUNTRY = _BusinessLocationModel.COUNTRY;
loc.DOCUMENT_NO = _BusinessLocationModel.DOCUMENT_NO;
loc.EMAIL = _BusinessLocationModel.EMAIL;
loc.EMAIL_SETTING = _BusinessLocationModel.EMAIL_SETTING;
loc.EMAIL_TEMPLATE_SETTING = _BusinessLocationModel.EMAIL_TEMPLATE_SETTING;
loc.GODOWN_TO_KEEP = _BusinessLocationModel.GODOWN_TO_KEEP;
loc.IMAGE = _BusinessLocationModel.IMAGE;
loc.IS_ASK_TO_PRIENT_EVERYTIME = _BusinessLocationModel.IS_ASK_TO_PRIENT_EVERYTIME;
loc.IS_DELETE_INVOICE_SPECIFIED_GODOWN = _BusinessLocationModel.IS_DELETE_INVOICE_SPECIFIED_GODOWN;
loc.IS_ENABLE_EMAIL = _BusinessLocationModel.IS_ENABLE_EMAIL;
loc.IS_SCEOND_RECEIPT_PRINTER = _BusinessLocationModel.IS_SCEOND_RECEIPT_PRINTER;
loc.IS_SECOND_DIFF_PRINT = _BusinessLocationModel.IS_SECOND_DIFF_PRINT;
loc.MOBILE_NO = _BusinessLocationModel.MOBILE_NO;
loc.NUMBER_OF_SECOND_RECEIPT_PRINT = _BusinessLocationModel.NUMBER_OF_SECOND_RECEIPT_PRINT;
loc.PHONE_NO = _BusinessLocationModel.PHONE_NO;
loc.PIN = _BusinessLocationModel.PIN;
loc.PREFIX_DOCUMENT = _BusinessLocationModel.PREFIX_DOCUMENT;
loc.PRINTER_SETTING = _BusinessLocationModel.PRINTER_SETTING;
loc.SCEOND_RECEIPT_PRINT_FORMATE = _BusinessLocationModel.SCEOND_RECEIPT_PRINT_FORMATE;
loc.SCEOND_RECEIPT_PRINTER = _BusinessLocationModel.SCEOND_RECEIPT_PRINTER;
loc.SHOP_NAME = _BusinessLocationModel.SHOP_NAME;
loc.SMS_SETTING = _BusinessLocationModel.SMS_SETTING;
loc.STATE = _BusinessLocationModel.STATE;
loc.TIN_NUMBER = _BusinessLocationModel.TIN_NUMBER;
loc.WEBSITE = _BusinessLocationModel.WEBSITE;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "success"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed));
}
}
catch (Exception ex)
{
throw;
}
finally
{
ConnectionTools.ChangeToRemoteDB(db);
}
}
public HttpResponseMessage GetAllItemByLocation(BusinessLocationModel SelectedBusinessLoca)
{
try
{
bool conn = false;
conn = db.Database.Exists();
if (!conn)
{
ConnectionTools.changeToLocalDB(db);
conn = db.Database.Exists();
}
if (conn)
{
DateTime ToDate = Convert.ToDateTime(SelectedBusinessLoca.ToDt);
DateTime FromDate = Convert.ToDateTime(SelectedBusinessLoca.FromDt);
var str = (from b in db.TBL_PO
join a in db.TBL_ITEMS on b.ITEM_ID equals a.ITEM_ID
join c in db.TBL_ITEMS_ATTRIBUTE on a.ITEM_ID equals c.ITEM_ID
where b.COMPANY_ID == SelectedBusinessLoca.COMPANY_ID && b.BUSSINESS_ID == 1 &&
(b.PO_DATE >= FromDate && b.PO_DATE <= ToDate)
select new ItemModel
{
ITEM_ID = a.ITEM_ID,
ITEM_NAME = a.ITEM_NAME,
ITEM_DESCRIPTION = a.ITEM_DESCRIPTION,
ITEM_PRICE = a.ITEM_PRICE,
ITEM_INVOICE_ID = a.ITEM_INVOICE_ID,
ITEM_PRODUCT_ID = a.ITEM_PRODUCT_ID,
KEYWORD = a.KEYWORD,
ACCESSORIES_KEYWORD = a.ACCESSORIES_KEYWORD,
BARCODE = a.BARCODE,
CATAGORY_ID = a.CATAGORY_ID,
SEARCH_CODE = a.SERCH_CODE,
TAX_PAID = a.TAX_PAID,
TAX_COLLECTED = a.TAX_COLLECTED,
PURCHASE_UNIT = a.PURCHASE_UNIT,
SALES_UNIT = a.SALES_UNIT,
PURCHASE_UNIT_PRICE = a.PURCHASE_UNIT_PRICE,
SALES_PRICE = a.SALES_PRICE,
MRP = a.MRP,
COMPANY_ID = a.COMPANY_ID,
CATEGORY_NAME = a.CATEGORY_NAME,
OPN_QNT = a.OPN_QNT,
DISPLAY_INDEX = a.DISPLAY_INDEX,
ITEM_GROUP_NAME = a.ITEM_GROUP_NAME,
ITEM_UNIQUE_NAME = a.ITEM_UNIQUE_NAME,
REGIONAL_LANGUAGE = a.REGIONAL_LANGUAGE,
SALES_PRICE_BEFOR_TAX = a.SALES_PRICE_BEFOR_TAX,
IS_DELETE = a.IS_DELETE,
INCLUDE_TAX = c.INCLUDE_TAX,
IS_Shortable_Item = c.IS_SORTABLE_ITEM,
IS_Purchased = c.IS_PURCHASED,
IS_Service_Item = c.IS_SERVICE,
IS_For_Online_Shop = c.ONLY_ONLINE_SHOP,
IS_Not_for_online_shop = c.NOT_FOR_ONLINE_SHOP,
IS_Not_For_Sell = c.NOT_FOR_SALE,
ALLOW_PURCHASE_ON_ESHOP = c.ALLOW_PURCHASE_ON_ESHOP,
IS_ACTIVE = c.IS_ACTIVE,
IS_Gift_Card = c.IS_GIFT_CARD,
MODIFICATION_DATE = a.MODIFICATION_DATE,
WEIGHT_OF_CARDBOARD = a.WEIGHT_OF_CARDBOARD,
WEIGHT_OF_FOAM = a.WEIGHT_OF_FOAM,
WEIGHT_OF_PLASTIC = a.WEIGHT_OF_PLASTIC,
WEIGHT_OF_PAPER = a.WEIGHT_OF_PAPER,
}).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, str));
}
else
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed));
}
}
catch (Exception ex)
{
throw;
}
finally
{
ConnectionTools.ChangeToRemoteDB(db);
}
}
