public ActionResult CreateAppointment(int QuotationID = 0)
{
QuotationDTO quotation = BusinessLayer.BusinessStore.Quotation.GetQuotationByID(QuotationID);
ViewBag.WorkersList = BusinessLayer.BusinessStore.Worker.GetAllWorkers();
return(View(quotation));
}
public ActionResult AdvanceReceipt(int quotationID = 0)
{
ViewBag.QuotationID = quotationID;
QuotationDTO quotation = BusinessLayer.BusinessStore.Quotation.GetQuotationByID(quotationID);
return(View(quotation));
}
public static List <AppointmentDTO> GetAllAppointments()
{
try
{
List <AppointmentDTO> lstAppointment = new List <AppointmentDTO>();
var lstAppointmentsFromDB = db.Manali_Appointment_GetAllAppointments();
foreach (var item in lstAppointmentsFromDB)
{
QuotationDTO quotation = new QuotationDTO
{
QuotationID = item.QuotationID,
DateOfWedding = item.DateOfWedding.Value,
NameOfBride = item.Bride,
BrideAddress = item.BrideAddress,
BrideEmail = item.BrideEmail,
DateOfHomecoming = item.DateOfHomecoming.Value,
NameOfGroom = item.Groom,
GroomAddress = item.GroomAddress,
GroomContactNo = item.GroomContactNo,
createdDate = item.CreatedDate.Value
};
WorkerDTO worker = new WorkerDTO
{
WorkerID = item.WorkerID,
Name = item.Name,
NIC = item.NIC,
Mobile = item.Mobile,
Address = item.Address,
Image = item.Image,
Designation = item.Designation
};
AppointmentDTO appointment = new AppointmentDTO
{
AppointmentID = item.AppointmentID,
Quotation = quotation,
AppointmentDateTime = item.AppointmentDateTime.Value,
ResponsibleWorker = worker,
IsBrideVisited = item.IsBrideVisited.Value,
Duration = item.Duration.Value,
Notes = item.Notes,
Status = item.Status.Value
};
lstAppointment.Add(appointment);
}
return(lstAppointment);
}
catch (Exception ex)
{
}
return(null);
}
public static WorkerDTO GetQuotationsMarketedByWorker(int WorkerID)
{
try
{
var WorkerFromDatabase = db.Manali_Worker_GetWorkerByID(WorkerID).FirstOrDefault();
if (WorkerFromDatabase != null)
{
WorkerDTO worker = new WorkerDTO
{
WorkerID = WorkerFromDatabase.WorkerID,
Name = WorkerFromDatabase.Name,
NIC = WorkerFromDatabase.NIC,
Mobile = WorkerFromDatabase.Mobile,
Address = WorkerFromDatabase.Address,
Designation = WorkerFromDatabase.Designation,
Image = WorkerFromDatabase.Image,
ListOfMarketedQuotations = new List <QuotationDTO>(),
ListOfSuccessfullQuotations = new List <QuotationDTO>()
};
List <QuotationDTO> lstQuotationsMarketedByWorker = new List <QuotationDTO>();
var QuotationsMarketedByWorkerFromDatabase = db.Manali_Worker_GetAllQuotationsByWorkerID(WorkerID);
foreach (var item in QuotationsMarketedByWorkerFromDatabase)
{
QuotationDTO quotation = new QuotationDTO
{
QuotationID = item.QuotationID,
DateOfWedding = item.DateOfWedding.Value,
NameOfBride = item.Bride,
BrideAddress = item.BrideAddress,
BrideEmail = item.BrideEmail,
BrideContactNo = item.BrideContactNo,
DateOfHomecoming = item.DateOfHomecoming.Value,
NameOfGroom = item.Groom,
GroomAddress = item.GroomAddress,
GroomContactNo = item.GroomContactNo
};
worker.ListOfMarketedQuotations.Add(quotation);
if (item.EventID != null)
{
worker.ListOfSuccessfullQuotations.Add(quotation);
}
}
return(worker);
}
}
catch (Exception ex)
{
}
return(null);
}
public ActionResult EditQuotation(int quotationID = 0)
{
ViewBag.WorkerList = BusinessLayer.BusinessStore.Worker.GetAllWorkers();
List <QuotationItemDTO> lstQuotationItemList = BusinessLayer.BusinessStore.Quotation.GetQuotationitemList();
QuotationDTO Quotation = BusinessLayer.BusinessStore.Quotation.GetQuotationByID(quotationID);
ViewBag.Quotation = Quotation;
return(View(lstQuotationItemList));
}
public static QuotationDTO MapToQuotationDTO(ConfigurationDTO configurationDTO)
{
var result = new QuotationDTO()
{
Cliente = configurationDTO.Cliente,
TipoSeguro = configurationDTO.TipoSeguro
};
return(result);
}
public static QuotationDTO GetQuotaionDetails(int QuotationID)
{
try
{
var QuotationResult = db.Manali_Quotation_SelectAQuotation(QuotationID).SingleOrDefault();
var SelectedItems = db.Manali_Quotation_SelectQuotationSelectedItems(QuotationID);
WorkerDTO marketer = new WorkerDTO
{
WorkerID = QuotationResult.WorkerID,
Name = QuotationResult.Name,
NIC = QuotationResult.NIC,
Mobile = QuotationResult.Mobile,
Address = QuotationResult.Address,
Designation = QuotationResult.Designation,
Image = QuotationResult.Image
};
QuotationDTO Quotation = new QuotationDTO
{
QuotationID = QuotationResult.QuotationID,
DateOfWedding = QuotationResult.DateOfWedding.Value,
NameOfBride = QuotationResult.Bride,
BrideAddress = QuotationResult.BrideAddress,
BrideEmail = QuotationResult.BrideEmail,
BrideContactNo = QuotationResult.BrideContactNo,
DateOfHomecoming = QuotationResult.DateOfHomecoming.Value,
NameOfGroom = QuotationResult.Groom,
GroomAddress = QuotationResult.GroomAddress,
GroomContactNo = QuotationResult.GroomContactNo,
marketedBy = marketer
};
List <QuotationItemDTO> lstQuotationItems = new List <QuotationItemDTO>();
foreach (var item in SelectedItems)
{
QuotationItemDTO quotationItem = new QuotationItemDTO
{
ItemID = item.ItemID.Value
};
lstQuotationItems.Add(quotationItem);
}
Quotation.SelectedItem = lstQuotationItems;
return(Quotation);
}
catch (Exception)
{
throw;
}
}
public static bool SaveQuotationDetails(ref QuotationDTO quotation)
{
try
{
return(DataAccessLayer.Datastore.QuotationDataStore.SaveQuotation(ref quotation));
}
catch (Exception)
{
throw;
}
}
public static AppointmentDTO GetAppointmentDetailsByID(int AppointID)
{
try
{
var item = db.Manali_Appointment_GetAppointmentDetailsByID(AppointID).FirstOrDefault();
QuotationDTO quotation = new QuotationDTO
{
QuotationID = item.QuotationID,
DateOfWedding = item.DateOfWedding.Value,
NameOfBride = item.Bride,
BrideAddress = item.BrideAddress,
BrideEmail = item.BrideEmail,
DateOfHomecoming = item.DateOfHomecoming.Value,
NameOfGroom = item.Groom,
GroomAddress = item.GroomAddress,
GroomContactNo = item.GroomContactNo,
createdDate = item.CreatedDate.Value
};
WorkerDTO worker = new WorkerDTO
{
WorkerID = item.WorkerID,
Name = item.Name,
NIC = item.NIC,
Mobile = item.Mobile,
Address = item.Address,
Image = item.Image,
Designation = item.Designation
};
AppointmentDTO appointment = new AppointmentDTO
{
AppointmentID = item.AppointmentID,
Quotation = quotation,
AppointmentDateTime = item.AppointmentDateTime.Value,
ResponsibleWorker = worker,
IsBrideVisited = item.IsBrideVisited.Value,
Duration = item.Duration.Value,
Notes = item.Notes,
Status = item.Status.Value
};
return(appointment);
}
catch (Exception ex)
{
}
return(null);
}
public static bool SaveQuotation(ref QuotationDTO quotation)
{
try
{
string selectedItems = "";
foreach (var item in quotation.SelectedItem)
{
if (selectedItems == "")
{
selectedItems = item.ItemID.ToString();
}
else
{
selectedItems = item.ItemID + "," + selectedItems;
}
}
int?quotationID = 0;
db.Manali_Quotation_SaveQuotation(
quotation.DateOfWedding,
quotation.NameOfBride,
quotation.BrideAddress,
quotation.BrideEmail,
quotation.BrideContactNo,
quotation.DateOfHomecoming,
quotation.NameOfGroom,
quotation.GroomAddress,
quotation.GroomContactNo,
selectedItems,
quotation.createdBy.userID,
quotation.marketedBy.WorkerID,
ref quotationID
);
if (quotationID != null && quotationID != 0)
{
quotation.QuotationID = quotationID.Value;
}
return(true);
}
catch (Exception)
{
throw;
}
}
public static List <ReceiptDTO> GetAllReceipts()
{
List <ReceiptDTO> lstReceiptList = new List <ReceiptDTO>();
try
{
var lstReceiptListFromDB = db.Manali_Receipt_GetAllReceipts();
foreach (var item in lstReceiptListFromDB)
{
QuotationDTO quotation = new QuotationDTO
{
QuotationID = item.QuotationID,
DateOfWedding = item.DateOfWedding.Value,
NameOfBride = item.Bride,
BrideAddress = item.BrideAddress,
BrideEmail = item.BrideEmail,
BrideContactNo = item.BrideContactNo,
DateOfHomecoming = item.DateOfHomecoming.Value,
NameOfGroom = item.Groom,
GroomAddress = item.GroomAddress,
GroomContactNo = item.GroomContactNo,
};
ReceiptDTO receipt = new ReceiptDTO
{
ReceiptID = item.ReceiptID,
ReceiptDate = item.ReceiptDate.Value,
MagNo = item.MagNo,
Section = item.Section,
FunctionTime = item.FunctionTime.Value,
IsGoingAwayIncluded = item.IsGoingAwayIncluded.Value,
PayerName = item.PayerName,
AccountOf = item.AccountOf,
Payment = item.Payment.Value,
CashOrCheckNo = item.CashOrCheckNo,
Quotation = quotation
};
lstReceiptList.Add(receipt);
}
}
catch (Exception)
{
}
return(lstReceiptList);
}
public static List <QuotationDTO> GetAllQuotations()
{
try
{
var QuotationList = db.Manali_Quotation_GetAllQuotation();
List <QuotationDTO> lstQuotations = new List <QuotationDTO>();
foreach (var item in QuotationList)
{
WorkerDTO marketer = new WorkerDTO
{
WorkerID = item.WorkerID,
Name = item.Name,
NIC = item.NIC,
Mobile = item.Mobile,
Address = item.Address,
Designation = item.Designation,
Image = item.Image
};
QuotationDTO quotation = new QuotationDTO
{
QuotationID = item.QuotationID,
DateOfWedding = item.DateOfWedding.Value,
NameOfBride = item.Bride,
BrideAddress = item.BrideAddress,
BrideEmail = item.BrideEmail,
BrideContactNo = item.BrideContactNo,
DateOfHomecoming = item.DateOfHomecoming.Value,
NameOfGroom = item.Groom,
GroomAddress = item.GroomAddress,
GroomContactNo = item.GroomContactNo,
marketedBy = marketer
};
lstQuotations.Add(quotation);
}
return(lstQuotations);
}
catch (Exception)
{
throw;
}
}
public static ReceiptDTO GetReceiptByID(int ReceiptID)
{
try
{
var ReceiptObject = db.Manali_Receipt_GetReceiptByID(ReceiptID).FirstOrDefault();
if (ReceiptObject != null)
{
QuotationDTO quotation = new QuotationDTO
{
QuotationID = ReceiptObject.QuotationID,
DateOfWedding = ReceiptObject.DateOfWedding.Value,
NameOfBride = ReceiptObject.Bride,
BrideAddress = ReceiptObject.BrideAddress,
BrideEmail = ReceiptObject.BrideEmail,
BrideContactNo = ReceiptObject.BrideContactNo,
DateOfHomecoming = ReceiptObject.DateOfHomecoming.Value,
NameOfGroom = ReceiptObject.Groom,
GroomAddress = ReceiptObject.GroomAddress,
GroomContactNo = ReceiptObject.GroomContactNo,
};
ReceiptDTO receipt = new ReceiptDTO
{
ReceiptID = ReceiptObject.ReceiptID,
ReceiptDate = ReceiptObject.ReceiptDate.Value,
MagNo = ReceiptObject.MagNo,
Section = ReceiptObject.Section,
FunctionTime = ReceiptObject.FunctionTime.Value,
IsGoingAwayIncluded = ReceiptObject.IsGoingAwayIncluded.Value,
PayerName = ReceiptObject.PayerName,
AccountOf = ReceiptObject.AccountOf,
Payment = ReceiptObject.Payment.Value,
CashOrCheckNo = ReceiptObject.CashOrCheckNo,
Quotation = quotation
};
return(receipt);
}
}
catch (Exception e)
{
}
return(null);
}
public ActionResult Create(QuotationDTO quotation)
{
try
{
if (!ModelState.IsValid)
{
return(View());
}
// TODO: Add insert logic here
quotationRepository.InsertQuotation(iMapper.Map <QuotationDTO, Quotation>(quotation));
return(RedirectToAction("Index"));
}
catch (Exception exception)
{
ModelState.AddModelError("", "Error when add quotation" + exception.Message);
return(View());
}
}
// Rediseñar el algoritmo para enviar el modelo de cotizacion de acuerdo a los parametros de Odoo
public bool createInERP(QuotationDTO quotation)
{
//var odooCredentials = new OdooConnectionCredentials("https://deltacargo-deltaqa-646890.dev.odoo.com", "deltacargo-deltaqa-646890", "*****@*****.**", "delta011235813");
//var odooApi = new OdooAPI(odooCredentials);
var modelXML = new XmlRpcStruct();
modelXML["name"] = quotation.company_name;
modelXML["contact_name"] = quotation.name;
modelXML["email_from"] = quotation.email_from;
modelXML["phone"] = quotation.phone;
modelXML["city"] = quotation.routeCityOrigin;
var routeOriginModel = (RouteDTO)routeRepository.getById(quotation.idMacroRouteOrigin.GetValueOrDefault());
if (!isNull(routeOriginModel))
{
int[] ids = odooApi.Search("res.country", new object[1] {
new object[] { "name", "=", routeOriginModel.name }
});
List <XmlRpcStruct> countriesTuples = odooApi.Read("res.country", ids, new object[] { })
.ToList()
.Cast <XmlRpcStruct>()
.ToList();
if (countriesTuples.Count > 0)
{
modelXML["country_id"] = countriesTuples[0]["id"];
/*modelXML["country_id"] = new object[1] { new object[] { countriesTuples[0]["id"], countriesTuples[0]["name"]} };*/
}
}
// arreglar para obtener el nombre del pais
modelXML["street"] = quotation.street;
modelXML["kanban_state"] = quotation.kanban_state; //"grey"; // [grey, red]
modelXML["type"] = quotation.type; //"lead";
modelXML["description"] = quotation.description;
int idObjCreated = odooApi.Create("crm.lead", modelXML);
return(idObjCreated > 0); // analizar la respuesta
}
public JsonResult SaveQuotation(QuotationDTO quotation, string selectedItems)
{
bool result = true;
string[] selectedItemIDs = selectedItems.Split(',');
List <QuotationItemDTO> lstQuotationItems = new List <QuotationItemDTO>();
foreach (string item in selectedItemIDs)
{
int ItemID = 0;
if (int.TryParse(item, out ItemID))
{
QuotationItemDTO QuotationItem = new QuotationItemDTO
{
ItemID = ItemID
};
lstQuotationItems.Add(QuotationItem);
}
}
quotation.SelectedItem = lstQuotationItems;
quotation.createdBy = new UserDTO {
userID = 10
};
result = BusinessLayer.BusinessStore.Quotation.SaveQuotationDetails(ref quotation);
ActionDetailsDTO actionDetails = new ActionDetailsDTO {
Status = result == true ? 1 : 0,
Content = quotation.QuotationID.ToString()
};
return(Json(actionDetails, JsonRequestBehavior.AllowGet));
}
public ActionResultApi <QuotationDetailsViewDTO> create([FromBody] QuotationDTO quotation)
{
return(new ActionResultApi <QuotationDetailsViewDTO>(HttpStatusCode.OK, quotationDAL.create(quotation), Request));
}
public QuotationDetailsViewDTO create(QuotationDTO quotation)
{
// registrar solicitud de cotizacion en azure db
var quotationCreated = (QuotationDTO)quotationRepository.create(quotation);
// obtener la afiliacion origen de la cotizacion
var associatedAffiliation = (MembershipDTO)membershipRepository.getById(quotation.id_membership.GetValueOrDefault());
QuotationDetailsViewDTO quotationDetails = default;
quotationDetails = new QuotationDetailsViewDTO
{
name = quotation.name,
company = quotation.company_name,
phone = quotation.phone,
email = quotation.email_from,
serviceType = serviceTypeMembershipRepository.getById(quotation.idServiceType, includes: "TipoServicio").TipoServicio.servicio,
comment = quotation.comment
};
switch (quotationDetails.serviceType)
{
case "Transporte Urbano en SCZ":
// sin campo en particular
break;
case "Almacenamiento de Carga en SCZ":
quotationDetails.storageCapacity = $"{quotation.storageCapacity} {((UnitMeasurementDTO)unitMeasurementRepository.getById(quotation.idUmStorageCapacity.GetValueOrDefault())).abbreviation}.";
quotationDetails.storageTime = $"{quotation.storageTime} {((UnitMeasurementDTO)unitMeasurementRepository.getById(quotation.idUmStorageTime.GetValueOrDefault())).abbreviation}.";;
break;
case "Transporte Nacional":
quotationDetails.cityOrigin = quotation.routeCityOrigin;
quotationDetails.cityDestination = quotation.routeCityDestination;
break;
case "Transporte Internacional":
quotationDetails.countryOrigin = ((RouteDTO)routeRepository.getById(quotation.idMacroRouteOrigin.GetValueOrDefault())).name;
quotationDetails.cityOrigin = quotation.routeCityOrigin;
quotationDetails.countryDestination = ((RouteDTO)routeRepository.getById(quotation.idMacroRouteDestination.GetValueOrDefault())).name;
quotationDetails.cityDestination = quotation.routeCityDestination;
break;
case "Ruta Urbana SCZ":
quotationDetails.street = quotation.street;
break;
default:
break;
}
if (!quotationDetails.serviceType.Equals("Almacenamiento de Carga en SCZ"))
{
quotationDetails.loadWeight = $"{quotation.loadWeight} Tn.";
quotationDetails.loadVolume = $"{quotation.loadVolume} m3";
}
switch (associatedAffiliation.company)
{
case "Delta Cargo SRL": // registrar solicitud de cotizacion en ERP Odoo
quotation.kanban_state = "grey";
quotation.type = "lead";
// Crear el View Model para registrar el campo "internal notes" en oodo
quotation.description = getDescriptionQuotationWithFormat(quotationDetails);
quotationRepository.createInERP(quotation);
break;
case "Delta Express": // solo se debe registrar en DeltaDB
break;
default:
break;
}
return(quotationDetails);
}
