protected void Page_Load(object sender, EventArgs e) { using (var da = new stokKartTableAdapter()) { var requestType = Request.Params["requestType"].ToString(); if (requestType == "query") { var dt = da.GetData(); //var tWriter = new StringWriter(); var query = Request.Params["query"]; var max = Request.Params["max"]; var source = from row in dt where row.stokKod.StartsWith(query) || row.StokAdi.ToLower().Contains(query.ToLower()) select new { Kod = row.stokKod, HesapAdi = row.StokAdi, row.UstKod }; JSON = JsonConvert.SerializeObject(source); //TODO self reference loop oluştuğu için source kullanıldı, sil //jsSerializer.Serialize(tWriter, dt.Rows); //JSON = tWriter.GetStringBuilder().ToString(); } else if (requestType == "get") { var query = Request.Params["query"]; var dt = da.GetDataByStokKod(query); if (dt.Count == 1) { JSON = JsonConvert.SerializeObject(dt.Select(row => new { Kod = row.stokKod, HesapAdi = row.StokAdi, row.UstKod })); } else { JSON = "[]"; } } else if (requestType == "nextChild") { var dt = da.GetData(); var code = Request.Params["code"]; var nextChild = ""; var maxCodeVal = 0; var maxCode = ""; foreach (var row in dt.Where(r => r.UstKod == code)) { var childCode = row.stokKod.Split('.').Last(); var codeVal = Int32.Parse(childCode); if (maxCodeVal < codeVal) { maxCodeVal = codeVal; maxCode = childCode; } } var mask = ""; if (maxCodeVal > 0) { mask = new String('0', maxCode.Length); } else { if (code.Contains('.')) { mask = "000"; } else { mask = "00"; } } nextChild = code + "." + (maxCodeVal + 1).ToString(mask); JSON = nextChild; } } }
protected void Page_Load(object sender, EventArgs e) { stockPictures = new DataSet.StokKartResimDataTable(); if (IsPostBack) { stockCode = Request.Params["StockQueryCode"]; using (var daAccountPlan = new HesapPlaniTableAdapter()) using (var daStock = new stokKartTableAdapter()) using (var daStockPicture = new StokKartResimTableAdapter()) { stocks = daStock.GetData(); if (Request.Params["GetStock"] != null) { stock = stocks.FirstOrDefault(s => s.stokKod == stockCode); if (stock != null) { purchaseLibraName = daAccountPlan.GetDataByKod(stock.AlısMizanKodu)[0].HesapAdi; sellingLibraName = daAccountPlan.GetDataByKod(stock.SatısMizanKodu)[0].HesapAdi; stockPictures = daStockPicture.GetDataByStokKod(stockCode); } else { Master.ShowMessage(String.Format("{0} nolu stok kartı bulunmuyor.", stockCode), PageMaster.MsgType.Error); } } else if(Request.Params["SaveStock"] != null) { var stockName = Request.Params["StockName"]; var barcode = Request.Params["Barcode"]; var type = Request.Params["Type"]; var group = Request.Params["Group"]; var uniqueCode1 = Request.Params["UniqueCode1"]; var uniqueCode2 = Request.Params["UniqueCode2"]; var currency = Request.Params["Currency"]; var unit = Request.Params["Unit"]; var purchasePrice = Request.Params["PurchasePrice"].trimMoney().getMoney(); var salePrice = Request.Params["SalePrice"].trimMoney().getMoney(); var costPrice = Request.Params["CostPrice"].trimMoney().getMoney(); var minStock = Int32.Parse(Request.Params["MinStock"]); var maxStock = Int32.Parse(Request.Params["MaxStock"]); var taxRate = Int32.Parse(Request.Params["TaxRate"]); var user = Request.Params["User"]; var stockCheckDate = Request.Params["StockCheckDate"]; var stockCheckAmount = Request.Params["StockCheckAmount"]; var stockSaveDate = ""; var description = Request.Params["Description"]; var webCategory = Request.Params["WebCategory"]; var webOpen = Request.Params["WebOpen"] != null; var purchaseLibraCode = Request.Params["PurchaseLibraCode"]; var saleLibraCode = Request.Params["SaleLibraCode"]; var parentCode = stockCode.Substring(0, stockCode.LastIndexOf('.')); var webPriceOpen = Request.Params["WebPriceOpen"] != null; int? error = null; if (daStock.GetDataByStokKod(stockCode).Count > 0) { daStock.UpdateQuery(stockCode, 0, stockName, barcode, type, group, uniqueCode1, uniqueCode2, unit, purchasePrice, costPrice, 0, salePrice, maxStock, minStock, taxRate, user, null, null, null, description, webCategory, webOpen, purchaseLibraCode, saleLibraCode, parentCode, webPriceOpen, ref error); } else { daStock.InsertQuery(stockCode, stockName, barcode, type, group, uniqueCode1, uniqueCode2, unit, purchasePrice, costPrice, 0, salePrice, maxStock, minStock, taxRate, user, null, null, null, description, webCategory, webOpen, purchaseLibraCode, saleLibraCode, parentCode,webPriceOpen, ref error); } if (error == null) { Master.ShowMessage("Kaydetme işlemi tamamlandı.", PageMaster.MsgType.Info); stock = daStock.GetDataByStokKod(stockCode)[0]; stockPictures = daStockPicture.GetDataByStokKod(stockCode); purchaseLibraName = daAccountPlan.GetDataByKod(stock.AlısMizanKodu)[0].HesapAdi; sellingLibraName = daAccountPlan.GetDataByKod(stock.SatısMizanKodu)[0].HesapAdi; } else { Master.ShowMessage("Kaydetme işlemi sırasında hata oluştu: " + error,PageMaster.MsgType.Error); } } else if (Request.Params["DeleteStock"] != null) { var pictures = daStockPicture.GetDataByStokKod(stockCode); foreach (var picture in pictures) { var imgUrl = MapPath(ImgLocation + "/" + picture.ResimUrl); File.Delete(imgUrl); } daStockPicture.DeleteByStockCode(stockCode); daStock.DeleteQuery(stockCode); Master.ShowMessage("Silme işlemi tamamlandı.", PageMaster.MsgType.Info); stockCode = ""; } } } }