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);
 }
Example #4
0
        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;
        }