public async System.Threading.Tasks.Task <string> SaleMemberOrderStepDown(int id)
{
using (PFCSqlEntities db = new PFCSqlEntities())
{
TblExtGroup selectedExtGroup = db.TblExtGroup.Where(eg => eg.TblExtGrID == id).FirstOrDefault();
if (selectedExtGroup != null)
{
var list = db.TblExtGroup.Where(eg => eg.TblExtGrGroupID == 1).OrderBy(ex => ex.TblExtGrRow).ToList();
if (list.Count == 1 || selectedExtGroup.TblExtGrRow == list.Select(xe => xe.TblExtGrRow).Max())
{
return("false");
}
TblExtGroup nextExtGroup = db.TblExtGroup.Where(eg => eg.TblExtGrRow > selectedExtGroup.TblExtGrRow).OrderBy(ex => ex.TblExtGrRow).FirstOrDefault();
if (nextExtGroup == null)
{
return("false");
}
int nextRow = nextExtGroup.TblExtGrRow;
int selRow = selectedExtGroup.TblExtGrRow;
nextExtGroup.TblExtGrRow = selRow;
selectedExtGroup.TblExtGrRow = nextRow;
db.SaveChanges();
await ApplyAgents(1);
return("true");
}
else
{
return("false");
}
}
}
public async System.Threading.Tasks.Task <string> SaleMemberOrderStepFirst(int id)
{
using (PFCSqlEntities db = new PFCSqlEntities())
{
TblExtGroup selectedExtGroup = db.TblExtGroup.Where(eg => eg.TblExtGrID == id).FirstOrDefault();
if (selectedExtGroup != null)
{
var list = db.TblExtGroup.Where(eg => eg.TblExtGrGroupID == 1).OrderBy(ex => ex.TblExtGrRow).ToList();
if (list.Count == 1 || selectedExtGroup.TblExtGrRow == list.Select(xe => xe.TblExtGrRow).Min())
{
return("false");
}
selectedExtGroup.TblExtGrRow = 1;
db.SaveChanges();
int counter = 2;
foreach (var item in list)
{
if (item != selectedExtGroup)
{
item.TblExtGrRow = counter;
db.SaveChanges();
counter += 1;
}
}
await ApplyAgents(1);
return("true");
}
else
{
return("false");
}
}
}
public async System.Threading.Tasks.Task <ActionResult> SaleMemberList(IEnumerable <string> ExtensionList)
{
using (PFCSqlEntities db = new PFCSqlEntities())
{
foreach (var selectedExtension in ExtensionList)
{
int selectedExtensionNumber =
Convert.ToInt32(selectedExtension.Substring(0, selectedExtension.IndexOf(":")));
string selectedExtensionName = selectedExtension.Substring((selectedExtension.IndexOf(":") + 1), (selectedExtension.Length - (selectedExtension.IndexOf(":") + 1)));
TblExtensions selectedExtensionDb = db.TblExtensions.Where(ex => ex.TblExtName == selectedExtensionName && ex.TblExtNumber == selectedExtensionNumber).FirstOrDefault();
if (selectedExtensionDb == null)
{
TblExtensions newExtensions = new TblExtensions();
newExtensions.TblExtNumber = selectedExtensionNumber;
newExtensions.TblExtName = selectedExtensionName;
db.TblExtensions.Add(newExtensions);
db.SaveChanges();
TblExtGroup newExtGroup = new TblExtGroup();
newExtGroup.TblExtGrExtID = newExtensions.TblExtID;
newExtGroup.TblExtGrGroupID = 1;
newExtGroup.TblExtGrRow = (db.TblExtGroup.Where(te => te.TblExtGrGroupID == 1).Select(teg => teg.TblExtGrRow).DefaultIfEmpty().Max() + 1);
db.TblExtGroup.Add(newExtGroup);
db.SaveChanges();
}
}
List <TblExtensions> extensionListDb = db.TblExtensions.ToList();
foreach (var extensionDb in extensionListDb)
{
Boolean result = false;
string selectedExtension = extensionDb.TblExtNumber.ToString() + ":" + extensionDb.TblExtName;
foreach (var item in ExtensionList)
{
if (item == selectedExtension)
{
result = true;
}
}
if (result == false)
{
db.TblExtensions.Remove(extensionDb);
db.SaveChanges();
}
}
// ApiExecuter Ex = new ApiExecuter();
//string res = Ex.EditQueueOperatorsRestApi("5000", ExtensionList).Result;
//if (res == "true")
//{
await ApplyAgents(1);
return(RedirectToAction("SaleMemberList"));
//}
//var extensionList = await Ex.GetExtensionListRestApi();
//ViewBag.ExtensionList = new SelectList(extensionList.Select(el => new
//{
// Idd = "شماره داخلی : " + el.Extension.ToString() + " - نام اوپراتور : " + el.Name,
// id = el.Extension.ToString() + ":" + el.Name
//}).ToList(), "id", "idd");
//return View();
}
}