public List <AgentReportModel> GetAgentInfo()
{
int sno = 0;
var data = ent.Core_GetAgentInfo();
List <AgentReportModel> model = new List <AgentReportModel>();
foreach (var item in data)
{
sno++;
AgentReportModel agentreportmodel = new AgentReportModel();
agentreportmodel.SNO = sno;
agentreportmodel.AgentName = item.AgentName;
agentreportmodel.AgentCode = item.AgentCode;
agentreportmodel.Address = item.Address;
agentreportmodel.Email = item.Email;
agentreportmodel.Phone = item.Phone;
agentreportmodel.mobile = item.MobileNo;
agentreportmodel.zonename = item.ZoneName;
agentreportmodel.districtname = item.DistrictName;
agentreportmodel.signupby = item.SignupBy;
agentreportmodel.SignupDate = item.SingupDate;
agentreportmodel.Type = item.Type;
agentreportmodel.BranchName = GetBranchNameByAgentCode(agentreportmodel.AgentCode);
agentreportmodel.DistributorName = GetDistributorNameByAgentCode(agentreportmodel.AgentCode);
agentreportmodel.MEsName = GetMEsNameByAgentCode(agentreportmodel.AgentCode);
model.Add(agentreportmodel);
}
return(model.OrderBy(x => x.AgentName).ToList());
}
public ActionResult Index(int?page)
{
int currentPageIndex = page.HasValue ? page.Value : 1;
int defaultPageSize = 30;
AgentReportModel model = new AgentReportModel();
model.AgentDetailList = ser.GetAgentInfo().ToPagedList(currentPageIndex, defaultPageSize);
return(View(model));
}
public ActionResult Index(ExportModel Expmodel, AgentReportModel model, FormCollection frm, int?page)
{
int currentPageIndex = 1; //page.HasValue ? page.Value : 1;
int defaultPageSize = 1000000; //30;
model.AgentDetailList = ser.GetAgentInfo().ToPagedList(currentPageIndex, defaultPageSize);
//export
BookedTicket.GetExportTypeClicked(Expmodel, frm);
if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null))
{
try
{
if (Expmodel.ExportTypeExcel != null)
{
Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel;
}
else if (Expmodel.ExportTypeWord != null)
{
Expmodel.ExportTypeWord = Expmodel.ExportTypeWord;
}
else if (Expmodel.ExportTypePdf != null)
{
Expmodel.ExportTypePdf = Expmodel.ExportTypePdf;
}
var exportData = model.AgentDetailList.Select(m => new
{
Branch_Name = m.BranchName,
Distributor_Name = m.DistributorName,
Agent_Name = m.AgentName,
Agent_Code = m.AgentCode,
MEs_Name = m.MEsName,
Address = m.Address,
Email = m.Email,
Phone = m.Phone,
Mobile = m.mobile,
Zone_Name = m.zonename,
District_Name = m.districtname,
Signup_By = m.signupby,
Signup_Date = TimeFormat.DateFormat(m.SignupDate.ToString()),
Reg_By = m.Type == -1 ? "Admin" : "Self"
});
App_Class.AppCollection.Export(Expmodel, exportData, "Agent Information");
}
catch
{
}
}
return(View(model));
}
public ActionResult Add()
{
try
{
var OperatePerson = Request["OperatePerson"] ?? "";
if (OperatePerson.Equals("") || !GetOperatePerson(OperatePerson))
{
return(Json("请检查登入账号！"));
}
string[] AddCardIds = Request["AddCardId"].ToString().Split(new char[] { '，', ',' }, StringSplitOptions.RemoveEmptyEntries);
var AddPassWord = Request["AddPassWord"] ?? "";
var AddEndDate = Convert.ToDateTime(Request["AddEndDate"]);
var AddStartTime = Convert.ToDateTime(Request["AddStartTime"]);
var AddEndTime = Convert.ToDateTime(Request["AddEndTime"]);
var AddClockPlan = Convert.ToInt32(Request["AddClockPlan"]);
foreach (var AddCardId in AddCardIds)
{
AgentReportModel model = new AgentReportModel
{
ID = Guid.NewGuid(),
UserName = "",
CardID = AddCardId,
PassWord = AddPassWord,
StartDate = DateTime.Now,
EndDate = AddEndDate,
ClockPlan = AddClockPlan,
StartTime = AddStartTime,
EndTime = AddEndTime,
NeedClock = true,
Ratio = 1,
OperatePerson = OperatePerson,
CreateTime = DateTime.Now,
LastModifyTime = DateTime.Now,
Flag = true,
};
Db.AgentReportModel.Add(model);
Db.Entry <AgentReportModel>(model).State = EntityState.Added;
}
if (Db.SaveChanges() > 0)
{
return(Json("OK"));
}
else
{
return(Json("添加失败"));
}
}
catch (Exception ex)
{
return(Json($"添加失败,请检查数据格式！异常信息：{ex}"));
}
}
public ActionResult AgentReport()
{
List <AgentReportModel> agentreport = new List <AgentReportModel>();
var startDate = DateTime.Today.AddDays(-40);
var endDate = DateTime.Today.AddDays(0);
foreach (var user in _context.Kaedcuser.Where(u => u.IsActive == 1))
{
var agent = new AgentReportModel();
agent.Fullname = user.Firstname + " " + user.Surname;
agent.TotalSales = _context.Transaction.Where(t => t.KaedcUserNavigation.Id == user.Id).Select(t => t.Amount).Sum();
agent.PrepaidTotalSales = _context.Transaction.Where(t => t.KaedcUserNavigation.Id == user.Id && t.ServiceId == 1).Select(t => t.Amount).ToList().Sum();
agent.PostpaidTotalSales = _context.Transaction.Where(t => t.KaedcUserNavigation.Id == user.Id && t.ServiceId == 2).Select(t => t.Amount).ToList().Sum();
agent.PrepaidTotalProfit = _context.Transaction.Where(t => t.KaedcUserNavigation.Id == user.Id && t.ServiceId == 1).Select(t => t.AgentProfit).ToList().Sum();
agent.PostpaidTotalProfit = _context.Transaction.Where(t => t.KaedcUserNavigation.Id == user.Id && t.ServiceId == 2).Select(t => t.AgentProfit).ToList().Sum();;
agent.Location = user.CompanyAddress;
agentreport.Add(agent);
}
return(View(agentreport));
}
/// <summary>
/// Get data of agent report
/// </summary>
/// <param name="filters"></param>
/// <param name="userName"></param>
/// <returns></returns>
public dynamic GetAgentReport(AverageReportsFilters filters, string userName)
{
#region filters
using (SqlConnection sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CC_ProdConn"].ConnectionString))
{
SqlCommand sqlComm = new SqlCommand
{
Connection = sqlCon,
CommandText = "[GetAgentReport]",
CommandType = CommandType.StoredProcedure
};
sqlComm.Parameters.AddWithValue("@userName", userName);
if (filters.filters.scorecards != null && (filters.filters.scorecards.Count > 0))
{
var preparedLst = new StringBuilder();
foreach (var value in filters.filters.scorecards)
{
preparedLst.Append(("'" + (value + "',")));
}
sqlComm.Parameters.AddWithValue("@scorecardIDs", preparedLst.ToString().Trim(','));
}
if (filters.filters.campaigns != null && ((filters.filters.campaigns.Count > 0)))
{
var preparedLst = new StringBuilder();
foreach (var value in filters.filters.campaigns)
{
preparedLst.Append(("'" + (value.Replace(",", "<!@!>") + "',")));
}
sqlComm.Parameters.AddWithValue("@campaignIDs", preparedLst.ToString().Trim(','));
}
if (filters.filters.groups != null && (filters.filters.groups.Count > 0))
{
var preparedLst = new StringBuilder();
foreach (var value in filters.filters.groups)
{
preparedLst.Append(("'" + (value.Replace(",", "<!@!>") + "',")));
}
sqlComm.Parameters.AddWithValue("@groupIDs", preparedLst.ToString().Trim(','));
}
sqlComm.Parameters.AddWithValue("@filterByReviewDate", filters.filters.filterByReviewDate);
sqlComm.Parameters.AddWithValue("@pagerows", filters.paging.pagerows);
sqlComm.Parameters.AddWithValue("@pagenum", filters.paging.pagenum);
//sqlComm.Parameters.AddWithValue("@missedBy", filters.filters.missedBy);
if (((filters.range == null) || (filters.range.start.Length < 4)))
{
sqlComm.Parameters.AddWithValue("@Start", DateTime.Now.AddDays(-14));
}
else
{
sqlComm.Parameters.AddWithValue("@Start", DateTime.Parse(filters.range.start));
}
if (((filters.range.end == null) || (filters.range.end.Length < 4)))
{
sqlComm.Parameters.AddWithValue("@end", DateTime.Now);
}
else
{
sqlComm.Parameters.AddWithValue("@end", DateTime.Parse(filters.range.end));
}
sqlComm.CommandTimeout = int.MaxValue;
#endregion
AgentReportModel agentReportModel = new AgentReportModel();
agentReportModel.agentReports = new List <AgentReports>();
sqlCon.Open();
SqlDataReader reader = sqlComm.ExecuteReader();
try
{
while (reader.Read())
{
try
{
agentReportModel.agentReports.Add(new AgentReports
{
agentName = reader.GetValue(reader.GetOrdinal("AGENT")).ToString(),
scorecard = new ScorecardInfo
{
scorecardId = int.Parse(reader.GetValue(reader.GetOrdinal("scId")).ToString()),
scorecardName = reader.GetValue(reader.GetOrdinal("scorecardName")).ToString()
},
reviewId = reader.IsDBNull(reader.GetOrdinal("review_ID")) ? (int?)null : int.Parse(reader.GetValue(reader.GetOrdinal("review_ID")).ToString()),
reviewer = reader.GetValue(reader.GetOrdinal("reviewer")).ToString(),
agentGroup = reader.GetValue(reader.GetOrdinal("AGENT_GROUP")).ToString(),
campaign = reader.GetValue(reader.GetOrdinal("CAMPAIGN")).ToString(),
scorecardPassPercent = int.Parse(reader.GetValue(reader.GetOrdinal("pass_percent")).ToString()),
scorecardFailScore = int.Parse(reader.GetValue(reader.GetOrdinal("fail_score")).ToString()),
callTime = (int)Math.Round(double.Parse(reader.GetValue(reader.GetOrdinal("callTime")).ToString())),
agentScore = int.Parse(reader.GetValue(reader.GetOrdinal("score")).ToString())
});
}
catch (Exception ex) { throw ex; }
}
if (reader.NextResult())
{
while (reader.Read())
{
agentReportModel.totalCalls = int.Parse(reader.GetValue(reader.GetOrdinal("totalCalls")).ToString());
}
}
}
catch (Exception ex) { throw ex; }
return(agentReportModel);
}
}
