private string getBranchTargetIDs()
{
string targetIDs = "";
try
{
SalesBranchTarget branchTarget = new SalesBranchTarget();
branchTarget.Where.Active.Value = 1;
branchTarget.Where.BranchID.Value = BranchID;
if (branchTarget.Query.Load())
{
if (branchTarget.DefaultView != null && branchTarget.DefaultView.Count > 0)
{
do
{
if (targetIDs == "")
{
targetIDs = "'" + branchTarget.TargetID + "'";
}
else
{
targetIDs += ",'" + branchTarget.TargetID + "'";
}
} while (branchTarget.MoveNext());
}
}
}
catch (Exception ex)
{
//Logger.LogException(ex);
}
return(targetIDs);
}
private void LoadTargetDist()
{
try
{
if (TargetID != -1)
{
if (targetAlreadyExists())
{
btnSave.Text = "Edit";
}
else
{
btnSave.Text = "Save";
}
BranchID = getBranchIDfromUser();
SalesBranchTarget salesBranchTarget = getBranchTarget();//must load TargetID and BranchID first
if (salesBranchTarget == null)
{
TargetAmount = 0;
TargetCurrencyID = -1;
}
else
{
TargetAmount = (double)salesBranchTarget.Amount;
TargetCurrencyID = salesBranchTarget.CurrencyID;
}
lblBranchTarget.Text = TargetAmount.ToString();
//string targetIDs = getLast5YearsTargetIDs();
string salesMenIDs = getAllSalesMenIDs();
string salesMenInBranchIDs = getMyBranchSalesMenIDs(salesMenIDs);
DataTable userLastTargets = getLastUserTargets(salesMenInBranchIDs, BranchID);
if (salesMenIDs != "")
{
LoadSalesMenTable(salesMenIDs, userLastTargets);
}
}
else
{
ScriptManager.RegisterStartupScript(Page, typeof(Page),
"NoTarget", "alert('Target is invalid!');", true);
}
}
catch (Exception ex)
{
//Logger.LogException(ex);
}
}
private SalesBranchTarget getBranchTarget()
{
try
{
SalesBranchTarget branchTarget = new SalesBranchTarget();
branchTarget.Where.Active.Value = 1;
branchTarget.Where.BranchID.Value = BranchID;
branchTarget.Where.TargetID.Value = TargetID;
branchTarget.Query.Load();
if (branchTarget.RowCount > 0)
{
return(branchTarget);
}
}
catch (Exception ex)
{
//Logger.LogException(ex);
}
return(null);
}
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;
}
