public void SalesTarget_ReturnsRightTarget()
{
var salesPerson = new SalesPerson("Eric", previousSales: 5, experience: Experience.Junior);
var salesTarget = SalesTarget.CalculateSales(salesPerson);
Assert.AreEqual(10, salesTarget);
}
public SalesTarget InsertSalesTarget(SalesTarget salestarget)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
var result = new SalesTarget();
IDbTransaction trn = connection.BeginTransaction();
string sql = @"INSERT INTO SalesTarget (SalesTargetRefNo,MonthId,WorkDescriptionId,Target,OrganizationId,FyId,CreatedBy,CreatedDate,isActive)
VALUES(@SalesTargetRefNo,@MonthId,@WorkDescriptionId,@Target,@OrganizationId,@FyId,@CreatedBy,@CreatedDate,1);
SELECT CAST(SCOPE_IDENTITY() as int)";
try
{
int internalid = DatabaseCommonRepository.GetInternalIDFromDatabase(connection, trn, typeof(SalesTarget).Name, "0", 1);
salestarget.SalesTargetRefNo = "ST/" + internalid;
int id = connection.Query <int>(sql, salestarget, trn).Single();
salestarget.SalesTargetId = id;
InsertLoginHistory(dataConnection, salestarget.CreatedBy, "Create", "SalesTarget", internalid.ToString(), "0");
//connection.Dispose();
trn.Commit();
}
catch (Exception ex)
{
trn.Rollback();
salestarget.SalesTargetId = 0;
salestarget.SalesTargetRefNo = null;
}
return(salestarget);
}
}
public ActionResult Create(SalesTarget model)
{
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = UserID.ToString();
model.FyId = new FinancialYearRepository().getfinyear(OrganizationId);
var repo = new SalesTargetRepository();
bool isexists = repo.IsFieldExists(repo.ConnectionString(), "SalesTarget", "SalesTargetRefNo", model.SalesTargetRefNo, null, null);
if (!isexists)
{
var result = new SalesTargetRepository().InsertSalesTarget(model);
if (result.OrganizationId > 0)
{
TempData["Success"] = "Added Successfully!";
TempData["SalesTargetRefNo"] = result.SalesTargetRefNo;
return(RedirectToAction("Create"));
}
else
{
dropdown();
TempData["error"] = "Oops!!..Something Went Wrong!!";
TempData["SalesTargetRefNo"] = null;
return(View("Create", model));
}
}
else
{
dropdown();
TempData["error"] = "This Organization Name Alredy Exists!!";
TempData["SalesTargetRefNo"] = null;
return(View("Create", model));
}
}
public SalesTargetDetailPage(SalesTarget item)
{
InitializeComponent();
NavigationPage.SetHasNavigationBar(this, false);
//tar_name.Text = item.name;
//tar_type.Text = item.target_type;
//orderListview.ItemsSource = item.brand;
//ProductCatListview.ItemsSource = item.category;
var backImgRecognizer = new TapGestureRecognizer();
backImgRecognizer.Tapped += async(s, e) =>
{
// handle the tap
var currentpage = new LoadingAlert();
await PopupNavigation.PushAsync(currentpage);
Application.Current.MainPage = new MasterPage(new SalesTargetPage());
// orderListview.ItemsSource = null;
Loadingalertcall();
};
backImg.GestureRecognizers.Add(backImgRecognizer);
}
private List <SalesTarget> GetSelectedItem(int inrow)
{
List <SalesTarget> items = new List <SalesTarget>();
SalesTarget itm = new SalesTarget();
try
{
itm.strKey = DG.Rows[inrow].Cells[0].Value.ToString();
//itm.strMerzeName = DG.Rows[inrow].Cells[1].Value.ToString();
//itm.strLedgerName = DG.Rows[inrow].Cells[2].Value.ToString();
itm.strBranchName = DG.Rows[inrow].Cells[1].Value.ToString();
itm.strFromDate = DG.Rows[inrow].Cells[2].Value.ToString();
itm.strToDate = DG.Rows[inrow].Cells[3].Value.ToString();
if (DG.Rows[inrow].Cells[4].Value.ToString() == "Item Wise")
{
itm.intType = 0;
}
else
{
itm.intType = 1;
}
items.Add(itm);
return(items);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(items);
}
}
protected void gvwMaster_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRow")
{
int id = Convert.ToInt32(e.CommandArgument);
mvwForm.ActiveViewIndex = 1;
SalesTarget salesTarget = salesTargetProvider.GetTarget(id);
RowID = id;
ddlBranch.SelectedValue = salesTarget.BranchID.ToString();
ddlYear.SelectedValue = salesTarget.Year.ToString();
ddlMonth.SelectedValue = salesTarget.Month.ToString();
txtFreshMemberUnit.Text = salesTarget.FreshMemberUnit.ToString();
txtFreshMemberRevenue.Text = salesTarget.FreshMemberRevenue.ToString();
txtRenewalUnit.Text = salesTarget.RenewalUnit.ToString();
txtRenewalRevenue.Text = salesTarget.RenewalRevenue.ToString();
txtUpgradeUnit.Text = salesTarget.UpgradeUnit.ToString();
txtUpgradeRevenue.Text = salesTarget.UpgradeRevenue.ToString();
txtVocalRevenue.Text = salesTarget.VocalRevenue.ToString();
txtPilatesRevenue.Text = salesTarget.PilatesRevenue.ToString();
txtOtherRevenue.Text = salesTarget.OtherRevenue.ToString();
txtEFTCollectionRevenue.Text = salesTarget.EFTCollectionRevenue.ToString();
txtDropOffUnit.Text = salesTarget.DropOffUnit.ToString();
txtCancelFees.Text = salesTarget.CancelFees.ToString();
txtFreezeFees.Text = salesTarget.FreezeFees.ToString();
txtFreezeUnit.Text = salesTarget.FreezeUnit.ToString();
txtFreshMemberUnit.Focus();
}
}
public async Task <IActionResult> GetSupervisorSalesman()
{
string markers = "";
List <SalesmanLocation> salesmanLocationsList = new List <SalesmanLocation>();
List <Salesman> salesmanList = await _context.Salesman.ToListAsync();
if (salesmanList == null)
{
return(NotFound());
}
else
{
foreach (var item in salesmanList)
{
SalesTarget salesTarget = await _context.SalesTarget.Where(x => x.SalesmanId == item.SalesmanId && x.Status == StatusList.approved).SingleOrDefaultAsync();
if (salesTarget != null)
{
Location location = await _context.Location.Where(x => x.LocationId == item.LocationId).SingleOrDefaultAsync();
SalesmanLocation salesmanLocation = new SalesmanLocation();
salesmanLocation.salesman = item;
salesmanLocation.location = location;
markers += "[" + location.Latitude + "," + location.Longitude + "]";
salesmanLocationsList.Add(salesmanLocation);
}
}
}
ViewBag.Markers = markers;
int Count = salesmanLocationsList.Count();
return(Ok(new { salesmanLocationsList, Count }));
}
public Result Insert(SalesTarget model)
{
Result res = new Result(false);
try
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = string.Empty;
int FyId = model.FyId;
string query = @"DELETE FROM SalesTarget WHERE FyId =" + FyId + "";
connection.Execute(query, new { FyId = FyId });
foreach (var item in model.SalesTargetItems)
{
sql = @"INSERT INTO SalesTarget
(FyId,SalesMgId,Quarer1,Quarer2,Quarer3,Quarer4,Total)
VALUES(" + FyId + ",@SalesMgId,@Quarer1,@Quarer2,@Quarer3,@Quarer4,@Total);SELECT CAST(SCOPE_IDENTITY() as int);";
}
int id = connection.Execute(sql, model.SalesTargetItems);
if (id > 0)
{
return(new Result(true));
}
}
}
catch (Exception ex)
{
return(new Result(false, ex.InnerException == null ? ex.Message : ex.InnerException.Message));
}
return(res);
}
public int DeleteSalesTarget(SalesTarget objSalesTarget)
{
int result = 0;
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = @" Update SalesTarget Set isActive=0 WHERE SalesTargetId=@SalesTargetId";
try
{
var id = connection.Execute(sql, objSalesTarget);
objSalesTarget.SalesTargetId = id;
result = 0;
InsertLoginHistory(dataConnection, objSalesTarget.CreatedBy, "Delete", "SalesTarget", id.ToString(), "0");
}
catch (SqlException ex)
{
int err = ex.Errors.Count;
if (ex.Errors.Count > 0) // Assume the interesting stuff is in the first error
{
switch (ex.Errors[0].Number)
{
case 547: // Foreign Key violation
result = 1;
break;
default:
result = 2;
break;
}
}
}
return(result);
}
}
private int getTargetYear(int targetID)
{
SalesTarget target = new SalesTarget();
target.LoadByPrimaryKey(targetID);
return(target.Year);
}
protected void btnInsert_Click(object sender, EventArgs e)
{
SalesTarget repository = new SalesTarget();
string monthName = cbMonth.SelectedValue;
int amount = Convert.ToInt32(txtAmount.Text);
if (!repository.checkSaleTarget_Available(monthName))
{
if (repository.Add(new tblSalesTarget {
MonthName = monthName, TargetAmount = amount
}))
{
this.ShowSuccessfulNotification("Target successfully added for " + monthName);
gridSaletarget.DataBind();
txtAmount.Text = "";
}
else
{
this.ShowErrorNotification("Error occured");
}
}
else
{
this.ShowErrorNotification("Target already available for " + monthName);
}
}
public ActionResult Delete(SalesTarget model)
{
model.CreatedBy = UserID.ToString();
int result = new SalesTargetRepository().DeleteSalesTarget(model);
if (result == 0)
{
TempData["Success"] = "Deleted Successfully";
TempData["SalesTargetRefNo"] = model.SalesTargetRefNo;
return(RedirectToAction("Create"));
}
else
{
if (result == 1)
{
TempData["error"] = "Sorry!! You Cannot Delete This Sales Target It Is Already In Use";
TempData["SalesTargetRefNo"] = null;
}
else
{
TempData["error"] = "Oops!!..Something Went Wrong!!";
TempData["SalesTargetRefNo"] = null;
}
return(RedirectToAction("Create"));
}
}
private void LoadTargetYearsDDL()
{
try
{
ddlTargetYear.Items.Clear();
SalesTarget target = new SalesTarget();
target.Where.Active.Value = 1;
target.Where.Year.Value = DateTime.Now.Year;
target.Where.Year.Operator = WhereParameter.Operand.GreaterThanOrEqual;
target.Query.AddOrderBy(SalesTarget.ColumnNames.Year, WhereParameter.Dir.ASC);
target.Query.Load();
if (target.RowCount > 0)
{
target.Rewind();
do
{
ddlTargetYear.Items.Add(new ListItem(target.Year.ToString(), target.ID.ToString()));
} while (target.MoveNext());
}
if (TargetID != -1)
{
ddlTargetYear.SelectedValue = TargetID.ToString();
}
else
{
ddlTargetYear.SelectedIndex = 0;
TargetID = int.Parse(ddlTargetYear.SelectedValue);
}
ddlTargetYear_SelectedIndexChanged(null, null);
}
catch (Exception ex)
{
//Logger.LogException(ex);
}
}
private void totalSale()
{
try
{
var now = DateTime.Now;
var startOfMonth = new DateTime(now.Year, now.Month, 1);
var endOfMonth = new DateTime(now.Year, now.Month, DateTime.DaysInMonth(now.Year, now.Month));
SalesTarget repository = new SalesTarget();
String currentMonthName = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(now.Month);
currentMonthName += " " + now.Year;
lblPurchaseMonth.InnerHtml = "Total purchase of " + currentMonthName;
lblSaleMonth.InnerHtml = "Total sale of " + currentMonthName;
var currentMonthtarget = repository.GetAll().Where(r => r.MonthName.Equals(currentMonthName)).FirstOrDefault();
SaleInvoice repo = new SaleInvoice();
decimal totalSale = repo.totalSaleByMonth(startOfMonth, endOfMonth);
lblTotalSale.InnerHtml = "$" + totalSale.ToString();
double percentage = Math.Round(Convert.ToDouble((totalSale / currentMonthtarget.TargetAmount) * 100), 2);
lbltarget.InnerHtml = "Congratulations! You have achieved " + percentage + "% of total sale";
string rateBar = "<div style='float: left;'>" +
" <div class='meter red animate' style='width: 970px;;'>" +
"<span style='width: " + percentage + "%'><span></span>" +
"</div></div>";
divRate.InnerHtml = rateBar;
}
catch (Exception)
{
}
}
public TargetDetailPage(SalesTarget item)
{
InitializeComponent();
// saleresult = Controller.InstanceCreation().salesTargetData();
targetListview.ItemsSource = item.target_line;
name_val.Text = item.name;
com_val.Text = item.commission_type;
}
public ActionResult Create()
{
ViewBag.Title = "Create";
SalesTarget Salestarget = new SalesTarget();
Salestarget.SalesTargetRefNo = "ST/" + DatabaseCommonRepository.GetNextReferenceNo(typeof(SalesTarget).Name);// new SalesTargetRepository().GetRefNo(Salestarget);
dropdown();
return(View(Salestarget));
}
public IActionResult Remove([FromBody] CrudViewModel <SalesTarget> payload)
{
SalesTarget salestarget = _context.SalesTarget
.Where(x => x.SalestargetId == (int)payload.key)
.FirstOrDefault();
_context.SalesTarget.Remove(salestarget);
_context.SaveChanges();
return(Ok(salestarget));
}
public JsonResult GetFilteredData(int id = 0)
{
String userEmail = Convert.ToString(TempData.Peek("UserEmail"));
List <Mydata> mydatalist = new List <Mydata>();
var markers = "[";
List <SalesmanLocation> salesmanLocationsList = new List <SalesmanLocation>();
Supervisor supervisor = _context.Supervisor.Where(x => x.Email.ToUpper().Equals(userEmail)).FirstOrDefault();
ApplicationUser User = _context.ApplicationUser.Where(x => x.Email.Equals(userEmail)).FirstOrDefault();
if (User.UserType.ToUpper().Trim() == UserType.Supervisor)
{
List <Salesman> salesmanList = null;
if (id == 0)
{
salesmanList = _context.Salesman.Where(x => x.SupervisorId.Equals(supervisor.SupervisorId)).ToList();
}
else
{
salesmanList = _context.Salesman.Where(x => x.SupervisorId.Equals(supervisor.SupervisorId) && x.SalesmanId.Equals(id)).ToList();
}
if (salesmanList == null)
{
return(Json(""));
}
else
{
foreach (var item in salesmanList)
{
SalesTarget salesTarget = _context.SalesTarget.Where(x => x.SalesmanId == item.SalesmanId && x.Status == StatusList.approved).SingleOrDefault();
if (salesTarget != null)
{
Location location = _context.Location.Where(x => x.LocationId == item.LocationId).SingleOrDefault();
SalesmanLocation salesmanLocation = new SalesmanLocation();
salesmanLocation.salesman = item;
salesmanLocation.location = location;
markers += "['" + location.Description + "'," + location.Latitude + "," + location.Longitude + "],";
Mydata m = new Mydata(location.Description, location.Latitude, location.Longitude);
mydatalist.Add(m);
salesmanLocationsList.Add(salesmanLocation);
}
}
}
markers = markers + "];";
//ViewBag.Markers = "[['Bondi Beach', -33.890542, 151.274856],['Coogee Beach', -33.923036, 151.259052],];";
return(Json(mydatalist, new Newtonsoft.Json.JsonSerializerSettings()));
}
else
{
return(Json(""));
}
}
public SalesTarget UpdateSalesTarget(SalesTarget ObjSalesTarget)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = @"Update SalesTarget Set SalesTargetRefNo=@SalesTargetRefNo,MonthId=@MonthId,WorkDescriptionId=@WorkDescriptionId,Target=@Target,OrganizationId=@OrganizationId,FyId=@FyId,CreatedBy=@CreatedBy,CreatedDate=@CreatedDate OUTPUT INSERTED.OrganizationId WHERE SalesTargetId=@SalesTargetId";
var id = connection.Execute(sql, ObjSalesTarget);
InsertLoginHistory(dataConnection, ObjSalesTarget.CreatedBy, "Update", "SalesTarget", id.ToString(), "0");
return(ObjSalesTarget);
}
}
private List <SalesTarget> GetSelectedItem(int inrow)
{
List <SalesTarget> items = new List <SalesTarget>();
SalesTarget itm = new SalesTarget();
itm.strKey = DG.Rows[inrow].Cells[0].Value.ToString();
itm.strFromDate = DG.Rows[inrow].Cells[2].Value.ToString();
itm.strToDate = DG.Rows[inrow].Cells[3].Value.ToString();
itm.strBranchID = DG.Rows[inrow].Cells[4].Value.ToString();
items.Add(itm);
return(items);
}
public IActionResult Insert([FromBody] CrudViewModel <SalesTarget> payload)
{
SalesTarget salestarget = payload.value;
salestarget.WaterValue3 = salestarget.WaterValue1 + salestarget.WaterValue2;
salestarget.JuiceValue3 = salestarget.JuiceValue1 + salestarget.JuiceValue2;
salestarget.TotalValue1 = salestarget.WaterValue1 + salestarget.JuiceValue1;
salestarget.TotalValue2 = salestarget.WaterValue2 + salestarget.JuiceValue2;
salestarget.TotalValue3 = salestarget.TotalValue1 + salestarget.TotalValue2;
_context.SalesTarget.Add(salestarget);
_context.SaveChanges();
return(Ok(salestarget));
}
public IActionResult Index(int id = 0)
{
string salesmanString = "[";
//String userEmail = Convert.ToString(TempData["UserEmail"]).ToUpper().Trim();
String userEmail = Convert.ToString(TempData.Peek("UserEmail"));
string markers = "[";
List <SalesmanLocation> salesmanLocationsList = new List <SalesmanLocation>();
Supervisor supervisor = _context.Supervisor.Where(x => x.Email.ToUpper().Equals(userEmail)).FirstOrDefault();
ApplicationUser User = _context.ApplicationUser.Where(x => x.Email.Equals(userEmail)).FirstOrDefault();
List <Salesman> salesmanList = null;
if (id == 0)
{
salesmanList = _context.Salesman.Where(x => x.SupervisorId.Equals(supervisor.SupervisorId)).ToList();
}
else
{
salesmanList = _context.Salesman.Where(x => x.SupervisorId.Equals(supervisor.SupervisorId) && x.SalesmanId.Equals(id)).ToList();
}
if (salesmanList == null)
{
return(NotFound());
}
else
{
foreach (var item in salesmanList)
{
SalesTarget salesTarget = _context.SalesTarget.Where(x => x.SalesmanId == item.SalesmanId && x.Status == StatusList.approved).SingleOrDefault();
if (salesTarget != null)
{
Location location = _context.Location.Where(x => x.LocationId == item.LocationId).SingleOrDefault();
SalesmanLocation salesmanLocation = new SalesmanLocation();
salesmanLocation.salesman = item;
salesmanLocation.location = location;
markers += "['" + location.Description + "'," + location.Latitude + "," + location.Longitude + "],";
salesmanLocationsList.Add(salesmanLocation);
}
salesmanString += "{ text: '" + item.SalesmanName + "', value: '" + item.SalesmanId + "'},";
}
}
salesmanString = salesmanString + "]";
markers = markers + "];";
ViewBag.Markers = markers;
ViewBag.Salesman = salesmanString;
return(View(salesmanLocationsList));
}
private string getLast5YearsTargetIDs()
{
string targetIDs = "";
try
{
string targetYears = "";
SalesTarget thisTarget = new SalesTarget();
thisTarget.LoadByPrimaryKey(TargetID);
int targetYear = thisTarget.Year;
SalesTarget target = new SalesTarget();
target.Where.Active.Value = true;
target.Where.Year.Value = targetYear;
target.Where.Year.Operator = WhereParameter.Operand.LessThan;
target.Query.AddOrderBy(SalesTarget.ColumnNames.Year, WhereParameter.Dir.DESC);
target.Query.Top = 5;
if (target.Query.Load())
{
if (target.DefaultView != null && target.DefaultView.Count > 0)
{
do
{
if (targetIDs == "")
{
targetIDs = "'" + target.ID + "'";
}
else
{
targetIDs += ",'" + target.ID + "'";
}
if (targetYears == "")
{
targetYears = "'" + target.Year + "'";
}
else
{
targetYears += ",'" + target.Year + "'";
}
} while (target.MoveNext());
}
}
}
catch (Exception ex)
{
//Logger.LogException(ex);
}
return(targetIDs);
}
public TargetDetailPage(SalesTarget item)
{
InitializeComponent();
// saleresult = Controller.InstanceCreation().salesTargetData();
targetListview.ItemsSource = item.target_line;
name_val.Text = item.name;
com_val.Text = item.commission_type;
var backRecognizer = new TapGestureRecognizer();
backRecognizer.Tapped += (s, e) => {
PopupNavigation.PopAsync();
// Navigation.PopAllPopupAsync();
// Navigation.PushAsync(new CalendarPage());
// App.Current.MainPage = new MasterPage(new CalendarPage());
};
backImg.GestureRecognizers.Add(backRecognizer);
}
public ActionResult Create(SalesTarget model)
{
if (!ModelState.IsValid)
{
var allErrors = ModelState.Values.SelectMany(v => v.Errors);
return(View(model));
}
Result res = new SalesTargetRepository().Insert(model);
if (res.Value)
{
TempData["Success"] = "Saved Successfully!";
}
else
{
}
return(RedirectToAction("Create"));
}
public void UpdateTarget(int id,
int branchID,
int year,
int month,
int freshMemberUnit,
int upgradeUnit,
int renewalUnit,
decimal freshMemberRevenue,
decimal upgradeRevenue,
decimal renewalRevenue,
decimal pilatesRevenue,
decimal vocalRevenue,
decimal eftCollectionRevenue,
int dropOffUnit,
decimal cancelFees,
int freezeUnit,
decimal freezeFees,
decimal otherRevenue)
{
SalesTarget salesTarget = context.SalesTargets.SingleOrDefault(target => target.ID == id);
if (salesTarget != null)
{
salesTarget.BranchID = branchID;
salesTarget.Year = year;
salesTarget.Month = month;
salesTarget.FreshMemberUnit = freshMemberUnit;
salesTarget.RenewalUnit = renewalUnit;
salesTarget.UpgradeUnit = upgradeUnit;
salesTarget.FreshMemberRevenue = freshMemberRevenue;
salesTarget.RenewalRevenue = renewalRevenue;
salesTarget.UpgradeRevenue = upgradeRevenue;
salesTarget.PilatesRevenue = pilatesRevenue;
salesTarget.VocalRevenue = vocalRevenue;
salesTarget.EFTCollectionRevenue = eftCollectionRevenue;
salesTarget.DropOffUnit = dropOffUnit;
salesTarget.CancelFees = cancelFees;
salesTarget.FreezeFees = freezeFees;
salesTarget.FreezeUnit = freezeUnit;
salesTarget.OtherRevenue = otherRevenue;
EntityHelper.SetAuditFieldForUpdate(salesTarget, principal.Identity.Name);
context.SaveChanges();
}
}
private TargetSalesViewModel GetTargetSalesViewModel(SalesTarget item, List <RHHeader> rhHeaders)
{
TargetSalesViewModel model = new TargetSalesViewModel()
{
RayonCode = item.RayonCode,
AchiGroup = item.AchiGroup,
Material = item.Material,
Division = item.Division,
Target = item.Target.Value.ToString("N0"),
SLM_NIK = item.SLM.Value,
SLM_Name = rhHeaders.FirstOrDefault(x => x.RayonCode.Equals(item.RayonCode)).SLMObj1.FullName,
FSS_NIK = item.FSS.Value,
FSS_Name = rhHeaders.FirstOrDefault(x => x.RayonCode.Equals(item.RayonCode)).FSSObj1.FullName,
Bulan = item.Bulan.Value,
Tahun = item.Tahun.Value
};
return(model);
}
public ActionResult SalesTarget(int?FyId)
{
SalesTarget Model = new SalesTarget();
if (FyId == null || FyId == 0)
{
Model.SalesTargetItems = new SalesTargetRepository().GetEmployees();
}
else
{
Model.SalesTargetItems = new SalesTargetRepository().GetEmployees(FyId);
}
if (Model.SalesTargetItems.Count == 0)
{
Model.SalesTargetItems = new SalesTargetRepository().GetEmployees();
}
return(PartialView("_SalesTargetGrid", Model));
}
public void AddTarget(int branchID,
int year,
int month,
int freshMemberUnit,
int upgradeUnit,
int renewalUnit,
decimal freshMemberRevenue,
decimal upgradeRevenue,
decimal renewalRevenue,
decimal pilatesRevenue,
decimal vocalRevenue,
decimal eftCollectionRevenue,
int dropOffUnit,
decimal cancelFees,
int freezeUnit,
decimal freezeFees,
decimal otherRevenue)
{
var salesTarget = new SalesTarget();
salesTarget.BranchID = branchID;
salesTarget.Year = year;
salesTarget.Month = month;
salesTarget.FreshMemberUnit = freshMemberUnit;
salesTarget.RenewalUnit = renewalUnit;
salesTarget.UpgradeUnit = upgradeUnit;
salesTarget.FreshMemberRevenue = freshMemberRevenue;
salesTarget.RenewalRevenue = renewalRevenue;
salesTarget.UpgradeRevenue = upgradeRevenue;
salesTarget.PilatesRevenue = pilatesRevenue;
salesTarget.VocalRevenue = vocalRevenue;
salesTarget.EFTCollectionRevenue = eftCollectionRevenue;
salesTarget.DropOffUnit = dropOffUnit;
salesTarget.CancelFees = cancelFees;
salesTarget.FreezeFees = freezeFees;
salesTarget.FreezeUnit = freezeUnit;
salesTarget.OtherRevenue = otherRevenue;
EntityHelper.SetAuditFieldForInsert(salesTarget, principal.Identity.Name);
context.Add(salesTarget);
context.SaveChanges();
}
public string GetRefNo(SalesTarget objSalesTarget)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
string RefNo = "";
var result = new SalesTarget();
IDbTransaction trn = connection.BeginTransaction();
try
{
int internalid = DatabaseCommonRepository.GetInternalIDFromDatabase(connection, trn, typeof(SalesTarget).Name, "0", 0);
RefNo = "ST/" + internalid;
trn.Commit();
}
catch (Exception ex)
{
trn.Rollback();
}
return(RefNo);
}
}
