public ActionResult Create(Reception rcpt)
{
ViewBag.receptionID = new SelectList(db.Receptions, "receptionID", "receptionNumara");
db.Receptions.Add(rcpt);
db.SaveChanges();
return(RedirectToAction("Index", "AdminReception"));
}
public void CreateOrUpdate(ReceptionBindingModel model)
{
using (var context = new SchoolAgainDatabase())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
Reception element = model.Id.HasValue ? null : new Reception();
if (model.Id.HasValue)
{
element = context.Receptions.FirstOrDefault(rec => rec.Id ==
model.Id);
if (element == null)
{
throw new Exception("Элемент не найден");
}
element.ClientId = model.ClientId;
element.DateCreate = model.DateCreate;
element.TotalSum = model.TotalSum;
element.ReceptionStatus = model.ReceptionStatus;
context.SaveChanges();
}
else
{
element.ClientId = model.ClientId;
element.DateCreate = model.DateCreate;
element.TotalSum = model.TotalSum;
element.ReceptionStatus = model.ReceptionStatus;
context.Receptions.Add(element);
context.SaveChanges();
var groupServices = model.ReceptionServices
.GroupBy(rec => rec.ServiceId)
.Select(rec => new
{
ServiceId = rec.Key,
Count = rec.Sum(r => r.Count)
});
foreach (var groupService in groupServices)
{
context.ReceptionServices.Add(new ReceptionService
{
ReceptionId = element.Id,
ServiceId = groupService.ServiceId,
Count = groupService.Count
});
context.SaveChanges();
}
}
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
throw;
}
}
}
}
public ReceptionComposite(DbDataRecord rec)
{
Reception = new Reception(rec);
Shedule = new Shedule(rec);
Doctor = new Doctor(rec);
Patient = new Patient(rec);
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Name,FirstName,UserId,ClientId,Status")] Reception reception)
{
if (id != reception.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(reception);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ReceptionExists(reception.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ClientId"] = new SelectList(_context.Clients, "Id", "Id", reception.ClientId);
return(View(reception));
}
public ReceptionComposite()
{
Reception = new Reception();
Shedule = new Shedule();
Doctor = new Doctor();
Patient = new Patient();
}
public async Task <ActionResult <int> > SaveReception(ReceptionModel receptionModel)
{
var reception = new Reception
{
ReceivedBy = receptionModel.ReceivedBy
};
_db.Receptions.Attach(reception);
await _db.SaveChangesAsync();
foreach (var item in receptionModel.ReceptionItems)
{
var purchaseItem = _db.PurchaseItems.FirstOrDefault(x => x.EAN == item.EAN);
purchaseItem.ReceptionId = reception.Id;
purchaseItem.ReceivedActualWeight = item.ReceivedActualWeight;
purchaseItem.ReceivedCrates = item.ReceivedCrates;
purchaseItem.ReceivedCratesWeight = item.ReceivedCratesWeight;
purchaseItem.ReceivedDateUtc = DateTime.Now;
purchaseItem.ReceivedFruitGradeType = item.ReceivedFruitGradeType;
purchaseItem.ReceivedNotes = item.ReceivedNotes;
purchaseItem.ReceivedTotalWeight = item.ReceivedTotalWeight;
_db.PurchaseItems.Update(purchaseItem);
}
;
await _db.SaveChangesAsync();
// In the background, send push notifications if possible
//var subscription = await _db.NotificationSubscriptions.Where(e => e.UserId == GetUserId()).SingleOrDefaultAsync();
//if (subscription != null)
//{
// _ = TrackAndSendNotificationsAsync(reception, subscription);
//}
return(reception.Id);
}
public AddNewReception(Reception reception = null)
{
DataContext = new AddNewReceptionViewModel(reception);
UnitOfWork unitOfWork = new UnitOfWork();
var patients = unitOfWork.Patients.GetAll().ToList();
var doctors = unitOfWork.Doctors.GetAll().ToList();
var services = unitOfWork.Services.GetAll().ToList();
List <string> patientsName = new List <string>();
List <string> doctorsName = new List <string>();
List <string> servicesName = new List <string>();
InitializeComponent();
foreach (var i in doctors)
{
doctorsName.Add(i.LastName);
}
foreach (var i in patients)
{
patientsName.Add(i.LastName);
}
foreach (var i in services)
{
servicesName.Add(i.Name);
}
docList.ItemsSource = doctorsName;
patList.ItemsSource = patientsName;
serList.ItemsSource = servicesName;
}
public void TestInit()
{
hotel = new Hotel();
hotelRooms = new List <Room>();
simplePath = new SimplePath();
person = new Customer();
person.Route = new Stack <Node>();
person2 = new Customer();
person2.Route = new Stack <Node>();
cleaner = new Cleaner();
persons = new List <IPerson>();
customers = new List <Customer>()
{
person,
person2,
};
cleaners = new List <Cleaner>
{
cleaner
};
persons.Add(cleaner);
persons.Add(person);
persons.Add(person2);
reception = new Reception();
lobby = new Lobby();
stairs = new Stairs();
eventChecker = new EventChecker();
}
public async Task <IActionResult> PutReception(int id, Reception reception)
{
if (id != reception.ReceptionId)
{
return(BadRequest());
}
_context.Entry(reception).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ReceptionExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
private void Reception_TextChanged_1(object sender, EventArgs e)
{
//文本框选中的起始点在最后
Reception.SelectionStart = Reception.TextLength;
//将控件内容滚动到当前插入符号位置
Reception.ScrollToCaret();
}
void Modify()
{
if (m_pwd == "")
{
DialogBase.Show("Modify Password", "Invalid password(NULL).");
return;
}
if (m_npwd != m_npwd2)
{
DialogBase.Show("Modify Password", "Your new and confirm passwords\n are different, Please retry.");
return;
}
if (m_npwd == "")
{
DialogBase.Show("Modify Password", "Invalid new password(NULL).");
return;
}
m_pwdMD5 = Tools.GetMD5(m_pwd);
m_npwdMD5 = Tools.GetMD5(m_npwd);
Reception recp = GameObject.Find("Reception").GetComponent <Reception>();
recp.ModifyPassword(m_pwdMD5, m_npwdMD5, AfterModifyPassword);
}
public Reception ReceptionByScheduleAndTime(int schedule, DateTime time)
{
Reception reception = new Reception();
_connection.Open();
string sql = String.Format("select * from reception join (schedules join (doctors join specialities on speciality = speciality_id) on doctor = doctor_id) on schedule = schedule_id where schedule = {0} and reception_time = '{1}'", schedule, time.ToString("HH:mm:ss"));
var cmd = new NpgsqlCommand(sql, _connection);
NpgsqlDataReader npgSqlDataReader = cmd.ExecuteReader();
if (npgSqlDataReader.HasRows)
{
foreach (DbDataRecord dbDataRecord in npgSqlDataReader)
{
reception = new Reception(dbDataRecord);
}
}
else
{
reception = new Reception
{
Patient = null,
Shedule = schedule,
Time = time
};
}
_connection.Close();
return(reception);
}
private void cbTypeSample_EditValueChanged(object sender, EventArgs e)
{
// --- init methods
if (cbTypeSample.EditValue != null)
{
Reception oReception = new Reception();
var query =
(from m in oReception.GetMethodsDenominations(cbTypeSample.EditValue.ToString())
select new
{
Idtemplate_method = Convert.ToInt32(m.Idtemplate_method),
Title = m.Cod_template_method + " - " + m.Abbreviation + " - " + m.Title
}).ToList();
cbMethodAdd.Properties.DataSource = query;
cbMethodAdd.Properties.DisplayMember = "Title";
cbMethodAdd.Properties.ValueMember = "Idtemplate_method";
if (cbTypeSample.EditValue != null)
{
tabItems.PageVisible = true;
}
}
}
void Register()
{
if (m_email == "")
{
DialogBase.Show("REGISTER EMAIL", "INVALID EMAIL(NULL).");
return;
}
string expression = @"^([\w-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)" + @"|(([\w-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$";
if (!System.Text.RegularExpressions.Regex.IsMatch(m_email, expression))
{
DialogBase.Show("REGISTER EMAIL", "INVALID EMAIL ADDRESS.");
return;
}
if (m_pwd != m_pwd2)
{
DialogBase.Show("REGISTER EMAIL", "YOUR NEW AND CONFIRM PASSWORDS\n ARE DIFFERENT, PLEASE RETRY.");
return;
}
if (m_pwd == "")
{
DialogBase.Show("REGISTER EMAIL", "INVALID PASSWORD(NULL).");
return;
}
m_pwdMD5 = Tools.GetMD5(m_pwd);
Reception recp = GameObject.Find("Reception").GetComponent <Reception>();
recp.RegisterByEmail(m_email, m_pwdMD5, AfterRegisterByEmail);
}
// GET: Guests
public async Task <IActionResult> GuestEatenToday()
{
var guest = await _context.Guests.ToListAsync();
var guests = from s in _context.Guests
select s;
var receptions = new List <Reception>();
foreach (var g in guest)
{
if (!receptions.Exists(x => x.Room == g.RoomNr) && g.Date.Date == DateTime.Today && g.Checked == true)
{
var r = new Reception(g.RoomNr, 0, 0);
receptions.Add(r);
}
}
foreach (var r in receptions)
{
r.NrAdults = guest.Where(g => g.AgeStatus == "Adult" && g.RoomNr == r.Room && g.Date.Date == DateTime.Today && g.Checked == true).Count();
r.NrChildren = guest.Where(g => g.AgeStatus == "Child" && g.RoomNr == r.Room && g.Date.Date == DateTime.Today && g.Checked == true).Count();
}
return(View(receptions));
}
private static Root Parse(XmlDocument xml)
{
XmlNode rootNode = xml.SelectSingleNode("/root");
XmlNode currencyNode = rootNode.FirstChild;
XmlNodeList receptionNodeList = currencyNode.ChildNodes;
List <Reception> receptions = new List <Reception>();
foreach (XmlNode receptionNode in receptionNodeList)
{
XmlNodeList handNodeList = receptionNode.ChildNodes;
List <Hand> hands = new List <Hand>();
foreach (XmlNode handNode in handNodeList)
{
Hand hand = new Hand(handNode.Attributes["violent"].Value, handNode.Attributes["privilege"].Value,
handNode.Attributes["obese"].Value, handNode.InnerText);
hands.Add(hand);
}
Reception reception = new Reception(receptionNode.Attributes["koran"].Value,
receptionNode.Attributes["restriction"].Value, receptionNode.Attributes["pay"].Value,
receptionNode.Attributes["tiger"].Value, hands);
receptions.Add(reception);
}
Currency currency = new Currency(currencyNode.Attributes["requirement"].Value, currencyNode.Attributes["fraud"].Value, currencyNode.Attributes["sugar"].Value, currencyNode.Attributes["player"].Value, currencyNode.Attributes["capitalism"].Value, currencyNode.Attributes["undermine"].Value, currencyNode.Attributes["birthday"].Value, receptions);
List <Currency> currencies = new List <Currency> {
currency
};
return(new Root(currencies));
}
public void Load()
{
listReception.Clear();
using (var db = new AutoDataContext())//load values into listbox
{
var query = from item in db.Reception
join patient in db.Patient on item.patientid equals patient.id
orderby item.dateNext
select new
{
id = item.id,
patient = patient,
fio = patient.lastName + " " + patient.firstName + " " + patient.middleName,
cost = item.cost,
dateNext = item.dateNext,
completedWork = item.completedWork
}
;
var arr = query.ToArray();
foreach (var record in arr)
{
Reception lst = new Reception(record.id
, record.fio
, record.cost
, record.dateNext
, record.completedWork
);
listReception.Add(lst);
}
}
}
void AfterModifyFriend()
{
// 增加删除好友
Reception recp = GameObject.Find("Reception").GetComponent <Reception>();
recp.GetFriends(UpdateRelateUI);
}
public ReceptionModel(Reception db)
{
Id = db.Id;
Time = db.Time;
Patient = db.Patient;
Shedule = db.Shedule;
}
static void Main(string[] args)
{
List <HeadPhone> db = new List <HeadPhone>
{
new HeadPhone(0, "Xiaomi Piston 3", 3, false),
new HeadPhone(1, "Beats Solo2 Wireless", 1, false),
new HeadPhone(2, "Marshall Major II", 6, false)
};
Service compToCopy = new Service(db);
Controller compController = new Controller(compToCopy);
Reception compReception = new Reception(compToCopy, compController);
compReception.MakeOrder("Sony SBH70", 3);
compReception.MakeOrder("Philips SHE3590", 1);
compReception.MakeOrder("Fiio F9 Pro", 6);
compReception.Display();
compReception.Check(5, 6);
Console.ReadKey();
}
static void Main(string[] args)
{
Suite royal = new Suite(1, 50);
Guest jack = new Guest(337859034, "jack");
Reception.CheckIn(jack);
Reception.CheckOut(royal);
}
public ActionResult Edit(int id, Reception form)
{
if (ModelState.IsValid)
{
_repo.Update(id, form);
}
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(Guid id)
{
Reception reception = db.Reception.Find(id);
db.Reception.Remove(reception);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IActionResult Reception(Reception reception)
{
_context.Receptions.Add(reception);
// сохраняем в бд все изменения
_context.SaveChanges();
return(RedirectToAction("СomRec", reception));
}
private void ReceptionDetail()
{
Reception rec = (Reception)dataGridViewReceptions.SelectedRows[0].DataBoundItem;
FormReceptionDetail formDetail = new FormReceptionDetail();
formDetail.SetReception(rec.ReceptionId);
formDetail.ShowDialog();
}
public ActionResult Edit(Reception rcpt, int receptionID)
{
var resepsiyonlar = db.Receptions.Where(u => u.receptionID == receptionID).SingleOrDefault();
resepsiyonlar.receptionNumara = rcpt.receptionNumara;
db.SaveChanges();
return(RedirectToAction("Index", "AdminReception", new { keepID = resepsiyonlar.receptionID }));
}
public IActionResult EditReception(Reception reception)
{
if (ModelState.IsValid)
{
db.Update(reception);
return(RedirectToAction("Index"));
}
return(View());
}
static void Main(string[] args)
{
Reception.Rooms[0] = new FamilyRoom(1, 0);
Reception.Rooms[1] = new RoomForTwo(2, 0);
Reception.Rooms[2] = new Suite(3, 0);
Guest shaul = new Guest(1, "shaul");
Reception.CheckIn(shaul);
}
public ActionResult Create(int id, Reception form)
{
if (ModelState.IsValid)
{
form.UtilisateurId = SessionManager.Utilisateur.UtilisateurId;
form.ArticleId = id;
_repo.Insert(form);
}
return(RedirectToAction("Index"));
}
// Start is called before the first frame update
void Start()
{
if (canvas == null)
{
Debug.LogError("❌ Canvas not set on ReceptionUI !");
}
reception = GetComponentInParent <Reception>();
SetState(State.Hidden);
}
private void btNewFile_Click(object sender, EventArgs e)
{
BindingList<CDocAttach> ListGroupAttachFile = gcAttachFile.DataSource as BindingList<CDocAttach>;
// --- add a new file to list
string next_filename = "";
int next_file_order = 0;
Reception oReception = new Reception();
//oReception.GetNextFileName(ref next_filename, ref next_file_order);
CDocAttach oDocAttach = new CDocAttach();
oDocAttach.Iddocument_recep = 0;
oDocAttach.Idrecep_sample_attach = 0;
oDocAttach.Idrecep_sample = oRecep_sample.Idrecep_sample;
oDocAttach.Name_file = next_filename;
oDocAttach.Order_file = next_file_order;
oDocAttach.Source_path = ofdRecepFileAttach.FileName;
oDocAttach.Attach_status = 1; // C:en creacion, A:adjuntado(bd)
ListGroupAttachFile.Add(oDocAttach);
gcAttachFile.DataSource = ListGroupAttachFile;
lstItemsSelAttach.Add(gvReception.GetSelectedCells());
gvReception.ClearSelection();
}
void filteringMethods()
{
// --- filtering the list of methods
string codTypeSample = "";
if (cbTypeSample.EditValue != null)
codTypeSample = cbTypeSample.EditValue.ToString(); //gvReception.GetFocusedRowCellValue(gcRec_Type_Sample).ToString();
List<CTemplate_method> lstTemplate_method = gcMethods.DataSource as List<CTemplate_method>;
Reception oReception = new Reception();
gcMethods.DataSource = oReception.GetMethodsDenominations(codTypeSample);
gvMethods.BestFitColumns();
}
void CopyAndSaveFile(string source_file_name)
{
try
{
BusinessLayer.Modules.Authorization oAuthorization = new Authorization();
Reception oReception = new Reception();
System.IO.FileInfo fInfo = new System.IO.FileInfo(source_file_name);
string next_file_name = "";
int next_file_order = 0;
oReception.GetNextFileName(ref next_file_name, ref next_file_order);
string name_file = String.Format("{0}{1}", next_file_name, fInfo.Extension);
string destiny_file = System.IO.Path.Combine(Path_file_methods, name_file);
if (!System.IO.Directory.Exists(Path_file_methods))
System.IO.Directory.CreateDirectory(Path_file_methods);
// To copy a file to another location and
// overwrite the destination file if it already exists.
System.IO.File.Copy(source_file_name, destiny_file, true);
}
catch (Exception ex)
{
ComunForm.Send_message(this.Text, TypeMsg.error, ex.Message);
}
}
void InitDatatable()
{
CRecep_sample_detailFactory faRecep_Sample_Detail = new CRecep_sample_detailFactory();
Reception oReception = new Reception();
DTReceptionDetail = oReception.GetReceptionDetail(-1);
gcReception.DataSource = DTReceptionDetail;
CRecep_sample_detail_elemFactory faRecep_Sample_Detail_Elem = new CRecep_sample_detail_elemFactory();
DTReceptionDetailElem = oReception.GetReceptionDetailElem(-1);
}
void InitDataControls()
{
deReception.DateTime = DateTime.Now;
deHourReception.EditValue = DateTime.Now;
// --- init client combo
CCompanyFactory faCompany = new CCompanyFactory();
cbCompany.Properties.DataSource = faCompany.GetAll();
cbCompany.Properties.ValueMember = "Idcompany";
cbCompany.Properties.DisplayMember = "Business_name";
// --- init element combo
CElementFactory faElement = new CElementFactory();
lstElement = faElement.GetAll();
lstElement.Insert(0, new CElement { Idelement = -1, Cod_element = "Seleccionar" });
var elementQuery = from table in lstElement
select new CItemGenericCombo
{
codigo = table.Idelement.ToString(),
descripcion = table.Cod_element
};
// --- init type sample combo
CType_sampleFactory faType_Sample = new CType_sampleFactory();
cbTypeSample.Properties.DataSource = faType_Sample.GetAll();
cbTypeSample.Properties.ValueMember = "Cod_type_sample";
cbTypeSample.Properties.DisplayMember = "Name_type_sample";
// --- init description combo
CDescription_sampleFactory faDescrition_Sample = new CDescription_sampleFactory();
repDescription.DataSource = faDescrition_Sample.GetAll();
repDescription.ValueMember = "Cod_des_sample";
repDescription.DisplayMember = "Description";
// --- init anio
CSerieFactory faSerie = new CSerieFactory();
Reception oReception = new Reception();
// --- init status report
repStatusReport.DataSource = Comun.ListStatusReport;
repStatusReport.ValueMember = "IdStatus";
repStatusReport.DisplayMember = "Den_Status";
// --- init status attach
repAttach_status.DataSource = oReception.GetAttachStatus();
repAttach_status.DisplayMember = "Name_status";
repAttach_status.ValueMember = "Id";
repPerson_type.DataSource = oReception.GetLstPersonType();
repPerson_type.DisplayMember = "Name";
repPerson_type.ValueMember = "Id";
}
private void repProgramButton_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
// --- save partial or final report
if (e.Button.Index == 0)
{
#region save program
bool result_insert_program = false;
CRecep_sample_program oRecep_sample_program = new CRecep_sample_program();
CRecep_sample_programFactory faRecep_sample_program = new CRecep_sample_programFactory();
Reception oReception = new Reception();
oRecep_sample_program = faRecep_sample_program.GetByPrimaryKey(
new CRecep_sample_programKeys(Convert.ToInt64(gvProgram.GetFocusedRowCellValue(gcRep_idrecep_sample_report))));
short report_status = Convert.ToInt16(gvReport.GetFocusedRowCellValue(gcRep_report_status));
// si es un reporte en creación poner como reservado
if (report_status == Convert.ToInt16(Comun.ReportStatus.EnCreacion)) // --- creacion
{
oRecep_sample_program = new CRecep_sample_program();
gvReport.SetFocusedRowCellValue(gcProg_Program_status, Convert.ToInt16(Comun.ReportStatus.Reportado));
oRecep_sample_program.Idrecep_sample = oRecep_sample.Idrecep_sample;
oRecep_sample_program.Idrecep_sample_program = Convert.ToInt64(gvProgram.GetFocusedRowCellValue(gcProg_Idrecep_sample_program));
oRecep_sample_program.Order_report = Convert.ToInt16(gvProgram.GetFocusedRowCellValue(gcProg_Order_report));
oRecep_sample_program.Program_status = Convert.ToInt16(Comun.ReportStatus.Reportado);
oRecep_sample_program.Cod_recep_sample_program = oReception.GetNewCodProgram();
oRecep_sample_program.Date_report = Convert.ToDateTime(gvProgram.GetFocusedRowCellValue(gcProg_Date_report));
oRecep_sample_program.Time_report = Convert.ToDateTime(gvProgram.GetFocusedRowCellValue(gcProg_Time_report));
result_insert_program = faRecep_sample_program.Insert(oRecep_sample_program);
gvProgram.SetFocusedRowCellValue(gcProg_Program_status, oRecep_sample_program.Program_status);
gvProgram.SetFocusedRowCellValue(gcProg_Idrecep_sample_program, oRecep_sample_program.Idrecep_sample_program);
gvProgram.SetFocusedRowCellValue(gcProg_Cod_recep_sample_program, oRecep_sample_program.Cod_recep_sample_program);
gvProgram.SetFocusedRowCellValue(gcProg_Str_cod_recep_sample_program, oReception.GetFormatProgramCode(oRecep_sample_program.Cod_recep_sample_program));
if (result_insert_program)
{
// --- create the partial report
List<CPositionValueProgram> lstPositionValueProgram = new List<CPositionValueProgram>();
foreach (GridCell[] cells in lstItemsSelProgram)
{
foreach (GridCell cell in cells)
{
CTagInfoMethod tagMethod = (CTagInfoMethod)cell.Column.Tag;
int idtemplate_method = tagMethod.IDTemplate_method;
long idrecep_sample_detail = Convert.ToInt64(gvReception.GetRowCellValue(cell.RowHandle, gcRec_idrecep_sample_detail));
long idrecep_sample_program = oRecep_sample_program.Idrecep_sample_program;
CPositionValueProgram position = GetObjectPositionProgram(idrecep_sample_detail, tagMethod.IDTemplate_method);
CCells_programFactory faCells_reported = new CCells_programFactory();
CCells_program oCell_program = new CCells_program();
oCell_program.Idtemplate_method = idtemplate_method;
oCell_program.Idrecep_sample_detail = idrecep_sample_detail;
oCell_program.Idrecep_sample_program = idrecep_sample_program;
oCell_program.Idrecep_sample_detail_elem = position.idrecep_sample_detail_elem;
bool result_cell_reported = false;
if (!(result_cell_reported = faCells_reported.Update(oCell_program)))
result_cell_reported = faCells_reported.Insert(oCell_program);
if (result_cell_reported)
{
position.idrecep_sample_program = idrecep_sample_program;
position.row = cell.RowHandle;
position.col = cell.Column;
position.idcell_program = oCell_program.Idcell_reported;
position.color = Comun.ColorRojo;
if (!lstPositionValueProgram.Exists(c => c.idrecep_sample_detail_elem == position.idrecep_sample_detail_elem))
lstPositionValueProgram.Add(position);
}
}
}
lstItemsSelProgram.Clear();
DicCellsSaveProgram.Add(Convert.ToInt32(oRecep_sample_program.Order_report), lstPositionValueProgram);
}
}
#endregion
lstItemsSelProgram.Clear();
gvReception.Focus();
}
}
private void repReportOption_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
// --- save partial or final report
if (e.Button.Index == 0)
{
// --- report data
#region save report
bool result_report = false;
CRecep_sample_report oRecep_sample_report = new CRecep_sample_report();
CRecep_sample_reportFactory faRecep_sample_report = new CRecep_sample_reportFactory();
Reception oReception = new Reception();
oRecep_sample_report = faRecep_sample_report.GetByPrimaryKey(
new CRecep_sample_reportKeys(Convert.ToInt64(gvReport.GetFocusedRowCellValue(gcRep_idrecep_sample_report))));
short report_status = Convert.ToInt16(gvReport.GetFocusedRowCellValue(gcRep_report_status));
// si es un reporte en creación poner como reservado
if (report_status == Convert.ToInt16(Comun.ReportStatus.EnCreacion)) // --- creacion
{
oRecep_sample_report = new CRecep_sample_report();
gvReport.SetFocusedRowCellValue(gcRep_report_status, Convert.ToInt16(Comun.ReportStatus.Reportado));
oRecep_sample_report.Idrecep_sample = oRecep_sample.Idrecep_sample;
oRecep_sample_report.Idrecep_sample_report = Convert.ToInt64(gvReport.GetFocusedRowCellValue(gcRep_idrecep_sample_report));
oRecep_sample_report.Order_report = Convert.ToInt16(gvReport.GetFocusedRowCellValue(gcRep_order_report));
oRecep_sample_report.Report_status = Convert.ToInt16(Comun.ReportStatus.Reportado);
oRecep_sample_report.Type_report = Convert.ToInt16(gvReport.GetFocusedRowCellValue(gcRep_type_report)); // --- 1:parcial, 2:final
oRecep_sample_report.Cod_recep_sample_report = oReception.GetNewCodReport(Convert.ToInt16(gvReport.GetFocusedRowCellValue(gcRep_type_report)));
oRecep_sample_report.Date_report = DateTime.Now;
oRecep_sample_report.Time_report = DateTime.Now;
result_report = faRecep_sample_report.Insert(oRecep_sample_report);
gvReport.SetFocusedRowCellValue(gcRep_idrecep_sample_report, oRecep_sample_report.Idrecep_sample_report);
gvReport.SetFocusedRowCellValue(gcRep_cod_recep_sample_report, oRecep_sample_report.Cod_recep_sample_report);
gvReport.SetFocusedRowCellValue(gcRep_Str_cod_recep_sample_report, oReception.GetFormatReportCode(oRecep_sample_report.Type_report, oRecep_sample_report.Cod_recep_sample_report));
if (result_report)
{
// --- create the partial report
List<CPositionValue> lstPositionValue = new List<CPositionValue>();
foreach (GridCell[] cells in lstItemsSelReport)
{
foreach (GridCell cell in cells)
{
CTagInfoMethod tagMethod = (CTagInfoMethod)cell.Column.Tag;
int idtemplate_method = tagMethod.IDTemplate_method;
long idrecep_sample_detail = Convert.ToInt64(gvReception.GetRowCellValue(cell.RowHandle, gcRec_idrecep_sample_detail));
long idrecep_sample_report = oRecep_sample_report.Idrecep_sample_report;
CPositionValue position = GetObjectPosition(idrecep_sample_detail, tagMethod.IDTemplate_method);
CCells_reportedFactory faCells_reported = new CCells_reportedFactory();
CCells_reported oCell_reported = new CCells_reported();
oCell_reported.Idtemplate_method = idtemplate_method;
oCell_reported.Idrecep_sample_detail = idrecep_sample_detail;
oCell_reported.Idrecep_sample_report = idrecep_sample_report;
oCell_reported.Idrecep_sample_detail_elem = position.idrecep_sample_detail_elem;
bool result_cell_reported = false;
if (!(result_cell_reported = faCells_reported.Update(oCell_reported)))
result_cell_reported = faCells_reported.Insert(oCell_reported);
if (result_cell_reported)
{
position.idrecep_sample_report = idrecep_sample_report;
position.row = cell.RowHandle;
position.col = cell.Column;
position.idcell_reported = oCell_reported.Idcell_reported;
if (oRecep_sample_report.Type_report == 1)
position.color = Partial_report_color;
else
position.color = Final_report_color;
if (!lstPositionValue.Exists(c => c.idrecep_sample_detail_elem == position.idrecep_sample_detail_elem))
lstPositionValue.Add(position);
}
}
}
lstItemsSelReport.Clear();
DicCellsSavedReport.Add(Convert.ToInt16(oRecep_sample_report.Order_report), lstPositionValue);
GetUnreportData(oRecep_sample.Idrecep_sample);
}
}
#endregion
lstItemsSelReport.Clear();
gvReception.Focus();
}
else if (e.Button.Index == 1)
{
// --- INFORME DE ENSAYO LAS-13-01299
CReportTestFactory faReportTest = new CReportTestFactory();
DataTable dtResults = faReportTest.GetReportResults(Convert.ToInt64(gvReport.GetFocusedRowCellValue(gcRep_idrecep_sample_report)));
DataTable dtHead = faReportTest.GetReportHead(Convert.ToInt64(gvReport.GetFocusedRowCellValue(gcRep_idrecep_sample_report)));
DataTable dtMethods = faReportTest.GetReportMethods(Convert.ToInt64(gvReport.GetFocusedRowCellValue(gcRep_idrecep_sample_report)));
oFastReportMethods.AddParameter("Attention", GetContactAttention(oRecep_sample.Idrecep_sample));
oFastReportMethods.AddParameter("Cod_report", gvReport.GetFocusedRowCellValue(gcRep_Str_cod_recep_sample_report).ToString());
oFastReportMethods.AddParameter("Date_report", Convert.ToDateTime(gvReport.GetFocusedRowCellValue(gcRep_Date_report)));
oFastReportMethods.ReportName = "ReportTest.frx";
oFastReportMethods.RegisterDataTable(dtHead, "Head");
oFastReportMethods.RegisterDataTable(dtMethods, "Methods");
oFastReportMethods.RegisterDataTable(dtResults, "Results");
oFastReportMethods.ShowPreviewReport();
}
else if (e.Button.Index == 2)
{
CReportTestFactory faReportTest = new CReportTestFactory();
DataTable dtResults = faReportTest.GetReportResults(Convert.ToInt64(gvReport.GetFocusedRowCellValue(gcRep_idrecep_sample_report)));
DataTable dtHead = faReportTest.GetReportHead(Convert.ToInt64(gvReport.GetFocusedRowCellValue(gcRep_idrecep_sample_report)));
DataTable dtMethods = faReportTest.GetReportMethods(Convert.ToInt64(gvReport.GetFocusedRowCellValue(gcRep_idrecep_sample_report)));
oFastReportMethods.AddParameter("Attention", GetContactAttention(oRecep_sample.Idrecep_sample));
oFastReportMethods.AddParameter("Cod_report", gvReport.GetFocusedRowCellValue(gcRep_Str_cod_recep_sample_report).ToString());
oFastReportMethods.AddParameter("Date_report", Convert.ToDateTime(gvReport.GetFocusedRowCellValue(gcRep_Date_report)));
oFastReportMethods.ReportName = "ReportTest.frx";
oFastReportMethods.RegisterDataTable(dtHead, "Head");
oFastReportMethods.RegisterDataTable(dtMethods, "Methods");
oFastReportMethods.RegisterDataTable(dtResults, "Results");
oFastReportMethods.DesignReport();
}
}
void RetrieveRegisterReception()
{
// --- return date of recep_sample
DicCellsSavedReport.Clear();
DicCellsSaveProgram.Clear();
Reception oReception = new Reception();
if (oRecep_sample != null)
{
tpRightReports.PageVisible = true;
tpRightAttach.PageVisible = true;
tpRightProgram.PageVisible = true;
txIdrecep_sample.Text = oRecep_sample.Idrecep_sample.ToString();
statusRegReception = StatusRegRecep.reg_recep_saved;
tbCod_recep_sample.Text = oRecep_sample.Cod_recep_sample;
deReception.DateTime = Convert.ToDateTime(oRecep_sample.Date_reception);
deHourReception.EditValue = Convert.ToDateTime(oRecep_sample.Date_reception);
deResult.DateTime = Convert.ToDateTime(oRecep_sample.Date_result);
deHourResult.EditValue = Convert.ToDateTime(oRecep_sample.Date_result);
cbTypeSample.EditValue = oRecep_sample.Cod_type_sample;
tbNumDays.Value = Convert.ToDecimal(Convert.ToDateTime(oRecep_sample.Date_result).Subtract(Convert.ToDateTime(oRecep_sample.Date_reception)).TotalDays);
tbSubTotalAmount.Text = oRecep_sample.Total_amount.ToString();
tbTotalIgv.Text = oRecep_sample.Total_igv.ToString();
tbTotalAmount.Text = oRecep_sample.Total_amount_igv.ToString();
tbAmortization.Text = oRecep_sample.Amortization.ToString();
if (oRecep_sample.Amortization.Value == 0)
tbResidue.BackColor = Color.Coral;
CCompany oCompany = new CCompanyFactory().GetByPrimaryKey(new CCompanyKeys(Convert.ToInt16(oRecep_sample.Idcompany)));
// --- retrieve dispatch
CRecep_sample_dispatch oRecep_sample_dispatch = new CRecep_sample_dispatchFactory().GetByPrimaryKey(new CRecep_sample_dispatchKeys(oRecep_sample.Idrecep_sample));
if (oRecep_sample_dispatch != null)
{
// --- person
if (oRecep_sample_dispatch.Dispatch_person > 0)
ckDispatchPerson.Checked = true;
else
ckDispatchPerson.Checked = false;
// --- curier
if (oRecep_sample_dispatch.Dispatch_curier > 0)
ckDispatchCurier.Checked = true;
else
ckDispatchCurier.Checked = false;
// --- transport
if (oRecep_sample_dispatch.Dispatch_transport > 0)
ckDispatchTransport.Checked = true;
else
ckDispatchTransport.Checked = false;
// --- fax
if (oRecep_sample_dispatch.Dispatch_fax > 0)
ckDispatchFax.Checked = true;
else
ckDispatchFax.Checked = false;
}
else
{
ckDispatchPerson.Checked = false;
ckDispatchCurier.Checked = true;
ckDispatchTransport.Checked = false;
ckDispatchFax.Checked = false;
}
// --- return date of client
if (oCompany != null)
{
IDCompany = oCompany.Idcompany;
cbCompany.EditValue = oCompany.Idcompany;
tbClientRuc.Text = oCompany.Ruc;
tbClientPhone.Text = oCompany.Phone_client;
tbClientDomicile.Text = oCompany.Domicile;
// --- get contacts
gcContact.DataSource = new BindingList<CContact>(oReception.GetLstContactsByRecep(oRecep_sample.Idrecep_sample));
// --- return recep_sample_detail
CRecep_sample_detail oRecep_sample_detail = new CRecep_sample_detail();
CRecep_sample_detailFactory faRecep_sample_detail = new CRecep_sample_detailFactory();
DTReceptionDetail = oReception.GetReceptionDetail(oRecep_sample.Idrecep_sample);
gcReception.DataSource = DTReceptionDetail;
// --- return columns
List<CTemplate_method> lstTemplate_method = oReception.GetReceptionElem(oRecep_sample.Idrecep_sample);
// --- modify the dictionary show columns
if (loadData != LoadData.FromRR_ToExtendRR)
{
foreach (CTemplate_method oTemplate_method in lstTemplate_method)
AddColumn(oTemplate_method.Cod_template_method);
// --- get columns and value cells
GetSampleByElems();
}
// ==================< Retrieve report groups >==============================================
gcReport.DataSource = oReception.GetRecep_sample_report(oRecep_sample.Idrecep_sample);
CCells_reportedFactory faCells_reported = new CCells_reportedFactory();
for (int i = 0; i < gvReport.RowCount; i++)
{
long idrecep_sample_report = Convert.ToInt64(gvReport.GetRowCellValue(i, gcRep_idrecep_sample_report));
short order = Convert.ToInt16(gvReport.GetRowCellValue(i, gcRep_order_report));
Color color = dicColorReport[Convert.ToInt16(gvReport.GetRowCellValue(i, gcRep_report_status))];
List<CCells_reported> lstRsder = faCells_reported.GetAll().Where(x=> x.Idrecep_sample_report == idrecep_sample_report).ToList();
List<CPositionValue> lstPositionValue = new List<CPositionValue>();
foreach (CCells_reported item in lstRsder)
{
if (item.Idrecep_sample_report == idrecep_sample_report)
{
CPositionValue oPosition = new CPositionValue();
oPosition = GetObjectPosition(Convert.ToInt64(item.Idrecep_sample_detail_elem), Convert.ToInt32(item.Idtemplate_method));
oPosition.idtemplate_method = Convert.ToInt32(item.Idtemplate_method);
oPosition.idrecep_sample_report = Convert.ToInt64(item.Idrecep_sample_report);
oPosition.idrecep_sample_detail = Convert.ToInt64(item.Idrecep_sample_detail);
oPosition.idrecep_sample_detail_elem = Convert.ToInt64(item.Idrecep_sample_detail_elem);
oPosition.idcell_reported = Convert.ToInt64(item.Idcell_reported);
if (Convert.ToInt16(gvReport.GetRowCellValue(i, gcRep_type_report)) == 1)
oPosition.color = Partial_report_color;
else
oPosition.color = Final_report_color;
lstPositionValue.Add(oPosition);
}
}
DicCellsSavedReport.Add(order, lstPositionValue);
}
// ==================< Unreport data >======================================================
GetUnreportData(oRecep_sample.Idrecep_sample);
// ==================< Retrieve attach files >==============================================
gcAttachFile.DataSource = new BindingList<CDocAttach>(oReception.GetLstDocAttach(oRecep_sample.Idrecep_sample));
CCells_attach_fileFactory faCells_attach_file = new CCells_attach_fileFactory();
for (int i = 0; i < gvAttachFile.RowCount; i++)
{
long idrecep_sample_attach = Convert.ToInt64(gvAttachFile.GetRowCellValue(i, gcAtt_Idrecep_sample_attach));
short order = Convert.ToInt16(gvAttachFile.GetRowCellValue(i, gcAtt_Order_file));
Color color = dicColorAttach[Convert.ToInt16(gvAttachFile.GetRowCellValue(i, gcAtt_Attach_status))];
List<CCells_attach_file> lstRsder = oReception.GetLstCellsAttachFile(idrecep_sample_attach);
List<CpositionValueAttach> lstPositionValue = new List<CpositionValueAttach>();
foreach (CCells_attach_file item in lstRsder)
{
if (item.Idrecep_sample_attach == idrecep_sample_attach)
{
CpositionValueAttach oPosition = new CpositionValueAttach();
oPosition = GetObjectPositionAttach(Convert.ToInt64(item.Idrecep_sample_detail_elem), Convert.ToInt32(item.Idtemplate_method));
oPosition.idrecep_sample_detail_elem = Convert.ToInt64(item.Idrecep_sample_detail_elem);
oPosition.idtemplate_method = Convert.ToInt32(item.Idtemplate_method);
oPosition.color = color;
lstPositionValue.Add(oPosition);
}
}
DicCellsSavedAttach.Add(order, lstPositionValue);
}
// ==================< Retrieve program >==============================================
gcProgram.DataSource = oReception.GetRecep_sample_program(oRecep_sample.Idrecep_sample);
CCells_programFactory faCells_program = new CCells_programFactory();
for (int i = 0; i < gvProgram.RowCount; i++)
{
long idrecep_sample_program = Convert.ToInt64(gvProgram.GetRowCellValue(i, gcProg_Idrecep_sample_program));
short order = Convert.ToInt16(gvProgram.GetRowCellValue(i, gcProg_Order_report));
Color color = Comun.ColorRojo;
List<CCells_program> lstProgram = oReception.GetLstCellsProgram(idrecep_sample_program);
List<CPositionValueProgram> lstPositionValueProgram = new List<CPositionValueProgram>();
foreach (CCells_program item in lstProgram)
{
if (item.Idrecep_sample_program == idrecep_sample_program)
{
CPositionValueProgram oPosition = new CPositionValueProgram();
oPosition = GetObjectPositionProgram(Convert.ToInt64(item.Idrecep_sample_detail_elem), Convert.ToInt32(item.Idtemplate_method));
oPosition.idrecep_sample_program = Convert.ToInt64(item.Idrecep_sample_program);
oPosition.idrecep_sample_detail_elem = Convert.ToInt64(item.Idrecep_sample_detail_elem);
oPosition.idrecep_sample_detail = Convert.ToInt64(item.Idrecep_sample_detail);
oPosition.idtemplate_method = Convert.ToInt32(item.Idtemplate_method);
oPosition.color = color;
lstPositionValueProgram.Add(oPosition);
}
}
DicCellsSaveProgram.Add(order, lstPositionValueProgram);
}
}
SortColumnsByCodTemplate();
}
else
{
///No existe un registro de recepción, entonces recuperar todo vacio
// --- hide tappages
tpRightReports.PageVisible = false;
tpRightAttach.PageVisible = false;
tpRightProgram.PageVisible = false;
// --- return empty report
CRecep_sample_reportFactory faRecep_sample_report = new CRecep_sample_reportFactory();
gcReport.DataSource = oReception.GetRecep_sample_report(0);
// --- return empty attach files
gcAttachFile.DataSource = new BindingList<CDocAttach>(oReception.GetLstDocAttach(0));
// --- recuperar contactos
if (cbCompany.EditValue != null)
gcContact.DataSource = new BindingList<CContact>(oReception.GetLstContactsByCompany(Convert.ToInt16(cbCompany.EditValue)));
}
}
//Ensures a singleton is set
void SingletonCheck()
{
if (singleton == null) {
singleton = this;
Staff.staffDepartmentHead = new List<StaffMember>();
Staff.staffHotelServices = new List<StaffMember>();
Staff.staffFrontDesk = new List<StaffMember>();
Staff.staffFoodAndBeverages = new List<StaffMember>();
Staff.staffConference = new List<StaffMember>();
Staff.staffOthers = new List<StaffMember>();
}
}
private void Show_exist_files()
{
if (cbTypeSample.EditValue != null && cbCompany.EditValue != null)
{
Reception oReception = new Reception();
repAttach_file.DataSource = oReception.GetLstExistFiles(Convert.ToInt16(cbCompany.EditValue), cbTypeSample.EditValue.ToString());
repAttach_file.DisplayMember = "Name_file";
repAttach_file.ValueMember = "Idrecep_sample_attach";
}
}
