private Dictionary <long, double> getThisTargetsDistribution() { Dictionary <long, double> userTarget = new Dictionary <long, double>(); try { SalesBranchUserTarget branchUserTarget = new SalesBranchUserTarget(); branchUserTarget.Where.Active.Value = true; branchUserTarget.Where.TargetID.Value = TargetID; branchUserTarget.Where.BranchID.Value = BranchID; branchUserTarget.Query.Load(); if (branchUserTarget.RowCount > 0) { branchUserTarget.Rewind(); do { userTarget.Add(branchUserTarget.UserID, (double)branchUserTarget.Amount); } while (branchUserTarget.MoveNext()); } } catch (Exception ex) { //Logger.LogException(ex); } return(userTarget); }
private void distributeTarget() { try { int targetYear = int.Parse(ddlTargetYear.SelectedItem.Text); DataTable dt = VSSalesDist; foreach (DataRow dr in dt.Rows) { //branchUserTarget.Where.Active.Value = 1; SalesBranchUserTarget branchUserTarget = new SalesBranchUserTarget(); branchUserTarget.Where.UserID.Value = (long)dr["UserID"]; branchUserTarget.Where.TargetID.Value = TargetID; branchUserTarget.Where.BranchID.Value = BranchID; branchUserTarget.Query.Load(); //if ((bool)dr["tobeSaved"]) { DateTime now = DateTime.Now; string notifyTitle = " Target Redistributed "; string notifyDesc = " is now redistributed and your target is "; if (branchUserTarget.RowCount == 0) { notifyTitle = " Target distributed "; notifyDesc = " is now distributed and your target is "; branchUserTarget.AddNew(); branchUserTarget.CreationDate = now; branchUserTarget.CreatedBy = UserID; } branchUserTarget.Active = true; branchUserTarget.TargetID = TargetID; branchUserTarget.BranchID = BranchID; branchUserTarget.UserID = (long)dr["UserID"]; double newTarget = (double)dr["NewTarget"]; branchUserTarget.Percentage = newTarget * 100.0 / TargetAmount; branchUserTarget.Amount = (decimal)newTarget; branchUserTarget.Modified = now; branchUserTarget.ModifiedBy = UserID; branchUserTarget.CurrencyID = TargetCurrencyID; branchUserTarget.Save(); branchUserTarget.AcceptChanges(); Common.sendNotifications((long)dr["UserID"], targetYear + notifyTitle + "(" + newTarget + ")", targetYear + notifyDesc + newTarget + "\nNote:\n" + txtAreaComment.Text, ""); } } } catch (Exception ex) { //Logger.LogException(ex); } }
private bool targetAlreadyExists() { try { SalesBranchUserTarget branchUserTarget = new SalesBranchUserTarget(); branchUserTarget.Where.Active.Value = true; branchUserTarget.Where.TargetID.Value = TargetID; branchUserTarget.Where.BranchID.Value = BranchID; branchUserTarget.Query.Load(); return(branchUserTarget.RowCount > 0); } catch (Exception ex) { //Logger.LogException(ex); } return(false); }
private void LoadMyTarget() { //string userGroup = getUserGroup(); decimal targetAmount = 0; SalesTarget salesTarget = new SalesTarget(); salesTarget.Where.Active.Value = true; salesTarget.Where.Year.Value = DateTime.Now.Year; salesTarget.Query.Load(); string curShortName = ""; if (salesTarget.RowCount > 0) { Currency currency = new Currency(); currency.LoadByPrimaryKey(salesTarget.CurrencyID); curShortName = currency.ShortName; List <string> gp = new List <string>(); gp.Add("TopManagment"); if (Common.CheckUserInGroups(UserID, gp)) { targetAmount = salesTarget.Target; } else { int myBranchID = getUserBranchID(); gp = new List <string>(); gp.Add("SalesManagers"); if (Common.CheckUserInGroups(UserID, gp)) { SalesBranchTarget branchTarget = new SalesBranchTarget(); branchTarget.Where.Active.Value = true; branchTarget.Where.BranchID.Value = myBranchID; branchTarget.Where.TargetID.Value = salesTarget.ID; branchTarget.Query.Load(); if (branchTarget.RowCount > 0) { targetAmount = branchTarget.Amount; } } else { gp = new List <string>(); gp.Add("SalesMen"); if (Common.CheckUserInGroups(UserID, gp)) { SalesBranchUserTarget userTarget = new SalesBranchUserTarget(); userTarget.Where.Active.Value = true; userTarget.Where.BranchID.Value = myBranchID; userTarget.Where.TargetID.Value = salesTarget.ID; userTarget.Where.UserID.Value = UserID; userTarget.Query.Load(); if (userTarget.RowCount > 0) { targetAmount = userTarget.Amount; } } } } } lblmyTarget.Text = ((double)targetAmount).ToString() + " " + curShortName; }