public JsonResult SetBilling2(string value, string Billing, DateTime date)
{
try
{
FacadeLog.MobileWriteEntry("Order/SetBilling|" + Billing);
ModelViewUserG objCred = new JavaScriptSerializer().Deserialize <ModelViewUserG>(value);
ModelViewBilling obj = new JavaScriptSerializer().Deserialize <ModelViewBilling>(Billing);
if (obj.EstimatedTipe == 2)
{
var result = FacadePolicy.SetPolicyQuotation(objCred, obj);
return(Json(result, JsonRequestBehavior.AllowGet));
}
if (obj.EstimatedTipe == 3)
{
var result = FacadePolicy.SetRefQuotation(objCred, obj);
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
var result = FacadeOrder.SetQuotation2(objCred, obj, date);
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult _DetailODSResumen(int OrderID)
{
var dataODS = FacadeOrder.Get(OrderID);
ViewBag.dataODS = dataODS;
return(PartialView());
}
public ActionResult _DetailODSNotes(int OrderID)
{
var dataODS = FacadeOrder.Get(OrderID);
var dataVisit = FacadeVisit.GetByOrderID(OrderID);
ViewBag.dataODS = dataODS;
ViewBag.dataVisit = dataVisit;
return(PartialView());
}
public ActionResult _DetailODSCP(int OrderID)
{
var dataODS = FacadeOrder.Get(OrderID);
var dataClient = FacadeClient.GetByID(dataODS.FK_ClientID);
var dataBI = FacadeInstalledBase.GetByID(dataODS.FK_InstalledBaseID);
ViewBag.dataODS = dataODS;
ViewBag.dataClient = dataClient;
return(PartialView());
}
public ActionResult _DetailODSIP(int OrderID)
{
var dataODS = FacadeOrder.Get(OrderID);
var dataInvoicing = FacadeInvoicing.GetPolicyInvoice(OrderID, "");
var dataPayment = FacadePayment.GetPaymetByType(OrderID);
ViewBag.dataODS = dataODS;
ViewBag.dataInvoicing = dataInvoicing;
ViewBag.dataPayment = dataPayment;
return(PartialView());
}
public ActionResult SetStatus_CRM(string OrderID)
{
try
{
FacadeOrder.SetStatus(OrderID);
return(Json("Solicitud procesada con éxito", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult _DetailODS(int MonitorID)
{
var dataMonitor = FacadeMonitor.Get(MonitorID);
var dataODS = FacadeOrder.Get(dataMonitor.OrderID);
var dataTecnico = FacadeEmployee.GetID(dataODS.FK_EmployeeID.Value);
ViewBag.dataODS = dataODS;
ViewBag.dataMonitor = dataMonitor;
ViewBag.dataTecnico = dataTecnico;
return(PartialView());
}
public ActionResult _ODSAssignament(int MonitorID)
{
var dataMonitor = FacadeMonitor.Get(MonitorID);
var dataODS = FacadeOrder.Get(dataMonitor.OrderID);
var dataModule = FacadeModuleService.GetAllBYModule(dataODS.FK_ModuleID.Value);
var dataTecnico = FacadeEmployee.GetID(dataODS.FK_EmployeeID.Value);
ViewBag.dataODS = dataODS;
ViewBag.dataMonitor = dataMonitor;
ViewBag.dataTecnico = dataTecnico;
ViewBag.monitorID = MonitorID;
ViewBag.dataModule = dataModule;
return(PartialView());
}
public JsonResult GetListODS(string ODS)
{
ModelViewUserVisits objCred = new JavaScriptSerializer().Deserialize <ModelViewUserVisits>(ODS);
try
{
var lt = FacadeOrder.GetListODS(objCred);
return(Json(lt, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult _DetailODSIB(int OrderID)
{
var dataODS = FacadeOrder.Get(OrderID);
var dataIB = FacadeInstalledBase.GetByID(dataODS.FK_InstalledBaseID);
var dataProduct = FacadeProduct.GetByID(dataIB.FK_ProductID.Value);
var dataShopPlace = FacadeShopPlace.Get(dataIB.FK_ShopPlaceID.Value);
ViewBag.dataODS = dataODS;
ViewBag.dataIB = dataIB;
ViewBag.dataProduct = dataProduct;
ViewBag.dataShopPlace = dataShopPlace;
return(PartialView());
}
public ActionResult SaveAsig(int Newuser, int order)
{
var datauser = FacadeEmployee.GetEmployeeByUser(Newuser);
var dataMonitor = FacadeMonitor.Get(order);
var dataODS = FacadeOrder.Get(dataMonitor.OrderID);
var EmployeeID = datauser[0].PK_EmployeeID;
var OrderID = dataODS.PK_OrderID;
FacadeOrder.SetUser(OrderID, EmployeeID);
var result = "Success";
return(Json(result));
}
public JsonResult SetOrderSecuence(string data)
{
try
{
FacadeLog.MobileWriteEntry("Order/SetOrderSecuence|" + data);
ModelViewUserSecuence Data = new JavaScriptSerializer().Deserialize <ModelViewUserSecuence>(data);
FacadeOrder.SetOrderSecuence(Data);
return(Json("Sucess"));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult _DetailODSFR(int OrderID)
{
var dataODS = FacadeOrder.Get(OrderID);
var dataRef = FacadeSparePart.GetByOrderID(OrderID);
string desc1 = "", desc2 = "", desc3 = "", desc4 = "", desc5 = "";
if (!string.IsNullOrEmpty(dataODS.Failure1))
{
desc1 = FacadeCodeFailure.GetByCodeFailure(dataODS.Failure1).Failure;
}
if (!string.IsNullOrEmpty(dataODS.Failure2))
{
desc2 = FacadeCodeFailure.GetByCodeFailure(dataODS.Failure2).Failure;
}
if (!string.IsNullOrEmpty(dataODS.Failure3))
{
desc3 = FacadeCodeFailure.GetByCodeFailure(dataODS.Failure3).Failure;
}
if (!string.IsNullOrEmpty(dataODS.Failure4))
{
desc4 = FacadeCodeFailure.GetByCodeFailure(dataODS.Failure4).Failure;
}
if (!string.IsNullOrEmpty(dataODS.Failure5))
{
desc5 = FacadeCodeFailure.GetByCodeFailure(dataODS.Failure5).Failure;
}
ViewBag.desc1 = desc1;
ViewBag.desc2 = desc2;
ViewBag.desc3 = desc3;
ViewBag.desc4 = desc4;
ViewBag.desc5 = desc5;
var dataGuranty = FacadeGuaranty.Get(dataODS.FK_GuarantyID.Value);
ViewBag.dataODS = dataODS;
ViewBag.dataRef = dataRef;
ViewBag.dataGuranty = dataGuranty;
return(PartialView());
}
public JsonResult SetOrder(string data)
{
try
{
FacadeLog.MobileWriteEntry("Order/SetOrder|" + data);
ModelViewODSMovilUploadList dataODS = new JavaScriptSerializer().Deserialize <ModelViewODSMovilUploadList>(data);
var ordens = FacadeOrder.Complete(dataODS);
ModelViewResultREST result = new ModelViewResultREST();
result.Result = "Success" + "|" + ordens;
return(Json(result));
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult SetPreOrder(string data)
{
try
{
FacadeLog.MobileWriteEntry("Order/SetPreOrder|" + data);
ModelViewPreODS dataODS = new JavaScriptSerializer().Deserialize <ModelViewPreODS>(data);
FacadeOrder.Complete(dataODS);
ModelViewResultREST result = new ModelViewResultREST();
result.Result = "Success";
return(Json(result));
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult GetValidationODS(string data)
{
try
{
FacadeLog.MobileWriteEntry(data);
ModelViewUserVisits objCred = new JavaScriptSerializer().Deserialize <ModelViewUserVisits>(data);
var result = FacadeOrder.GetReprogramingODS(objCred);
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult GetListVisit(string ListVisit)
{
ModelViewUserVisits objCred = new JavaScriptSerializer().Deserialize <ModelViewUserVisits>(ListVisit);
try
{
string Usuario = FacadeUsers.GetUserByToken(objCred.TokenUser).UserName;
FacadeLog.MobileWriteEntry(Usuario + " INICIO_DescargaODS ");
var lt = FacadeOrder.GetListOrden(objCred);
FacadeLog.MobileWriteEntry(Usuario + " FIN_DescargaODS ");
return(Json(lt, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw new Generic_Exception(ex, Generic_Exception.ErrorCodes.ErrorGoogleMaps);
}
}
public bool UpdateODS(string orderID, string EstatusEsq, string EstatusCabecera, string tokenApp, string user, string password, out Result wsResult)
{
wsResult = new Result();
try
{
FacadeOrder.UpdateStatusOrderWS(orderID, EstatusEsq, EstatusCabecera, tokenApp, user, password);
wsResult.isComplete = true;
wsResult.error = "SIN_ERROR";
wsResult.detailedError = "SIN_ERROR";
return(true);
}
catch (Exception ex)
{
wsResult.isComplete = false;
wsResult.error = ex.Message;
wsResult.detailedError = ex.StackTrace;
return(false);
}
}
public ActionResult _DetailDistance(int orderID)
{
string refMan = "8011161600000025";
var dataMonitor = FacadeMonitor.GetByOrderID(orderID);
var dataODS = FacadeOrder.Get(orderID);
var dataModule = FacadeModuleService.GetAllBYModule(dataODS.FK_ModuleID.Value);
var dataSparePart = FacadeSparePart.GetByRefManID(orderID, refMan);
if (dataSparePart == null)
{
ViewBag.Kilometres = 0;
}
else
{
ViewBag.Kilometres = dataSparePart.Quantity;
}
ViewBag.dataODS = dataODS;
ViewBag.dataMonitor = dataMonitor;
ViewBag.dataModule = dataModule;
return(PartialView());
}
public ActionResult GetList_UserTA(int monitorID)
{
var dataMonitor = FacadeMonitor.Get(monitorID);
if (dataMonitor.StatusVisitID == 1)
{
var dataODS = FacadeOrder.Get(dataMonitor.OrderID);
var dataEmployee = FacadeEmployee.GetID(dataODS.FK_EmployeeID.Value);
var dataUser = FacadeUsers.GetByID(dataEmployee.FK_UserID.Value);
var ls = FacadeUsers.GetAllUserModuleProfile(dataEmployee.FK_ModuleID, dataUser.ProfileID).Select(p => new SelectListItem()
{
Text = p.Name,
Value = p.UserID.ToString()
}
).Where(p => p.Text != dataUser.Name).ToList <SelectListItem>();
return(Json(ls, JsonRequestBehavior.AllowGet));
}
else
{
var result = "error";
return(Json(result));
}
}
public JsonResult GetString()
{
try
{
//var dataSparePart = FacadeSparePart.GetAll("9406972995");
List <string> arrFilesOK1 = new List <string>();
List <string> arrFilesOK = new List <string>(new string[] { "21022018003003ODS.xml", "21022018003003Clientes.xml", "21022018003003Fallas.xml", "21022018003003Ref_Man.xml", "21022018000102Fallas.xml", "21022018000102Ref_Man.xml", "21022018000102Clientes.xml", "21022018000102ODS.xml", "20022018194500Fallas.xml", "20022018194500Clientes.xml", "20022018194500ODS.xml", "20022018194500Ref_Man.xml", "20022018191500Clientes.xml", "20022018191500Fallas.xml", "20022018191500ODS.xml", "20022018191500Ref_Man.xml", "20022018184500Ref_Man.xml", "20022018184500Clientes.xml", "20022018184500Fallas.xml", "20022018184500ODS.xml", "20022018181500Clientes.xml", "20022018181500Fallas.xml", "20022018181500ODS.xml", "20022018181500Ref_Man.xml", "20022018180010Clientes.xml", "20022018180010Fallas.xml", "20022018180010ODS.xml", "20022018180010Ref_Man.xml", "20022018174516Fallas.xml", "20022018174516Clientes.xml", "20022018174516ODS.xml", "20022018174516Ref_Man.xml" });
List <string> Files = new List <string>(new string[] { "Fallas", "Clientes", "ODS", "Ref_Man" });
string valor = arrFilesOK.Count > 1 ? arrFilesOK[0].Substring(0, 14):null;
foreach (var item in arrFilesOK)
{
if (item.Contains(valor))
{
arrFilesOK1.Add(item);
}
}
wait(10);
string completo = "2018-01-31 17:33:55,556 [27] INFO MabeInterfaceLog - -------------------------INICIO_UpdateODS-------------------------" +
"TIPO_MENSAJE: Exito" +
"CLASE_MENSAJE: ZCRMCM_ACTUALIZACION" +
"DESCRIPCION: Campo Gratina Actualizada" +
"MENSAJE: 002" +
"------------------------ - FIN_UpdateODS------------------------ -" +
"2018 - 01 - 31 17:33:55,682[27] INFO MabeInterfaceLog --------------------------INICIO_UpdateODS------------------------ -" +
" TIPO_MENSAJE: Exito" +
" CLASE_MENSAJE: ZCRMCM_ACTUALIZACION" +
" DESCRIPCION: Campo Estatus Actualizado" +
" MENSAJE: 005" +
" ------------------------ - FIN_UpdateODS------------------------ -" +
" -------Actualizar EnvioCRM---- -" +
" Actualizo: OK" +
" OrderID: 9407097232" +
" ------------------------ - FIN Actualizar EnvioCRM-------------------------" +
" 2018 - 01 - 31 17:33:55,696[27] INFO MabeInterfaceLog --------------------------INICIO_UpdateODS------------------------ -" +
" TIPO_MENSAJE: Error" +
" CLASE_MENSAJE: ZCRMCM_ACTUALIZACION" +
" DESCRIPCION: Error al Actualizar Notas" +
"MENSAJE: 012" +
"------------------------ - FIN_UpdateODS------------------------ -" +
"2018 - 01 - 31 17:33:55,709[27] INFO MabeInterfaceLog --------------------------INICIO_UpdateODS------------------------ -" +
" TIPO_MENSAJE: Aviso" +
" CLASE_MENSAJE: ZCRMCM_ACTUALIZACION" +
" DESCRIPCION: Sin datos para Vía de pago" +
"MENSAJE: 014" +
"------------------------ - FIN_UpdateODS------------------------ - ";
var tam = completo.Length;
string MENSAJE = "No se pudo actualizar la orden 9406315491";
if (MENSAJE.Contains("No se pudo actualizar"))
{
string buscar = "orden";
int Index = MENSAJE.IndexOf(buscar);
string OrderID = MENSAJE.Substring(Index + 5).Trim();
var order = FacadeOrder.GetByOrderID(OrderID);
//NegocioOrder.Update(order);
}
string IDOrden = "Posición: 50 | Modelo: WW01F00483 | Cantidad: 4 | Estatus: E0006 |||";
string MensajeCRM = "Se creo correctamente la posición 50 de la orden 9406314934";
if (MensajeCRM.Contains("correctamente"))
{
string posicion = IDOrden.Split('|')[0].Split(':')[1].Trim();
posicion = posicion.PadLeft(10, '0');
string RefManID = IDOrden.Split('|')[1].Split(':')[1].Trim();
string Cantidad = IDOrden.Split('|')[2].Split(':')[1].Trim();
string Estatus = IDOrden.Split('|')[3].Split(':')[1].Trim();
string buscar = "orden";
int Index = MensajeCRM.IndexOf(buscar);
string substring = MensajeCRM.Substring(Index + 5).Trim();
}
return(Json("", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
static void Main(string[] args)
{
var arrODS = FacadeOrder.GetAll().Where(p => p.OrderExecuteDate.Equals(new DateTime(2017, 11, 8)));
int j = 1;
Console.WriteLine("Total: " + arrODS.Count().ToString());
foreach (var i in arrODS)
{
try
{
Console.WriteLine(j.ToString() + " de " + arrODS.Count().ToString());
var dataODS = FacadeOrder.Get(i.PK_OrderID);
var dataClient = FacadeClient.GetByID(i.FK_ClientID);
var dataBaseInstalled = FacadeInstalledBase.GetByID(dataODS.FK_InstalledBaseID);
var dataProduct = FacadeProduct.GetByID(dataBaseInstalled.FK_ProductID.Value);
var dataHistory = FacadeMabe.HistoryODSByClient(dataClient.ClientID, dataBaseInstalled.InstalledBaseID);
// insertar datos order history
foreach (var item in dataHistory)
{
var dataDBHistory = FacadeHistory.GetByOrderID(dataODS.PK_OrderID);
if (dataDBHistory.Where(p => p.OrderID == item.ID_Oper).Count() > 0)
{
// update
var entity = dataDBHistory.Where(p => p.OrderID == item.ID_Oper).FirstOrDefault();
entity.CloseDate = ParseDate(item.Fecha_Cierre_Orden);
entity.Failure1 = string.IsNullOrEmpty(item.Desc_ID_Falla1) ? "" : item.Desc_ID_Falla1;
entity.Failure2 = string.IsNullOrEmpty(item.Desc_ID_Falla2) ? "" : item.Desc_ID_Falla2;
entity.Failure3 = string.IsNullOrEmpty(item.Desc_ID_Falla3) ? "" : item.Desc_ID_Falla3;
entity.FailureID1 = string.IsNullOrEmpty(item.ID_Falla1) ? "" : item.ID_Falla1;
entity.FailureID2 = string.IsNullOrEmpty(item.ID_Falla2) ? "" : item.ID_Falla2;
entity.FailureID3 = string.IsNullOrEmpty(item.ID_Falla3) ? "" : item.ID_Falla3;
entity.FK_ClientID = dataODS.FK_ClientID;
entity.FK_InstalledBaseID = dataODS.FK_InstalledBaseID;
entity.FK_OrderID = dataODS.PK_OrderID;
entity.Guaranty = string.IsNullOrEmpty(item.Tipo_Serv) ? "" : item.Tipo_Serv;
entity.ItemStatus = string.IsNullOrEmpty(item.Estatus_Visita) ? "" : item.Estatus_Visita;
entity.ModifyDate = DateTime.UtcNow;
entity.OrderID = string.IsNullOrEmpty(item.ID_Oper) ? "" : item.ID_Oper;
entity.OrderStatus = string.IsNullOrEmpty(item.Estatus_Oper) ? "" : item.Estatus_Oper;
entity.ShopDate = new DateTime(1980, 1, 1);
entity.Status = true;
FacadeHistory.Update(entity);
}
else
{
// insert
var entity = new EntityHistory();
entity.CloseDate = ParseDate(item.Fecha_Cierre_Orden);
entity.CreateDate = DateTime.UtcNow;
entity.Failure1 = string.IsNullOrEmpty(item.Desc_ID_Falla1) ? "" : item.Desc_ID_Falla1;
entity.Failure2 = string.IsNullOrEmpty(item.Desc_ID_Falla2) ? "" : item.Desc_ID_Falla2;
entity.Failure3 = string.IsNullOrEmpty(item.Desc_ID_Falla3) ? "" : item.Desc_ID_Falla3;
entity.FailureID1 = string.IsNullOrEmpty(item.ID_Falla1) ? "" : item.ID_Falla1;
entity.FailureID2 = string.IsNullOrEmpty(item.ID_Falla2) ? "" : item.ID_Falla2;
entity.FailureID3 = string.IsNullOrEmpty(item.ID_Falla3) ? "" : item.ID_Falla3;
entity.FK_ClientID = dataODS.FK_ClientID;
entity.FK_InstalledBaseID = dataODS.FK_InstalledBaseID;
entity.FK_OrderID = dataODS.PK_OrderID;
entity.Guaranty = string.IsNullOrEmpty(item.Tipo_Serv) ? "" : item.Tipo_Serv;
entity.ItemStatus = string.IsNullOrEmpty(item.Estatus_Visita) ? "" : item.Estatus_Visita;
entity.ModifyDate = DateTime.UtcNow;
entity.OrderID = string.IsNullOrEmpty(item.ID_Oper) ? "" : item.ID_Oper;
entity.OrderStatus = string.IsNullOrEmpty(item.Estatus_Oper) ? "" : item.Estatus_Oper;
entity.PK_HistoryID = 0;
entity.ShopDate = new DateTime(1980, 1, 1);
entity.Status = true;
FacadeHistory.Insert(entity);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace);
}
j++;
}
//Inventory();
//RestImage();
//SendEmial();
//foreach (TimeZoneInfo z in TimeZoneInfo.GetSystemTimeZones())
// Console.WriteLine(z.Id);
//Console.WriteLine(FacadeGoogle.GetLocalDateTime(19.3850, -99.1650, DateTime.UtcNow));
//string CLIENT_ID = "6538892993478012";
//string CLIENT_SECRET = "GGGzSZuzfdBDpua7g7wyZo9qiTrnTvcS";
//MP mp = new MP(CLIENT_ID, CLIENT_SECRET);
//Hashtable data = mp.getPaymentInfo("9406314591T0170101000525SFODS");
// Sets the filters you want
//Dictionary<String, String> filters = new Dictionary<String, String>();
//filters.Add("site_id", "MLM"); // Argentina: MLA; Brasil: MLB
// Search payment data according to filters
//Hashtable searchResult = mp.searchPayment(filters);
// Show payment information
//foreach (Hashtable payment in searchResult.SelectToken("response.results"))
//{
// Console.WriteLine(String.Format("{0}", payment["collection"]["id"]));
//}
Console.WriteLine("Finish");
Console.ReadKey();
}
public ActionResult GetList_Address(string OrderID)
{
var ls = FacadeOrder.GetList_Address(OrderID);
return(Json(ls, JsonRequestBehavior.AllowGet));
}
