//Get single record
public OSC_ImportNPT Get(long id)
{
OSC_ImportNPT result = new OSC_ImportNPT();
try
{
result = this.idb.Where(t => t.NPTReportId == id).FirstOrDefault();
}
catch (Exception ex)
{
_err.MessageType = "Server Error";
_err.MessageDescription = ex.Message.ToString();
return(result);
}
return(result);
}
//Edit
public bool Edit(OSC_ImportNPT paramObj)
{
bool result = false;
try
{
if (ModelState.IsValid)
{
db.Entry(paramObj).State = EntityState.Modified;
db.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
_err.MessageType = "Server Error";
_err.MessageDescription = ex.Message.ToString();
return(result);
}
return(result);
}
//Create
public bool Create(OSC_ImportNPT paramObj)
{
bool result = false;
try
{
if (ModelState.IsValid)
{
db.NPT.Add(paramObj);
db.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
_err.MessageType = "Server Error";
_err.MessageDescription = ex.Message.ToString();
return(result);
}
return(result);
}
//Delete
public bool Delete(long id)
{
OSC_ImportNPT obj = new OSC_ImportNPT();
bool result = false;
try
{
obj = this.Get(id);
if (obj != null)
{
db.NPT.Remove(obj);
db.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
_err.MessageType = "Server Error";
_err.MessageDescription = ex.Message.ToString();
return(result);
}
return(result);
}
public ActionResult DeleteConfirmed(long id)
{
#region BTSS
try
{
if (Session["role"] == null)
{
return(View("~/Views/Shared/SessionTimeout.cshtml"));
}
else if (Session["logon_user"] == null)
{
return(View("~/Views/Shared/SessionTimeout.cshtml"));
}
else if (Session["grp_id"] == null)
{
return(View("~/Views/Shared/SessionTimeout.cshtml"));
}
else
{
this.a = new _Access()
{
LogonUser = Session["logon_user"].ToString(),
Role = Session["role"].ToString(),
Group = Session["grp_id"].ToString(),
CanDelete = this._af.blAccess.CanDelete(Session["grp_id"].ToString(), module)
};
if (!this.a.CanDelete)
{
return(View("~/Views/Shared/NoAccess.cshtml"));
}
else
{
ViewBag.Access = this.a;
}
}
}
catch (Exception ex)
{
_ErrorMessage err = new _ErrorMessage();
err.MessageType = "Server Error - NPTTrackerController";
err.MessageDescription = ex.Message.ToString();
ViewBag.Error = err;
return(View("~/Views/Shared/SomethingWentWrong.cshtml"));
}
#endregion BTSS
#region Method
OSC_ImportNPT oSC_ImportNPT = this._af.blNpt.Get(id);
oSC_ImportNPT.DateUploaded = DateTime.Now;
oSC_ImportNPT.UploadedBy = a.LogonUser;
oSC_ImportNPT.IsActive = false;
bool result = this._af.blNpt.Edit(oSC_ImportNPT);
if (result == false && this._af.blNpt._err != null)
{
ViewBag.Error = this._af.blNpt._err;
return(View("~/Views/Shared/SomethingWentWrong.cshtml"));
}
#endregion Method
#region Return
ViewBag.Message = "Successfully saved!";
return(RedirectToAction("Index"));
#endregion Return
}
// GET: NptTracker/Delete/5
public ActionResult Delete(long?id)
{
#region BTSS
try
{
if (Session["role"] == null)
{
return(View("~/Views/Shared/SessionTimeout.cshtml"));
}
else if (Session["logon_user"] == null)
{
return(View("~/Views/Shared/SessionTimeout.cshtml"));
}
else if (Session["grp_id"] == null)
{
return(View("~/Views/Shared/SessionTimeout.cshtml"));
}
else
{
this.a = new _Access()
{
LogonUser = Session["logon_user"].ToString(),
Role = Session["role"].ToString(),
Group = Session["grp_id"].ToString(),
CanDelete = this._af.blAccess.CanDelete(Session["grp_id"].ToString(), module)
};
if (!this.a.CanDelete)
{
return(View("~/Views/Shared/NoAccess.cshtml"));
}
else
{
ViewBag.Access = this.a;
}
}
}
catch (Exception ex)
{
_ErrorMessage err = new _ErrorMessage();
err.MessageType = "Server Error - NPTTrackerController";
err.MessageDescription = ex.Message.ToString();
ViewBag.Error = err;
return(View("~/Views/Shared/SomethingWentWrong.cshtml"));
}
#endregion BTSS
#region Method
if (id == null)
{
_ErrorMessage err = new _ErrorMessage()
{
MessageType = "Server Error - NPTTrackerController",
MessageDescription = "Invalid use of null"
};
ViewBag.Error = err;
return(View("~/Views/Shared/SomethingWentWrong.cshtml"));
}
//get
OSC_ImportNPT oSC_ImportNPT = this._af.blNpt.Get((long)id);
//if bl npt error exist
if (this._af.blNpt._err == null)
{
ViewBag.Error = this._af.blNpt._err;
return(View("~/Views/Shared/SomethingWentWrong.cshtml"));
}
//if record not exist
if (oSC_ImportNPT == null)
{
return(View("~/Views/Shared/NotFound.cshtml"));
}
#endregion Method
#region Return
return(View(oSC_ImportNPT));
#endregion Return
}
public ActionResult Edit([Bind(Include = "NPTReportId,RepId,Activity,DateOfActivity,TimeSpent,TypeOfActivity,CreatedBy,ItemType,Path,TeamId,Month,Year,DateUploaded,UploadedBy,Source,CategoryId,SubCategoryId,IsActive")] OSC_ImportNPT oSC_ImportNPT)
{
#region BTSS
try
{
if (Session["role"] == null)
{
return(View("~/Views/Shared/SessionTimeout.cshtml"));
}
else if (Session["logon_user"] == null)
{
return(View("~/Views/Shared/SessionTimeout.cshtml"));
}
else if (Session["grp_id"] == null)
{
return(View("~/Views/Shared/SessionTimeout.cshtml"));
}
else
{
this.a = new _Access()
{
LogonUser = Session["logon_user"].ToString(),
Role = Session["role"].ToString(),
Group = Session["grp_id"].ToString(),
CanEdit = this._af.blAccess.CanEdit(Session["grp_id"].ToString(), module)
};
if (!this.a.CanEdit)
{
return(View("~/Views/Shared/NoAccess.cshtml"));
}
else
{
ViewBag.Access = this.a;
}
}
}
catch (Exception ex)
{
_ErrorMessage err = new _ErrorMessage();
err.MessageType = "Server Error - NPTTrackerController";
err.MessageDescription = ex.Message.ToString();
ViewBag.Error = err;
return(View("~/Views/Shared/SomethingWentWrong.cshtml"));
}
#endregion BTSS
#region Method
oSC_ImportNPT.Month = Convert.ToDateTime(oSC_ImportNPT.DateOfActivity).Month;
oSC_ImportNPT.Year = Convert.ToDateTime(oSC_ImportNPT.DateOfActivity).Year;
oSC_ImportNPT.DateUploaded = DateTime.Now;
oSC_ImportNPT.UploadedBy = a.LogonUser;
oSC_ImportNPT.Source = "Manual";
if (a.Role != "Admin")
{
oSC_ImportNPT.IsActive = true;
}
bool result = this._af.blNpt.Edit(oSC_ImportNPT);
if (result == false && this._af.blNpt._err != null)
{
ViewBag.Error = this._af.blNpt._err;
return(View("~/Views/Shared/SomethingWentWrong.cshtml"));
}
#endregion Method
#region Return
ViewBag.Message = "Successfully saved!";
ViewBag.TeamNptCategories = new SelectList(_af.blTeamNptCategories.GetList((long)oSC_ImportNPT.TeamId), "CategoryDesc", "CategoryDesc");
OSC_ImportNPT returnObj = this._af.blNpt.Get(oSC_ImportNPT.NPTReportId);
return(View(returnObj));
#endregion Return
}
public ActionResult Create([Bind(Include = "NPTReportId,RepId,Activity,DateOfActivity,TimeSpent,TypeOfActivity,TeamId,IsActive")] OSC_ImportNPT oSC_ImportNPT)
{
#region BTSS
try
{
if (Session["role"] == null)
{
return(View("~/Views/Shared/SessionTimeout.cshtml"));
}
else if (Session["logon_user"] == null)
{
return(View("~/Views/Shared/SessionTimeout.cshtml"));
}
else if (Session["grp_id"] == null)
{
return(View("~/Views/Shared/SessionTimeout.cshtml"));
}
else
{
this.a = new _Access()
{
LogonUser = Session["logon_user"].ToString(),
Role = Session["role"].ToString(),
Group = Session["grp_id"].ToString(),
CanAdd = this._af.blAccess.CanAdd(Session["grp_id"].ToString(), module)
};
if (!this.a.CanAdd)
{
return(View("~/Views/Shared/NoAccess.cshtml"));
}
else
{
ViewBag.Access = this.a;
}
}
}
catch (Exception ex)
{
_ErrorMessage err = new _ErrorMessage();
err.MessageType = "Server Error - NPTTrackerController";
err.MessageDescription = ex.Message.ToString();
ViewBag.Error = err;
return(View("~/Views/Shared/SomethingWentWrong.cshtml"));
}
#endregion BTSS
#region Method
oSC_ImportNPT.Month = Convert.ToDateTime(oSC_ImportNPT.DateOfActivity).Month;
oSC_ImportNPT.Year = Convert.ToDateTime(oSC_ImportNPT.DateOfActivity).Year;
oSC_ImportNPT.DateUploaded = DateTime.Now;
oSC_ImportNPT.UploadedBy = a.LogonUser;
oSC_ImportNPT.IsActive = true;
oSC_ImportNPT.Source = "Manual";
bool result = this._af.blNpt.Create(oSC_ImportNPT);
if (result == true)
{
ViewBag.Message = "Successfully saved!";
return(RedirectToAction("Index"));
}
#endregion Method
#region Return
ViewBag.Err = this._af.blNpt._err;
return(View(oSC_ImportNPT));
#endregion Return
}
public ActionResult Import([Bind(Include = "ImportId,Month,Year")] Import import,
HttpPostedFileBase bip,
HttpPostedFileBase biq,
HttpPostedFileBase biqd,
HttpPostedFileBase aiq,
HttpPostedFileBase ta,
HttpPostedFileBase npt)
{
string logon_user = Session["logon_user"].ToString();
ViewBag.Months = db.months;
ViewBag.Years = db.years;
#region "BIP"
if (bip == null || bip.ContentLength == 0)
{
ViewBag.ErrorBIP = "No file selected";
}
else
{
if (bip.FileName.EndsWith("xls") || bip.FileName.EndsWith("xlsx"))
{
string fname = Path.GetFileName(bip.FileName);
string path = Server.MapPath("~/ImportFile/" + fname);
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
bip.SaveAs(path);
ImportFiles i = new ImportFiles();
int result1 = i.ImportBIProd(path, import, DateTime.Now, logon_user);
if (result1 == 1)
{
ViewBag.MessageBIP = "Success";
}
else
{
ViewBag.ErrorBIP = "Failed";
}
}
else
{
ViewBag.ErrorBIP = "File type is incorrect";
}
}
#endregion "BIP"
#region "BIQ"
if (biq == null || biq.ContentLength == 0)
{
ViewBag.ErrorBIQ = "No file selected";
}
else
{
if (biq.FileName.EndsWith("xls") || biq.FileName.EndsWith("xlsx"))
{
string fname = Path.GetFileName(biq.FileName);
string path = Server.MapPath("~/ImportFile/" + fname);
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
biq.SaveAs(path);
ImportFiles i = new ImportFiles();
int result2 = i.ImportBIQual(path, import, DateTime.Now, logon_user);
if (result2 == 1)
{
ViewBag.MessageBIQ = "Success";
}
else
{
ViewBag.ErrorBIQ = "Failed";
}
}
else
{
ViewBag.ErrorBIQ = "File type is incorrect";
}
}
#endregion "BIQ"
#region "BIQD"
if (biqd == null || biqd.ContentLength == 0)
{
ViewBag.ErrorBIQD = "No file selected";
}
else
{
if (biqd.FileName.EndsWith("xls") || biqd.FileName.EndsWith("xlsx"))
{
string fname = Path.GetFileName(biqd.FileName);
string path = Server.MapPath("~/ImportFile/" + fname);
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
biqd.SaveAs(path);
ImportFiles i = new ImportFiles();
int result2 = i.ImportBIQualD(path, import, DateTime.Now, logon_user);
if (result2 == 1)
{
ViewBag.MessageBIQD = "Success";
}
else
{
ViewBag.ErrorBIQD = "Failed";
}
}
else
{
ViewBag.ErrorBIQD = "File type is incorrect";
}
}
#endregion "BIQD"
#region "AIQ"
if (aiq == null || aiq.ContentLength == 0)
{
ViewBag.ErrorAIQ = "No file selected";
}
else
{
if (aiq.FileName.EndsWith("xls") || aiq.FileName.EndsWith("xlsx"))
{
string fname = Path.GetFileName(aiq.FileName);
string path = Server.MapPath("~/ImportFile/" + fname);
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
aiq.SaveAs(path);
#region "EXCEL"
Excel.Application application = new Excel.Application();
Excel.Workbook workbook = application.Workbooks.Open(path);
Excel.Worksheet worksheet = workbook.ActiveSheet;
Excel.Range range = worksheet.UsedRange;
List <OSC_ImportAIQ> list = new List <OSC_ImportAIQ>();
for (int row = 2; row <= range.Rows.Count; row++)
{
OSC_ImportAIQ obj = new OSC_ImportAIQ();
obj.Agent = ((Excel.Range)range.Cells[row, 1]).Text;
obj.IntervalStaffedDuration = af.GetSecondsFormat(((Excel.Range)range.Cells[row, 2]).Text);
obj.TotalPercServiceTime = Convert.ToDouble(((Excel.Range)range.Cells[row, 3]).Text);
obj.TotalACDCalls = Convert.ToInt32(((Excel.Range)range.Cells[row, 4]).Text);
obj.ExtInCalls = Convert.ToInt32(((Excel.Range)range.Cells[row, 5]).Text);
obj.ExtInAvgActiveDur = af.GetSecondsFormat(((Excel.Range)range.Cells[row, 6]).Text);
obj.ExtOutCalls = Convert.ToInt32(((Excel.Range)range.Cells[row, 7]).Text);
obj.AvgExtOutActiveDur = af.GetSecondsFormat(((Excel.Range)range.Cells[row, 8]).Text);
obj.ACDWrapUpTime = af.GetSecondsFormat(((Excel.Range)range.Cells[row, 9]).Text);
obj.ACDTalkTime = af.GetSecondsFormat(((Excel.Range)range.Cells[row, 10]).Text);
obj.ACDRingTime = af.GetSecondsFormat(((Excel.Range)range.Cells[row, 11]).Text);
obj.Aux = af.GetSecondsFormat(((Excel.Range)range.Cells[row, 12]).Text);
obj.AvgHoldDur = af.GetSecondsFormat(((Excel.Range)range.Cells[row, 13]).Text);
obj.IntervalIdleDur = af.GetSecondsFormat(((Excel.Range)range.Cells[row, 14]).Text);
obj.Transfers = Convert.ToInt32(((Excel.Range)range.Cells[row, 15]).Text);
obj.HeldContacts = Convert.ToInt32(((Excel.Range)range.Cells[row, 16]).Text);
obj.Redirects = Convert.ToInt32(((Excel.Range)range.Cells[row, 17]).Text);
obj.Month = import.Month;
obj.Year = import.Year;
obj.DateUploaded = DateTime.Now;
obj.UploadedBy = User.Identity.Name;
list.Add(obj);
}
foreach (OSC_ImportAIQ obj in list)
{
obj.RepId = db.Representatives.Where(r => (r.AIQUserId == obj.Agent) && ((bool)r.IsCurrent)).FirstOrDefault().RepId;
obj.TeamId = db.Representatives.Where(r => (r.AIQUserId == obj.Agent) && ((bool)r.IsCurrent)).FirstOrDefault().TeamId;
db.AIQ.Add(obj);
}
try
{
db.SaveChanges();
ViewBag.MessageBIP = "Success";
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
}
catch (Exception ex)
{
ViewBag.ErrorBIP = "Error: " + ex.Message.ToString();
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
}
#endregion "EXCEL"
}
else
{
ViewBag.ErrorAIQ = "File type is incorrect";
}
}
#endregion "AIQ"
#region "TA"
if (ta == null || ta.ContentLength == 0)
{
ViewBag.ErrorTA = "No file selected";
}
else
{
if (ta.FileName.EndsWith("xls") || ta.FileName.EndsWith("xlsx"))
{
string fname = Path.GetFileName(ta.FileName);
string path = Server.MapPath("~/ImportFile/" + fname);
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
ta.SaveAs(path);
#region "EXCEL"
Excel.Application application = new Excel.Application();
Excel.Workbook workbook = application.Workbooks.Open(path);
Excel.Worksheet worksheet = workbook.ActiveSheet;
Excel.Range range = worksheet.UsedRange;
List <OSC_ImportTA> list = new List <OSC_ImportTA>();
for (int row = 2; row <= range.Rows.Count; row++)
{
OSC_ImportTA obj = new OSC_ImportTA();
obj.AssignedId = ((Excel.Range)range.Cells[row, 1]).Text;
obj.Group = ((Excel.Range)range.Cells[row, 2]).Text;
obj.FirstName = ((Excel.Range)range.Cells[row, 3]).Text;
obj.MiddleInt = ((Excel.Range)range.Cells[row, 4]).Text;
obj.LastName = ((Excel.Range)range.Cells[row, 5]).Text;
obj.CreateDateTime = ((Excel.Range)range.Cells[row, 6]).Text;
obj.BusinessArea = ((Excel.Range)range.Cells[row, 7]).Text;
obj.WorkType = ((Excel.Range)range.Cells[row, 8]).Text;
obj.Status = ((Excel.Range)range.Cells[row, 9]).Text;
obj.Queue = ((Excel.Range)range.Cells[row, 10]).Text;
obj.Suspended = ((Excel.Range)range.Cells[row, 11]).Text;
obj.SuspendDate = ((Excel.Range)range.Cells[row, 12]).Text;
obj.UnsuspendDate = ((Excel.Range)range.Cells[row, 13]).Text;
obj.LastStatusUpdate = ((Excel.Range)range.Cells[row, 14]).Text;
obj.Account = ((Excel.Range)range.Cells[row, 15]).Text;
obj.GAC = ((Excel.Range)range.Cells[row, 16]).Text;
obj.Assoc = ((Excel.Range)range.Cells[row, 17]).Text;
obj.Certificate = ((Excel.Range)range.Cells[row, 18]).Text;
obj.CheckAmount = ((Excel.Range)range.Cells[row, 19]).Text;
obj.First_Name = ((Excel.Range)range.Cells[row, 20]).Text;
obj.Last_Name = ((Excel.Range)range.Cells[row, 21]).Text;
obj.CustomerNo = ((Excel.Range)range.Cells[row, 22]).Text;
obj.ProductType = ((Excel.Range)range.Cells[row, 23]).Text;
obj.AdminSystem = ((Excel.Range)range.Cells[row, 24]).Text;
obj.CheckAmountTotal = ((Excel.Range)range.Cells[row, 25]).Text;
obj.UCIVendorMatchDate = ((Excel.Range)range.Cells[row, 26]).Text;
obj.ReasonCodeForAdv = ((Excel.Range)range.Cells[row, 27]).Text;
obj.ReasonDescription = ((Excel.Range)range.Cells[row, 28]).Text;
obj.TinSourceType = ((Excel.Range)range.Cells[row, 29]).Text;
obj.SSBusinessUnit = ((Excel.Range)range.Cells[row, 30]).Text;
obj.Month = import.Month;
obj.Year = import.Year;
obj.DateUploaded = DateTime.Now;
obj.UploadedBy = User.Identity.Name;
list.Add(obj);
}
foreach (OSC_ImportTA obj in list)
{
if (Convert.ToDateTime(obj.CreateDateTime).Month == obj.Month)
{
obj.RepId = db.Representatives.Where(r => (r.PRDUserId == obj.AssignedId) && ((bool)r.IsCurrent)).FirstOrDefault().RepId;
obj.TeamId = af.GetTeamIdByGroupId(obj.Group, "BI").TeamId;
db.TA.Add(obj);
}
}
try
{
db.SaveChanges();
ViewBag.MessageBIP = "Success";
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
}
catch (Exception ex)
{
ViewBag.ErrorBIP = "Error: " + ex.Message.ToString();
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
}
#endregion "EXCEL"
}
else
{
ViewBag.ErrorTA = "File type is incorrect";
}
}
#endregion "TA"
#region "NPT"
if (npt == null || npt.ContentLength == 0)
{
ViewBag.ErrorNPT = "No file selected";
}
else
{
if (npt.FileName.EndsWith("xls") || npt.FileName.EndsWith("xlsx"))
{
string fname = Path.GetFileName(npt.FileName);
string path = Server.MapPath("~/ImportFile/" + fname);
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
npt.SaveAs(path);
#region "EXCEL"
Excel.Application application = new Excel.Application();
Excel.Workbook workbook = application.Workbooks.Open(path);
Excel.Worksheet worksheet = workbook.ActiveSheet;
Excel.Range range = worksheet.UsedRange;
List <OSC_ImportNPT> list = new List <OSC_ImportNPT>();
for (int row = 2; row <= range.Rows.Count; row++)
{
OSC_ImportNPT obj = new OSC_ImportNPT();
obj.Activity = ((Excel.Range)range.Cells[row, 1]).Text;
obj.DateOfActivity = Convert.ToDateTime(((Excel.Range)range.Cells[row, 2]).Text);
obj.TimeSpent = Convert.ToDouble(((Excel.Range)range.Cells[row, 3]).Text) * 60;
obj.TypeOfActivity = ((Excel.Range)range.Cells[row, 4]).Text;
obj.CreatedBy = ((Excel.Range)range.Cells[row, 5]).Text;
obj.ItemType = ((Excel.Range)range.Cells[row, 6]).Text;
obj.Path = ((Excel.Range)range.Cells[row, 7]).Text;
obj.Month = import.Month;
obj.Year = import.Year;
obj.DateUploaded = DateTime.Now;
obj.UploadedBy = User.Identity.Name;
obj.Source = "Import";
list.Add(obj);
}
foreach (OSC_ImportNPT obj in list)
{
if (Convert.ToDateTime(obj.DateOfActivity).Month == obj.Month)
{
obj.RepId = db.Representatives.Where(r => (r.LastName + ", " + r.FirstName == obj.CreatedBy) &&
((bool)r.IsCurrent)).FirstOrDefault().RepId;
obj.TeamId = db.Representatives.Where(r => (r.LastName + ", " + r.FirstName == obj.CreatedBy) &&
((bool)r.IsCurrent)).FirstOrDefault().TeamId;
db.NPT.Add(obj);
}
}
try
{
db.SaveChanges();
ViewBag.MessageBIP = "Success";
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
}
catch (Exception ex)
{
ViewBag.ErrorBIP = "Error: " + ex.Message.ToString();
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
}
#endregion "EXCEL"
}
else
{
ViewBag.ErrorNPT = "File type is incorrect";
}
}
#endregion "NPT"
return(View("Index"));
}
