protected void btnBuyerUpdate_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(lstBuyers.SelectedValue))
{
string strName = txtBuyerName.Text;
int buyerId = int.Parse(lstBuyers.SelectedValue);
var db = new ssmDataContext();
buyer buyer = db.buyers.First(b => b.id == buyerId);
buyer.name = txtBuyerName.Text;
buyer.canBuyOnTick = chkBuyerCanBuyOnTick.Checked;
float pct = 0;
buyer.pct = float.TryParse(txtBuyerPct.Text, out pct) ? pct : 0;
buyer.isActive = chkBuyerIsActive.Checked;
db.SubmitChanges();
buyer.Refresh();
lstBuyersFill();
if (lstBuyers.Items.FindByText(strName) != null)
{
lstBuyers.SelectedIndex = lstBuyers.Items.IndexOf(lstBuyers.Items.FindByText(strName));
lstBuyers_SelectedIndexChanged(new object(), new EventArgs());
}
}
}
protected void lstItems_SelectedIndexChanged(object sender, EventArgs e)
{
if (lstItems.SelectedItem != null)
{
int itemId = int.Parse(lstItems.SelectedValue);
var db = new ssmDataContext();
item item = db.items.Where(i => i.id == itemId).FirstOrDefault();
if (item != null)
{
txtItemName.Text = item.name;
txtItemMeasure.Text = item.measure;
txtItemCount.Text = item.count != null?item.count.Value.ToString() : "0";
txtItemAdminPrice.Text = item.adminPrice != null?item.adminPrice.Value.ToString() : "1";
txtItemPct.Text = item.pct != null?item.pct.Value.ToString() : "1";
txtItemOrderCount.Text = item.countToOrder != null?item.countToOrder.Value.ToString() : "0";
chbItemCanGiveBack.Checked = item.canGiveBack != null ? item.canGiveBack.Value : false;
chbItemIsActive.Checked = item.isActive != null ? item.isActive.Value : false;
}
}
}
private ReportDataSource CreateSource(int sID)
{
var db = new ssmDataContext();
IEnumerable <SalesDataSource> list = db.logSales.ToList()
.Join(buyer.Cache, l => l.buyerId, b => b.id, (l, b) => new { logSales = l, Buyer = b })
.Join(seller.Cache, l => l.logSales.sellerId, s => s.id, (l, s) => new { logSalesB = l, Seller = s })
.Where(
s =>
(s.logSalesB.logSales.sid.Value == sID && s.logSalesB.logSales.isGiveBack == false)
)
.Select(s => new SalesDataSource
{
Buyer = s.logSalesB.Buyer.name,
Cash = s.logSalesB.logSales.cash.GetValueOrDefault(),
Date = s.logSalesB.logSales.date.GetValueOrDefault(),
IsGiveBack = s.logSalesB.logSales.isGiveBack.GetValueOrDefault(),
Item = s.logSalesB.logSales.logName,
ItemsCount = s.logSalesB.logSales.itemsCount.GetValueOrDefault(0),
Seller = s.Seller.fullName,
SID = s.logSalesB.logSales.sid.GetValueOrDefault()
}).ToList();
return(new ReportDataSource("SalesDataSource", list));
}
private void LoadingTree()
{
ssmDataContext cont = new ssmDataContext();
IList <group> rootCategories = cont.groups.Where(b => b.parent == null).OrderBy(b => b.name).ToList();
IList <group> rootchild = cont.groups.Where(b => b.parent != null).OrderBy(b => b.name).ToList();
foreach (group categ in rootCategories)
{
TreeNode tree;
if (categ.parent == null)
{
tree = new TreeNode(categ.name, categ.id.ToString());
IList <group> cildNode = rootchild.Where(b => b.parent == categ.id).ToList();
if (cildNode.Count > 0)
{
foreach (group child in cildNode)
{
tree.ChildNodes.Add(new TreeNode(child.name, child.id.ToString()));
}
tree.Expanded = false;
}
treeCategories.Nodes.Add(tree);
}
}
}
protected void btnItemUpdate_Click(object sender, EventArgs e)
{
if (lstItems.SelectedItem != null)
{
int itemId = int.Parse(lstItems.SelectedValue);
var db = new ssmDataContext();
item item = db.items.Where(i => i.id == itemId).FirstOrDefault();
item.name = txtItemName.Text;
item.measure = txtItemMeasure.Text;
var count = int.Parse(txtItemCount.Text);
if (item.count != count)
{
item.order = false;
}
item.count = count;
item.adminPrice = (double?)decimal.Parse(txtItemAdminPrice.Text);
item.pct = double.Parse(txtItemPct.Text);
item.countToOrder = int.Parse(txtItemOrderCount.Text);
item.canGiveBack = chbItemCanGiveBack.Checked;
item.isActive = chbItemIsActive.Checked;
db.SubmitChanges();
int id;
if (int.TryParse(treeCategories.SelectedNode.Value, out id))
{
lstItems.DataSource = item.GetAllByGroupId(id);
lstItems.DataTextField = "name";
lstItems.DataValueField = "id";
lstItems.DataBind();
lblGroupName.Text = new ssmDataContext().groups.First(g => g.id == id).name;
}
}
}
private void lstGroupFill()
{
var db = new ssmDataContext();
int groupId = 0;
if (lstGroup.SelectedIndex > -1)
{
groupId = int.Parse(lstGroup.SelectedItem.Value);
}
groups = db.groups.ToList();
lstGroup.DataSource = groups.OrderBy(g => g.name).Where(g => g.parent == null).ToList();
lstGroup.DataTextField = "name";
lstGroup.DataValueField = "id";
lstGroup.DataBind();
txtGroupName.Text = "";
ddlAttachTo.DataSource = groups.OrderBy(g => g.name).Where(g => g.parent == null).ToList();
ddlAttachTo.DataTextField = "name";
ddlAttachTo.DataValueField = "id";
ddlAttachTo.DataBind();
ddlItemToGroup.DataSource = groups.OrderBy(g => g.name).ToList();
ddlItemToGroup.DataTextField = "name";
ddlItemToGroup.DataValueField = "id";
ddlItemToGroup.DataBind();
ListItem listItem = lstGroup.Items.FindByValue(groupId.ToString());
if (listItem != null)
{
listItem.Selected = true;
//lstGroup_SelectedIndexChanged(new object(), new EventArgs());
}
}
protected void lstSubGroup_SelectedIndexChanged(object sender, EventArgs e)
{
int groupId = int.Parse(lstSubGroup.SelectedItem.Value);
var db = new ssmDataContext();
var group = db.groups.First(g => g.id == groupId);
txtSubGroupName.Text = group.name;
lblSubGroup.Text = "Наименований товаров: " + group.GetItemsCountByGroupId(group.id);
}
private ReportDataSource CreateSource()
{
int sellerId = int.Parse(lstSellers.SelectedValue);
int buyerId = int.Parse(drpBuyers.SelectedValue);
bool isGiveBack = chkIsGiveBack.Checked;
bool dateOk = false;
var db = new ssmDataContext();
var fromDate = DateTime.Now.AddDays(-1);
var toDate = DateTime.Now;
if (!string.IsNullOrEmpty(txtDateFrom.Text.Trim()))
{
if (!DateTime.TryParse(txtDateFrom.Text, out fromDate))
{
fromDate = DateTime.Now.AddDays(-1);
}
}
if (!string.IsNullOrEmpty(txtDateTo.Text.Trim()))
{
if (!DateTime.TryParse(txtDateTo.Text, out toDate))
{
toDate = DateTime.Now;
}
}
lblMessage.Text = "Выполнено за даты с " + fromDate.ToString("yyyy-MM-dd") + " по " + toDate.ToString("yyyy-MM-dd");
IEnumerable <SalesDataSource> list = db.logSales.ToList()
.Join(buyer.Cache, l => l.buyerId, b => b.id, (l, b) => new { logSales = l, Buyer = b })
.Join(seller.Cache, l => l.logSales.sellerId, s => s.id, (l, s) => new { logSalesB = l, Seller = s })
.Where(
s =>
(sellerId == 0 || s.logSalesB.logSales.sellerId == sellerId)
&&
(buyerId == 0 || s.logSalesB.logSales.buyerId == buyerId)
&&
(s.logSalesB.logSales.isGiveBack == isGiveBack)
&&
(s.logSalesB.logSales.date.GetValueOrDefault() <= toDate && s.logSalesB.logSales.date.GetValueOrDefault() >= fromDate)
)
.Select(s => new SalesDataSource
{
Buyer = s.logSalesB.Buyer.name,
Cash = s.logSalesB.logSales.cash.GetValueOrDefault(),
Date = s.logSalesB.logSales.date.GetValueOrDefault(),
IsGiveBack = s.logSalesB.logSales.isGiveBack.GetValueOrDefault(),
Item = s.logSalesB.logSales.logName,
ItemsCount = s.logSalesB.logSales.itemsCount.GetValueOrDefault(0),
Seller = s.Seller.fullName,
SID = s.logSalesB.logSales.sid.GetValueOrDefault()
}).ToList();
return(new ReportDataSource("SalesDataSource", list));
}
protected void Page_Load(object sender, EventArgs e)
{
var db = new ssmDataContext();
// TODO move groups to Session
groups = db.groups.ToList();
if (!Page.IsPostBack)
{
lstGroupFill();
}
}
protected void lstBuyers_SelectedIndexChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(lstBuyers.SelectedValue))
{
int buyerId = int.Parse(lstBuyers.SelectedValue);
var db = new ssmDataContext();
buyer buyerThis = buyer.Cache.First(b => b.id == buyerId);
txtBuyerName.Text = buyerThis.name;
chkBuyerCanBuyOnTick.Checked = buyerThis.canBuyOnTick.HasValue && buyerThis.canBuyOnTick.Value;
chkBuyerIsActive.Checked = buyerThis.isActive.HasValue && buyerThis.isActive.Value;
txtBuyerPct.Text = buyerThis.pct.HasValue ? buyerThis.pct.Value.ToString() : "0";
}
}
private void lstsellersFill()
{
var db = new ssmDataContext();
var list = db.sellers.OrderBy(g => g.fullName).ToList();
list.Insert(0, new seller {
fullName = "Все"
});
lstSellers.DataSource = list;
lstSellers.DataTextField = "fullName";
lstSellers.DataValueField = "id";
lstSellers.DataBind();
}
protected void lstGroup_SelectedIndexChanged(object sender, EventArgs e)
{
int parentId = int.Parse(lstGroup.SelectedItem.Value);
lstSubGroup.DataSource = groups.Where(g => g.parent != null && g.parent.Value == parentId).ToList();
lstSubGroup.DataTextField = "name";
lstSubGroup.DataValueField = "id";
lstSubGroup.DataBind();
txtGroupName.Text = lstGroup.SelectedItem.Text;
txtSubGroupName.Text = "";
var group = new ssmDataContext().groups.First(g => g.id == parentId);
lblPGroup.Text = "Наименований товаров: " + group.GetItemsCountByGroupId(group.id);
}
protected void btnDelGroup_Click(object sender, EventArgs e)
{
if (lstGroup.SelectedItem != null)
{
var db = new ssmDataContext();
int groupId = int.Parse(lstGroup.SelectedItem.Value);
List <group> groupToDelete =
db.groups.Where(g => g.id == groupId).ToList();
if (groupToDelete.Count == 1 && group.GetItemsCountByGroupId(groupToDelete[0].id) == 0)
{
db.groups.DeleteOnSubmit(groupToDelete.First());
db.SubmitChanges();
lstGroupFill();
}
}
}
protected void btnAttachTo_Click(object sender, EventArgs e)
{
if (lstGroup.SelectedItem != null && ddlAttachTo.SelectedItem != null)
{
var db = new ssmDataContext();
int groupToAttachId = int.Parse(ddlAttachTo.SelectedItem.Value);
List <group> groupsToAttach = db.groups.Where(g => g.id == groupToAttachId).ToList();
int groupForAttachId = int.Parse(lstGroup.SelectedItem.Value);
List <group> groupsForAttach = db.groups.Where(g => g.id == groupForAttachId).ToList();
if (groupsToAttach.Count == 1 && groupsForAttach.Count == 1 && groupToAttachId != groupForAttachId)
{
groupsForAttach.First().parent = groupsToAttach.First().id;
db.SubmitChanges();
lstGroupFill();
}
}
}
protected void btnItemMove_Click(object sender, EventArgs e)
{
if (lstItems.SelectedItem != null && ddlItemToGroup.SelectedItem != null)
{
int itemId = int.Parse(lstItems.SelectedValue);
var db = new ssmDataContext();
item item = db.items.Where(i => i.id == itemId).FirstOrDefault();
int groupToAttachId = int.Parse(ddlItemToGroup.SelectedItem.Value);
List <group> groupsToAttach = db.groups.Where(g => g.id == groupToAttachId).ToList();
if (groupsToAttach.Count == 1)
{
item.groupId = groupsToAttach.First().id;
db.SubmitChanges();
treeCategories_SelectedNodeChanged(new object(), new EventArgs());
}
}
}
protected void btnSellerAdd_Click(object sender, EventArgs e)
{
string sellerName = "Продавец";
var db = new ssmDataContext();
seller seller = new seller {
isActive = false, fullName = sellerName, isAdmin = false, password = "******", login = "******"
};
db.sellers.InsertOnSubmit(seller);
db.SubmitChanges();
seller.Refresh();
lstsellersFill();
if (lstSellers.Items.FindByText(sellerName) != null)
{
lstSellers.SelectedIndex = lstSellers.Items.IndexOf(lstSellers.Items.FindByText(sellerName));
lstSeller_SelectedIndexChanged(new object(), new EventArgs());
}
}
protected void btnUpdateSubGroup_Click(object sender, EventArgs e)
{
if (lstSubGroup.SelectedItem != null && !string.IsNullOrEmpty(lstSubGroup.SelectedItem.Value))
{
var db = new ssmDataContext();
int groupId = int.Parse(lstSubGroup.SelectedItem.Value);
List <group> groupToUpdate = db.groups.Where(g => g.id == groupId).ToList();
if (groupToUpdate.Count == 1)
{
groupToUpdate.First().name = txtSubGroupName.Text;
db.SubmitChanges();
lstGroupFill();
}
txtGroupName.Text = lstGroup.SelectedItem.Text;
LoadLstSubGroup();
lstSubGroup.Items.FindByText(txtSubGroupName.Text).Selected = true;
}
}
protected void btnBuyerAdd_Click(object sender, EventArgs e)
{
string strName = "новый покупатель";
var db = new ssmDataContext();
buyer buyer = new buyer {
isActive = false, name = strName, canBuyOnTick = false, pct = 0
};
db.buyers.InsertOnSubmit(buyer);
db.SubmitChanges();
buyer.Refresh();
lstBuyersFill();
if (lstBuyers.Items.FindByText(strName) != null)
{
lstBuyers.SelectedIndex = lstBuyers.Items.IndexOf(lstBuyers.Items.FindByText(strName));
lstBuyers_SelectedIndexChanged(new object(), new EventArgs());
}
}
protected void btnItemAdd_Click(object sender, EventArgs e)
{
if (treeCategories.SelectedNode != null)
{
int groupId = int.Parse(treeCategories.SelectedNode.Value);
var db = new ssmDataContext();
string newItem = "новый товар";
var item = new item {
name = newItem, groupId = groupId
};
db.items.InsertOnSubmit(item);
db.SubmitChanges();
treeCategories_SelectedNodeChanged(new object(), new EventArgs());
if (lstItems.Items.FindByText(newItem) != null)
{
lstItems.SelectedIndex = lstItems.Items.IndexOf(lstItems.Items.FindByText(newItem));
}
lstItems_SelectedIndexChanged(new object(), new EventArgs());
}
}
protected void btnAddGroup_Click(object sender, EventArgs e)
{
string groupName = "НОВАЯ ГРУППА";
var db = new ssmDataContext();
var nGroup = new group {
name = groupName
};
db.groups.InsertOnSubmit(nGroup);
db.SubmitChanges();
lstGroupFill();
if (lstGroup.Items.FindByText(groupName) != null)
{
lstGroup.SelectedIndex = lstGroup.Items.IndexOf(lstGroup.Items.FindByText(groupName));
lstGroup_SelectedIndexChanged(new object(), new EventArgs());
}
else
{
txtGroupName.Text = lstGroup.SelectedItem.Text;
}
}
ReportDataSource CreateSource()
{
var db = new ssmDataContext();
IEnumerable <SalesDataSource> list = db.logSales
.Join(db.buyers, l => l.buyerId, b => b.id, (l, b) => new { logSales = l, Buyer = b })
.Join(db.sellers, l => l.logSales.sellerId, s => s.id, (l, s) => new { logSalesB = l, Seller = s })
.Where(s => lstSellers.SelectedValue == null || int.Parse(lstSellers.SelectedValue) == 0 || s.Seller.id == int.Parse(lstSellers.SelectedValue))
.Select(s => new SalesDataSource
{
Buyer = s.logSalesB.Buyer.name,
Cash = s.logSalesB.logSales.cash.GetValueOrDefault(),
Date = s.logSalesB.logSales.date.GetValueOrDefault(),
IsGiveBack = s.logSalesB.logSales.isGiveBack.GetValueOrDefault(),
Item = s.logSalesB.logSales.logName,
ItemsCount = s.logSalesB.logSales.itemsCount.GetValueOrDefault(0),
Seller = s.Seller.fullName,
SID = s.logSalesB.logSales.sid.GetValueOrDefault()
}).ToList();
return(new ReportDataSource("SalesDataSource", list));
}
protected void btnAddSubGroup_Click(object sender, EventArgs e)
{
if (lstGroup.SelectedIndex > -1)
{
string subGroupName = "Новая Подгруппа";
var db = new ssmDataContext();
int parentId = int.Parse(lstGroup.SelectedItem.Value);
var nGroup = new group {
name = subGroupName, parent = parentId
};
db.groups.InsertOnSubmit(nGroup);
db.SubmitChanges();
lstGroupFill();
txtGroupName.Text = lstGroup.SelectedItem.Text;
LoadLstSubGroup();
if (lstSubGroup.Items.FindByText(subGroupName) != null)
{
lstSubGroup.SelectedIndex = lstSubGroup.Items.IndexOf(lstSubGroup.Items.FindByText(subGroupName));
lstSubGroup_SelectedIndexChanged(new object(), new EventArgs());
}
}
}
protected void RemoveReports(object sender, EventArgs e)
{
var db = new ssmDataContext();
DateTime fromDate; // = DateTime.Now.AddDays(-1);
DateTime toDate; // = DateTime.Now;
try
{
if (!string.IsNullOrEmpty(txtDateFrom.Text.Trim()))
{
if (DateTime.TryParse(txtDateFrom.Text, out fromDate))
{
if (!string.IsNullOrEmpty(txtDateTo.Text.Trim()))
{
if (DateTime.TryParse(txtDateTo.Text, out toDate))
{
IQueryable <logSale> list = db.logSales.Where(ls => ls.date <toDate && ls.date> fromDate);
int count = list.Count();
db.logSales.DeleteAllOnSubmit(list);
db.SubmitChanges();
lblMessage.Text = "Выполнено за даты с " + fromDate.ToString("yyyy-MM-dd")
+ " по " + toDate.ToString("yyyy-MM-dd")
+ string.Format("\n\r Удалено {0} записей ", count);
return;
}
}
}
}
lblMessage.Text = "Введите корректно даты";
}
catch (Exception ex)
{
Global.Loger.Error("Ошибка при удалении отчётов", ex);
lblMessage.Text = "произошла ошибка при удалении отчётов! попробуйте ещё раз. Если ошибка повторится, обратитесь к разработчику.";
}
}
protected void btnSellerUpdate_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(lstSellers.SelectedValue))
{
string sellerName = txtSellerName.Text;
int sellerID = int.Parse(lstSellers.SelectedValue);
var db = new ssmDataContext();
seller seller = db.sellers.First(b => b.id == sellerID);
seller.fullName = txtSellerName.Text;
seller.login = txtSellerLogin.Text;
seller.password = txtSellerPass.Text;
seller.isActive = chkIsActive.Checked;
seller.isAdmin = chkIsAdmin.Checked;
db.SubmitChanges();
seller.Refresh();
lstsellersFill();
if (lstSellers.Items.FindByText(sellerName) != null)
{
lstSellers.SelectedIndex = lstSellers.Items.IndexOf(lstSellers.Items.FindByText(sellerName));
lstSeller_SelectedIndexChanged(new object(), new EventArgs());
}
}
}
protected void btnMoveToGroup_Click(object sender, EventArgs e)
{
if (lstSubGroup.SelectedItem != null)
{
var db = new ssmDataContext();
int groupId = int.Parse(lstSubGroup.SelectedItem.Value);
List <group> groupToMove = db.groups.Where(g => g.id == groupId).ToList();
if (groupToMove.Count == 1)
{
group group = groupToMove.First();
item item = new item()
{
name = group.name, groupId = group.parent
};
db.items.InsertOnSubmit(item);
db.groups.DeleteOnSubmit(group);
db.SubmitChanges();
lstGroupFill();
LoadLstSubGroup();
}
txtGroupName.Text = lstGroup.SelectedItem.Text;
txtSubGroupName.Text = "";
}
}
