public int ModificarPersona(CPerson per) { using (SchoolEntities contexto = new SchoolEntities()) { try { var query = contexto.Person.Select(p => new CPerson { PersonID = p.PersonID, LastName = p.LastName, FirstName = p.FirstName }).Where(x => x.PersonID == per.PersonID).First(); query.FirstName = per.FirstName; query.LastName = per.LastName; query.HireDate = per.HireDate; query.EnrollmentDate = per.EnrollmentDate; int resultado = contexto.SaveChanges(); return(resultado); } catch (Exception ex) { return(-1); } } }
static void Main(string[] args) { var S1 = new SPerson(); var S2 = new SPerson(); S1.Id = 1; S2.Id = 2; Console.WriteLine(""); Console.WriteLine($"Initial : S1.Id: {S1.Id}; S2.Id: {S2.Id}"); S1 = S2; Console.WriteLine($"After 1=2 : S1.Id: {S1.Id}; S2.Id: {S2.Id}"); S1.Id = 3; Console.WriteLine($"After 1.Id change: S1.Id: {S1.Id}; S2.Id: {S2.Id}"); var C1 = new CPerson(); var C2 = new CPerson(); C1.Id = 1; C2.Id = 2; Console.WriteLine(""); Console.WriteLine($"Initial : C1.Id: {C1.Id}; C2.Id: {C2.Id}"); C1 = C2; Console.WriteLine($"After 1=2 : C1.Id: {C1.Id}; C2.Id: {C2.Id}"); C1.Id = 3; Console.WriteLine($"After 1.Id change: C1.Id: {C1.Id}; C2.Id: {C2.Id}"); if (System.Diagnostics.Debugger.IsAttached) { Console.Write("Press any key to continue . . . "); Console.ReadKey(); } }
public async Task <ActionResult <CPerson> > PostCPerson(CPerson cPerson) { _context.Persons.Add(cPerson); await _context.SaveChangesAsync(); return(CreatedAtAction("GetCPerson", new { id = cPerson.Id }, cPerson)); }
public async Task <IActionResult> PutCPerson(int id, CPerson cPerson) { if (id != cPerson.Id) { return(BadRequest()); } _context.Entry(cPerson).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CPersonExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
private String cValidateForInsert(CPerson vPerson) { String messge = ""; if (vPerson.Company.CompanyId < 1) { messge = "Compañia Invalida"; } else if (vPerson.FirstName == "") { messge = "Nombre Invalido"; } else if (vPerson.LastName == "") { messge = "Apellido Invalido"; } else if (vPerson.DocumentTypeId < 1) { messge = "Apellido Invalido"; } else if (vPerson.DocumenTypeDesc == "") { messge = "Documento Invalido"; } else if (vPerson.Sex_ID < 1) { messge = "ID Invalido"; } else { messge = "Ok"; } return(messge); }
private CFamily ConvertFamily(CFamilyDto familyDal, CPerson knownMember = null) { if (familyDal == null) { return(null); } Int32 id = familyDal.FamilyID; String fName = familyDal.FamilyName; Int32 budget = familyDal.Budget ?? 0; Int32 membersCounter = familyDal.MembersCounter ?? 0; CFamily familyBll = new CFamily(id, fName, budget, membersCounter); foreach (CFamilyTargetDto fTarget in familyDal.FamilyTargets) { familyBll.FamilyTargets.Add(ConvertFamilyTarget(fTarget)); } foreach (CPersonDto member in familyDal.People) { if (knownMember != null && knownMember.PersonID == member.PersonID) { familyBll.FamilyMembers.Add(knownMember); } else { familyBll.FamilyMembers.Add(ConvertPerson(member, familyBll)); } } return(familyBll); }
public void InsertPerson() { using (CContext c_ocContext = new CContext()) { CPerson c_peSomeone = new CPerson("Иванов", "Петр", "Сергеевич", new CDateTime(2010, 1, 2)); c_ocContext.Persons.Add(c_peSomeone); Assert.IsTrue(c_ocContext.SaveChanges() > 0); } }
public void DeletePerson() { using (CContext c_ocContext = new CContext()) { CPerson c_peSomeone = c_ocContext.Persons.FirstOrDefault(); Assert.IsNotNull(c_peSomeone); c_ocContext.Persons.Remove(c_peSomeone); Assert.IsTrue(c_ocContext.SaveChanges() > 0); } }
public EditPersonForm(ref CAimManager _aimManager, ref CItemManager _itemManager, ref CPersonManager _personManager) { InitializeComponent(); editedPerson = new CPerson(); aimManager = _aimManager; itemManager = _itemManager; personManager = _personManager; fillUIComponents(); }
private CPerson ConvertPerson(CPersonDto personDal, CFamily knownFamilyBll = null) { CPerson personBll; try { if (personDal == null) { return(null); } Int32 id = personDal.PersonID; String name = personDal.Name; Int32 budget = personDal.Budget ?? 0; personBll = new CPerson(id, name, budget); CFamily familyBll; if (knownFamilyBll == null && personDal.FamilyID != null) { CFamilyDto familyDto = personDal.Family; familyBll = ConvertFamily(familyDto, personBll); } else { familyBll = knownFamilyBll; } personBll.Family = familyBll; foreach (CSubCategoryDto subCategory in personDal.SubCategories) { personBll.SubCategories.Add(ConvertSubCategory(subCategory)); } foreach (CSpendingHistoryDto spendingHistory in personDal.SpendingHistories) { personBll.Histories.Add(ConvertSpendingHistory(spendingHistory)); } foreach (CPersonalTargetDto pTarget in personDal.PersonalTargets) { personBll.PersonalTargets.Add(ConvertPersonalTarget(pTarget)); } foreach (CReminderDto reminder in personDal.Reminders) { personBll.Reminders.Add(ConvertReminders(reminder)); } } catch (Exception ex) { log.Error(ex, "Some error occure while trying to convert CPersonDto (id = {1}) to CPerson. Message: {0}", ex.Message, personDal.PersonID); throw; } return(personBll); }
public EditPersonForm(CPerson _person, ref CAimManager _aimManager, ref CItemManager _itemManager, ref CPersonManager _personManager) { InitializeComponent(); editedPerson = _person; aimManager = _aimManager; itemManager = _itemManager; personManager = _personManager; fillUIComponents(); fillPersonData(); }
protected void Page_Load(object sender, EventArgs e) { CPerson per = personB.MostrarPersonaBLL((int)Session["PersonID"]); txtPersonID.Text = per.PersonID.ToString(); txtLastName.Text = per.LastName; txtFirstName.Text = per.FirstName; txtHireDate.Text = per.HireDate.ToString(); txtEnrollmentDate.Text = per.EnrollmentDate.ToString(); }
static void Main(string[] args) { //인스턴스ㅏ인 경우 Console.WriteLine(CPerson.CountOfInstance); //출력 결과 : 0 CPerson person1 = new CPerson("홍길동"); CPerson person2 = new CPerson("홍길순"); Console.WriteLine(CPerson.CountOfInstance);//출력결과 : 2 }
public Boolean InsertarPersona(CPerson per) { if (personDAL.InsertarPersona(per) > 0) { return(true); } else { return(false); } }
public Boolean ModificarPersona(CPerson per) { if (personDAL.ModificarPersona(per) > 0) { return(true); } else { return(false); } }
/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of CPerson</returns> internal List <CPerson> PopulateObjectsFromReader(IDataReader dataReader) { List <CPerson> list = new List <CPerson>(); while (dataReader.Read()) { CPerson businessObject = new CPerson(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }
protected void btnGuardar_Click(object sender, EventArgs e) { CPerson per = new CPerson(); per.PersonID = Convert.ToInt32(txtPersonID.Text); per.LastName = txtLastName.Text; per.FirstName = txtFirstName.Text; per.HireDate = Convert.ToDateTime(txtHireDate.Text); per.EnrollmentDate = Convert.ToDateTime(txtEnrollmentDate.Text); personB.ModificarPersonaBLL(per); }
static void Main(string[] args) { CPerson outPerson = new CPerson(); CPerson inPerson = null; outPerson.ID = 1; outPerson.Name = "First"; outPerson.Email = "Address"; CResult tmpResult = null; tmpResult = new CResult(); tmpResult.Title = "Title01"; outPerson.Result.Add(tmpResult); tmpResult = new CResult(); tmpResult.Title = "Title02"; outPerson.Result.Add(tmpResult); if (false) { // ProtoBuf序列化 using (var outFile = System.IO.File.Create("Person.bin")) { ProtoBuf.Serializer.Serialize <CPerson>(outFile, outPerson); } // ProtoBuf反序列化 using (var inFile = System.IO.File.OpenRead("Person.bin")) { inPerson = ProtoBuf.Serializer.Deserialize <CPerson>(inFile); } } else { MemoryStream outStream = new MemoryStream(); MemoryStream inStream = new MemoryStream(); ProtoBuf.Serializer.Serialize <CPerson>(outStream, outPerson); outStream.Seek(0, SeekOrigin.Begin); inStream.Write(outStream.ToArray(), 0, outStream.ToArray().Length); inStream.Seek(0, SeekOrigin.Begin); inPerson = ProtoBuf.Serializer.Deserialize <CPerson>(inStream); } System.Console.WriteLine(inPerson.Name); for (int i = 0; i < inPerson.Result.Count; i++) { System.Console.WriteLine(inPerson.Result[i].Title); } Thread.Sleep(3000); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { CPerson per = personB.MostrarPersona((int)Session["PersonID"]); txtID.Text = per.PersonID.ToString(); txtFirst.Text = per.FirstName; txtLast.Text = per.LastName; txtHire.Text = Convert.ToString(per.HireDate); txtEnrollment.Text = Convert.ToString(per.EnrollmentDate); } }
private void cmbEditPerson_Click(object sender, EventArgs e) { List <GridViewRowInfo> rows = gridViewPersons.SelectedRows.ToList(); int id = int.Parse(rows[0].Cells["columnID"].Value.ToString()); CPerson person = peopleManager.getPerson(id); EditPersonForm epf = new EditPersonForm(person, ref aimManager, ref itemManager, ref peopleManager); if (epf.ShowDialog() == DialogResult.OK) { peopleManager.updatePerson(epf.editedPerson); UpdateDataOnGridViews(); } }
protected void btnGuardar_Click(object sender, EventArgs e) { CPerson per = new CPerson(); per.PersonID = Convert.ToInt32(txtID.Text); per.FirstName = txtFirst.Text; per.LastName = txtLast.Text; per.HireDate = DateTime.Now; per.EnrollmentDate = DateTime.Now; personB.ModificarPersona(per); Response.Redirect("Default.aspx"); }
public void uInsert(CPerson vPerson) { tPers.Company_ID = vPerson.Company.CompanyId; tPers.FirstName = vPerson.FirstName; tPers.LastName = vPerson.LastName; tPers.IDType_ID = vPerson.DocumentTypeId; tPers.ID = vPerson.DocumenTypeDesc; tPers.CreatedBy_ID = vPerson.Auth.AuthId; tPers.Sex_ID = vPerson.Sex_ID; tPers.CreatedDate = DateTime.Now; dbSGPP.People.Add(tPers); dbSGPP.SaveChanges(); }
public string GetParentsLeaders(int SystemId, int UserId) { string parentsList = ""; DataSet ds = new DataSet(); ds = CPerson.GetUserSupervisor(SystemId, UserId); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { parentsList = dr["WorkEmail"].ToString(); } } return(parentsList); }
public bool PersonCommitBefore(CPerson person) { if (person.ixPerson < 1) //if we're adding a new user { SetDefaultKilnAccess(person); } else { string sAllowKiln = api.Request[_radioInputName]; int canAccess = Convert.ToInt32(sAllowKiln); person.SetPluginField(PluginId, _ixCanAccessKiln, canAccess); } return true; }
public CDialogItem[] PersonDisplayEdit(CPerson person) { CDialogItem[] retVal = null; //only if editing existing user if (person.ixPerson > 0 && api.Person.GetCurrentPerson().fAdministrator) { var allowKiln = new CDialogItem(); retVal = new CDialogItem[] { allowKiln }; allowKiln.sLabel = "Kiln Access"; allowKiln.sInstructions = "Is this user allowed to use Kiln?"; if (IsEligible(person)) { var personHasKilnAccess = PersonHasKilnAccess(person).GetValueOrDefault(); allowKiln.sContent = Forms.RadioInput(_radioInputName, "1", personHasKilnAccess, "Yes", "sAllowKilnYes") + Forms.RadioInput(_radioInputName, "0", !personHasKilnAccess, "No", "sAllowKilnNo") ; } else { //set default setting to yes if admin and no if normal user var setDefault = person.IsSiteAdmin(); var enabledAttrs = new Dictionary<string, string> { { "disabled", "true" } }; allowKiln.sContent = Forms.RadioInput(_radioInputName, "1", setDefault, "Yes", "sAllowKilnYes", enabledAttrs) + Forms.RadioInput(_radioInputName, "0", !setDefault, "No", "sAllowKilnNo", enabledAttrs) ; if (!api.SiteConfiguration.IsKilnEnabled) { allowKiln.sInstructions += " (This option is not configurable until Kiln is installed)"; } } } return retVal; }
void txtCQCN_SelectedItemChanged(object sender, EventArgs e) { if (txtKHTX.SelectedItem == null) { return; } if (txtKHTX.SelectedItem.Tag == null) { return; } if (txtKHTX.SelectedItem.Tag is CPerson) { CPerson p = txtKHTX.SelectedItem.Tag as CPerson; txtAddress.Text = p.Address; // txtObjectEmail.Text = p.Email; //throw new NotImplementedException(); } }
/// <summary> /// Select by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>CPerson business object</returns> public CPerson SelectByPrimaryKey(CPersonKeys keys) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_person_SelectByPrimaryKey"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new NpgsqlParameter("p_idperson", NpgsqlDbType.Smallint, 2, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Idperson)); MainConnection.Open(); NpgsqlDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.Read()) { CPerson businessObject = new CPerson(); PopulateBusinessObjectFromReader(businessObject, dataReader); return(businessObject); } else { return(null); } } catch (Exception ex) { throw new Exception("CPerson::SelectByPrimaryKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
private bool? PersonHasKilnAccess(CPerson person) { bool? retVal = null; if (IsLicensedUser(person)) { int canAccess = Convert.ToInt32(person.GetPluginField(PluginId, _ixCanAccessKiln)); if (canAccess == 1) { retVal = true; } else { retVal = false; } } return retVal; }
public int InsertarPersona(CPerson per) { using (SchoolEntities contexto = new SchoolEntities()) { try { Person person = new Person(); person.PersonID = per.PersonID; person.FirstName = per.FirstName; person.LastName = per.LastName; person.HireDate = per.HireDate; person.EnrollmentDate = per.EnrollmentDate; contexto.Person.Add(person); int resultado = contexto.SaveChanges(); return(resultado); } catch (Exception ex) { return(-1); } } }
public CPerson GetPersonById(Int32 personId) { try { log.Trace($"Entered GetPersonById personId = {personId}"); String Uri = _dataControllerAdress + $"GetPersonById?personId={personId}"; log.Trace("URI = {0}", Uri); HttpResponseMessage responce = _client.GetAsync(Uri).Result; CPerson res = responce.Content.ReadAsAsync <CPerson>().Result; log.Trace("Responce recived in GetPersonById"); return(res); } catch (Exception ex) { log.Error("Some error occure in CDataSupplierProxy.GetPersonById (personId = {1}). Message: {0}", ex.Message, personId); return(null); } }
bool SaveRegisterReception() { bool result = false; object obj = deHourReception.EditValue; try { #region save head if (oRecep_sample == null) oRecep_sample = new CRecep_sample(); else { if (loadData == LoadData.FromRR_ToExtendRR) oRecep_sample.Idrecep_sample = 0; } CPersonFactory faPerson = new CPersonFactory(); Reception oReception = new BusinessLayer.Modules.Reception(); // --- save company bool result_company = false; CCompany oCompany = new CCompany(); if (cbCompany.EditValue != null) { CCorr_modulesFactory faCorr_modules = new CCorr_modulesFactory(); CCompanyFactory faCompany = new CCompanyFactory(); oCompany.Idcompany = Convert.ToInt16(cbCompany.EditValue); //oCompany.Cod_company = faCorr_modules.GetCorrModule(Comun.Formulario.fmEmpresa.ToString()); oCompany.Ruc = tbClientRuc.Text; oCompany.Business_name = cbCompany.Text; oCompany.Domicile = tbClientDomicile.Text; oCompany.Type_company = 'C'; // --- client oCompany.Phone_client = tbClientPhone.Text; if (!(result_company = faCompany.Update(oCompany))) result_company = faCompany.Insert(oCompany); } // --- save head if (!result_company) { ComunForm.Send_message(this.Text, TypeMsg.error, "Error al guardar cliente, no se pudo completar la operación."); return false; } bool result_recep_sample = false; oReception.GetNewCodReception(); oRecep_sample.Cod_recep_sample = oReception.GetFormatCodReception(); oRecep_sample.Idcompany = oCompany.Idcompany; oRecep_sample.Date_reception = deReception.DateTime; DateTime Hour_reception = Convert.ToDateTime(deHourReception.EditValue); oRecep_sample.Date_reception = new DateTime( deReception.DateTime.Year, deReception.DateTime.Month, deReception.DateTime.Day, Hour_reception.Hour, Hour_reception.Minute, Hour_reception.Second); DateTime Hour_result = Convert.ToDateTime(deHourResult.EditValue); oRecep_sample.Date_result = new DateTime( deResult.DateTime.Year, deResult.DateTime.Month, deResult.DateTime.Day, Hour_result.Hour, Hour_result.Minute, Hour_result.Second); oRecep_sample.Cod_type_sample = cbTypeSample.EditValue.ToString(); oRecep_sample.Total_amount = Convert.ToDecimal(tbSubTotalAmount.Text); oRecep_sample.Total_igv = Convert.ToDecimal(tbTotalIgv.Text); oRecep_sample.Total_amount_igv = Convert.ToDecimal(tbTotalAmount.Text); oRecep_sample.Amortization = Convert.ToDecimal(tbAmortization.Text); oRecep_sample.Flag_isprice = false; //oRecep_sample.Discount = ckDiscount.Checked == true ? tbDiscount.Value : 0; if (oRecep_sample.Idrecep_sample == 0) { oRecep_sample.Usernew = Comun.GetUser(); oRecep_sample.Datenew = Comun.GetDate(); } oRecep_sample.Useredit = Comun.GetUser(); oRecep_sample.Dateedit = Comun.GetDate(); if (!(result_recep_sample = faRecep_sample.Update(oRecep_sample))) result_recep_sample = faRecep_sample.Insert(oRecep_sample); if (!result_recep_sample) { ComunForm.Send_message(this.Text, TypeMsg.error, "Error al guardar datos en recepción, no se pudo completar la operación."); return false; } #endregion #region update price if (result_recep_sample && oPrice_version != null && oPrice_version.Idprice_version > 0) { oPrice_version.Status_price = 4; faPrice_version.Update(oPrice_version); } #endregion #region save detail // --- contacts and detail if (result_recep_sample) { // --- save contacts CPerson oContact = new CPerson(); CRecep_company_person oRecep_company_person = new CRecep_company_person(); CRecep_company_personFactory faRecep_company_person = new CRecep_company_personFactory(); // --- delete all tbCod_recep_sample.Text = oReception.GetFormatCodReception(); oReception.SetDisabledContact(oRecep_sample.Idrecep_sample); for (int i = 0; i < gvContact.RowCount; i++) { oContact.Idperson = Convert.ToInt16(gvContact.GetRowCellValue(i, gcCon_Idperson)); oContact.Phone = gvContact.GetRowCellValue(i, gcCon_Phone).ToString(); oContact.Cellphone = gvContact.GetRowCellValue(i, gcCon_Cellphone).ToString(); oContact.Mail = gvContact.GetRowCellValue(i, gcCon_Mail).ToString(); oContact.Allname = gvContact.GetRowCellValue(i, gcCon_Allname).ToString(); bool result_contact = false; if (!(result_contact = faPerson.Update(oContact))) result_contact = faPerson.Insert(oContact); if (result_contact) { oRecep_company_person = new CRecep_company_person(); oRecep_company_person.Idrecep_company_person = 0; oRecep_company_person.Idcompany = oCompany.Idcompany; oRecep_company_person.Idrecep_sample = oRecep_sample.Idrecep_sample; oRecep_company_person.Idperson = oContact.Idperson; oRecep_company_person.Person_type = Convert.ToInt16(gvContact.GetRowCellValue(i, gcCon_Person_type)); oRecep_company_person.Enabled_show = true; if (!faRecep_company_person.Update(oRecep_company_person)) faRecep_company_person.Insert(oRecep_company_person); } } // --- save dispatch CRecep_sample_dispatchFactory faRecep_sample_dispatch = new CRecep_sample_dispatchFactory(); CRecep_sample_dispatch oRecep_sample_dispatch = new CRecep_sample_dispatch(); oRecep_sample_dispatch.Idrecep_sample = oRecep_sample.Idrecep_sample; // --- person if (ckDispatchPerson.Checked) oRecep_sample_dispatch.Dispatch_person = 1; else oRecep_sample_dispatch.Dispatch_person = 0; // --- curier if (ckDispatchCurier.Checked) oRecep_sample_dispatch.Dispatch_curier = 1; else oRecep_sample_dispatch.Dispatch_curier = 0; // --- transport if (ckDispatchTransport.Checked) oRecep_sample_dispatch.Dispatch_transport = 1; else oRecep_sample_dispatch.Dispatch_transport = 0; // --- fax if (ckDispatchFax.Checked) oRecep_sample_dispatch.Dispatch_fax = 1; else oRecep_sample_dispatch.Dispatch_fax = 0; // --- save if (!faRecep_sample_dispatch.Update(oRecep_sample_dispatch)) faRecep_sample_dispatch.Insert(oRecep_sample_dispatch); // --------------------------------------------------------------------------- // --- save detail ----------------------------------------------------------- // --------------------------------------------------------------------------- CRecep_sample_detail oRecep_sample_detail = new CRecep_sample_detail(); CRecep_sample_detailFactory faRecep_sample_detail = new CRecep_sample_detailFactory(); CRecep_elem oRecep_elem = new CRecep_elem(); CRecep_elemFactory faRecep_elem = new CRecep_elemFactory(); CRecep_sample_detail_elem oRecep_sample_detail_elem = new CRecep_sample_detail_elem(); CRecep_sample_detail_elemFactory faRecep_sample_detail_elem = new CRecep_sample_detail_elemFactory(); CCorrelative oCorrelative = new CCorrelativeFactory().GetByPrimaryKey(new CCorrelativeKeys(oRecep_sample.Cod_type_sample)); if (oRecep_sample.Idrecep_sample > 0) { int i = 0; while (i < gvReception.RowCount) { oRecep_sample_detail = new CRecep_sample_detail(); oRecep_sample_detail.Idrecep_sample = oRecep_sample.Idrecep_sample; //if (gvReception.GetRowCellValue(i, gcRec_idrecep_sample_detail) != DBNull.Value) //oRecep_sample_detail.Idrecep_sample_detail = Convert.ToInt64(gvReception.GetRowCellValue(i, gcRec_idrecep_sample_detail)); oRecep_sample_detail.Idrecep_sample_detail = 0; oRecep_sample_detail.Order_sample = Convert.ToInt16(gvReception.GetRowCellValue(i, gcRec_OrderSample)); oRecep_sample_detail.Name_sample = gvReception.GetRowCellValue(i, gcRec_NameSample).ToString(); oRecep_sample_detail.Procedence = gvReception.GetRowCellValue(i, gcRec_Procedence).ToString(); oRecep_sample_detail.Cod_des_sample = gvReception.GetRowCellValue(i, gcRec_Description).ToString(); oRecep_sample_detail.Cod_type_sample = gvReception.GetRowCellValue(i, gcRec_Type_Sample).ToString(); oRecep_sample_detail.Cod_sample = gvReception.GetRowCellValue(i, gcRec_Code).ToString(); oRecep_sample_detail.Amount_weight = Convert.ToDecimal(gvReception.GetRowCellValue(i, gcRec_CantKg)); oRecep_sample_detail.Cost_sample = Convert.ToDecimal(gvReception.GetRowCellValue(i, gcRec_Cost)); oRecep_sample_detail.Flag_envelope_sealed = Convert.ToBoolean(gvReception.GetRowCellValue(i, gcRec_Flag_envelope_sealed)); oRecep_sample_detail.Flag_reject = Convert.ToBoolean(gvReception.GetRowCellValue(i, gcRec_Reject)); oRecep_sample_detail.Flag_counter_sample = Convert.ToInt16(gvReception.GetRowCellValue(i, gcRec_Counter_Sample)); oRecep_sample_detail.Analisys_time = Convert.ToInt16(gvReception.GetRowCellValue(i, gcRec_Days)); bool result_detail_elem = false; bool result_recep_sample_detail = false; if (!(result_recep_sample_detail = faRecep_sample_detail.Update(oRecep_sample_detail))) result_recep_sample_detail = faRecep_sample_detail.Insert(oRecep_sample_detail); if (result_recep_sample_detail) { if (FlagRegRecepCopy) { oRecep_sample_detail.Cod_interno = Convert.ToInt64(gvReception.GetRowCellValue(i, gcRec_Cod_interno)); oRecep_sample_detail.Cod_sample = gvReception.GetRowCellValue(i, gcRec_Code).ToString(); oRecep_sample_detail.Flag_control_sample = false; } else { // assign correlative code long Cod_interno = oReception.GetNewCodInternoSample(gvReception.GetRowCellValue(i, gcRec_Type_Sample).ToString()); string Format_cod_interno = oReception.GetFormatCodInternoSample(gvReception.GetRowCellValue(i, gcRec_Type_Sample).ToString()); oRecep_sample_detail.Cod_interno = Cod_interno; oRecep_sample_detail.Cod_sample = Format_cod_interno; oRecep_sample_detail.Flag_control_sample = false; } faRecep_sample_detail.Update(oRecep_sample_detail); #region save element cell repetition CRecep_sample_detail oRecep_sample_aux = faRecep_sample_detail.GetByPrimaryKey(new CRecep_sample_detailKeys(oRecep_sample_detail.Idrecep_sample_detail)); CSettings oSettings = new CSettings(); bool HasHumidityAnalysis = false; bool Has60GradesElement = false; // --- retrieve code sample and assign if (!Convert.ToBoolean(oRecep_sample_detail.Flag_control_sample)) gvReception.SetRowCellValue(i, gcRec_Code, oRecep_sample_aux.Cod_sample); // --- save element cell foreach (KeyValuePair<DevExpress.XtraGrid.Columns.GridColumn, bool> kvp in DicShowColumns) { if (kvp.Value) { bool value_check = Convert.ToBoolean(gvReception.GetRowCellValue(i, kvp.Key)); bool flag_control_sample = Convert.ToBoolean(oRecep_sample_detail.Flag_control_sample); if ((!flag_control_sample && value_check) || flag_control_sample) { oRecep_sample_detail_elem = new CRecep_sample_detail_elem(); CTagInfoMethod tagMethod = (CTagInfoMethod)kvp.Key.Tag; oRecep_sample_detail_elem.Idelement = tagMethod.IDElement; oRecep_sample_detail_elem.Idrecep_sample = oRecep_sample.Idrecep_sample; oRecep_sample_detail_elem.Idrecep_sample_detail = oRecep_sample_detail.Idrecep_sample_detail; oRecep_sample_detail_elem.Idtemplate_method = tagMethod.IDTemplate_method; oRecep_sample_detail_elem.Idcompany = oRecep_sample.Idcompany; oRecep_sample_detail_elem.Idunit = tagMethod.IDMeasurement_Unit; oRecep_sample_detail_elem.Cost_method = tagMethod.Cost_Method; if (!(result_detail_elem = faRecep_sample_detail_elem.Update(oRecep_sample_detail_elem))) result_detail_elem = faRecep_sample_detail_elem.Insert(oRecep_sample_detail_elem); if (result_detail_elem) { // crear bandejas CBatchManager oBatchManager = new CBatchManager(); oBatchManager.CallSaveSampleBatch( Convert.ToInt32(oRecep_sample_detail_elem.Idtemplate_method), Convert.ToInt64(oRecep_sample_detail_elem.Idrecep_sample), Convert.ToInt64(oRecep_sample_detail_elem.Idrecep_sample_detail), oRecep_sample_detail_elem.Idrecep_sample_detail_elem, Convert.ToInt64(oRecep_sample_detail.Cod_interno), oRecep_sample_detail.Cod_sample, Comun.GetUser(), oCorrelative); // enviar a preparación de muestras } //verificar si tiene análisis por humedad if (oSettings.GetIdHumidityAnalysis().Contains(tagMethod.IDElement.ToString())) HasHumidityAnalysis = true; //verificar si tiene que elementos para ser analizados a 60° if (oSettings.GetIDElements60Grades().Contains(tagMethod.IDElement.ToString())) Has60GradesElement = true; } } } #endregion #region save sample preparation CPrep_samples oPrep_samples = new CPrep_samples(); oPrep_samples.Idrecep_sample_detail = oRecep_sample_detail.Idrecep_sample_detail; oPrep_samples.Flag_counter_sample = oRecep_sample_detail.Flag_counter_sample; oPrep_samples.Flag_reject = oRecep_sample_detail.Flag_reject; oPrep_samples.Flag_humidity_analysis = HasHumidityAnalysis; oPrep_samples.Flag_60celsius = Has60GradesElement; oPrep_samples.Date_creation = Comun.GetDate(); oPrep_samples.Moisture_reject = false; oPrep_samples.Final_moisture = 0; oPrep_samples.Final_reject = 0; oPrep_samples.Final_sample_prepared = 0; oPrep_samples.Final_weight_gross = 0; oPrep_samples.Output_flag_sample = false; oPrep_samples.Output_flag_cs = false; oPrep_samples.Output_flag_re = false; CPrep_samplesFactory faPrep_samples = new CPrep_samplesFactory(); if (!faPrep_samples.Update(oPrep_samples)) faPrep_samples.Insert(oPrep_samples); #endregion } if (!Convert.ToBoolean(oRecep_sample_detail.Flag_control_sample)) i++; } } #region save tag infor method // --- save tag info method (mr or blk) foreach (KeyValuePair<DevExpress.XtraGrid.Columns.GridColumn, bool> kvp in DicShowColumns) { if (kvp.Value) { CTagInfoMethod tagMethod = (CTagInfoMethod)kvp.Key.Tag; oRecep_elem = new CRecep_elem(); oRecep_elem.Idelement = tagMethod.IDElement; oRecep_elem.Idrecep_sample = oRecep_sample.Idrecep_sample; oRecep_elem.Idtemplate_method = tagMethod.IDTemplate_method; oRecep_elem.Name_unit = tagMethod.Name_Measurement_Unit; oRecep_elem.Idunit = tagMethod.IDMeasurement_Unit; oRecep_elem.Percent_repetition = tagMethod.Percent_repetition; if (!faRecep_elem.Update(oRecep_elem)) faRecep_elem.Insert(oRecep_elem); } } #endregion } #endregion result = true; } catch (Exception ex) { Comun.Save_log(ex.Message); if (ex.InnerException != null) Comun.Save_log(ex.InnerException.ToString()); return false; } return result; }
public void PersonCommitRollback(CPerson person) { throw new NotImplementedException(); }
private string PersonKilnAccessString(CPerson person) { string retVal = "N/A"; bool? hasAccess = PersonHasKilnAccess(person); if (hasAccess.HasValue) { retVal = hasAccess.Value ? "Yes" : "No"; } return retVal; }
private bool IsLicensedUser(CPerson person) { return !person.fCommunity && !person.fVirtual; }
public void PersonCommitAfter(CPerson person) { /*Yay - it worked*/ }
private void SetDefaultKilnAccess(CPerson person) { if (IsLicensedUser(person)) { if (person.fAdministrator) { person.SetPluginField(PluginId, _ixCanAccessKiln, 1); } else { person.SetPluginField(PluginId, _ixCanAccessKiln, 0); } } }
public string[] PersonDisplayListFields(CPerson person) { return new string[] { PersonKilnAccessString(person) }; }
/// <summary> /// Populate business object from data reader /// </summary> /// <param name="businessObject">business object</param> /// <param name="dataReader">data reader</param> internal void PopulateBusinessObjectFromReader(CPerson businessObject, IDataReader dataReader) { businessObject.Idperson = (short)dataReader.GetInt16(dataReader.GetOrdinal(CPerson.CPersonFields.Idperson.ToString())); if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Cod_person.ToString()))) { businessObject.Cod_person = dataReader.GetString(dataReader.GetOrdinal(CPerson.CPersonFields.Cod_person.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Type_document.ToString()))) { businessObject.Type_document = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CPerson.CPersonFields.Type_document.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Last_name1.ToString()))) { businessObject.Last_name1 = dataReader.GetString(dataReader.GetOrdinal(CPerson.CPersonFields.Last_name1.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Last_name2.ToString()))) { businessObject.Last_name2 = dataReader.GetString(dataReader.GetOrdinal(CPerson.CPersonFields.Last_name2.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Names_person.ToString()))) { businessObject.Names_person = dataReader.GetString(dataReader.GetOrdinal(CPerson.CPersonFields.Names_person.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Allname.ToString()))) { businessObject.Allname = dataReader.GetString(dataReader.GetOrdinal(CPerson.CPersonFields.Allname.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Gender.ToString()))) { businessObject.Gender = dataReader.GetChar(dataReader.GetOrdinal(CPerson.CPersonFields.Gender.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Domicile.ToString()))) { businessObject.Domicile = dataReader.GetString(dataReader.GetOrdinal(CPerson.CPersonFields.Domicile.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Mail.ToString()))) { businessObject.Mail = dataReader.GetString(dataReader.GetOrdinal(CPerson.CPersonFields.Mail.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Phone.ToString()))) { businessObject.Phone = dataReader.GetString(dataReader.GetOrdinal(CPerson.CPersonFields.Phone.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Cellphone.ToString()))) { businessObject.Cellphone = dataReader.GetString(dataReader.GetOrdinal(CPerson.CPersonFields.Cellphone.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Usernew.ToString()))) { businessObject.Usernew = dataReader.GetString(dataReader.GetOrdinal(CPerson.CPersonFields.Usernew.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Datenew.ToString()))) { businessObject.Datenew = dataReader.GetDateTime(dataReader.GetOrdinal(CPerson.CPersonFields.Datenew.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Useredit.ToString()))) { businessObject.Useredit = dataReader.GetString(dataReader.GetOrdinal(CPerson.CPersonFields.Useredit.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Dateedit.ToString()))) { businessObject.Dateedit = dataReader.GetDateTime(dataReader.GetOrdinal(CPerson.CPersonFields.Dateedit.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Status.ToString()))) { businessObject.Status = dataReader.GetBoolean(dataReader.GetOrdinal(CPerson.CPersonFields.Status.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPerson.CPersonFields.Person_type.ToString()))) { businessObject.Person_type = dataReader.GetInt32(dataReader.GetOrdinal(CPerson.CPersonFields.Person_type.ToString())); } }
protected override bool Grabar_Registro() { // --- save company bool result_company = false; CCompany oCompany = new CCompany(); if (cbCompany.EditValue != null) { CCorr_modulesFactory faCorr_modules = new CCorr_modulesFactory(); CCompanyFactory faCompany = new CCompanyFactory(); oCompany.Idcompany = Convert.ToInt16(cbCompany.EditValue); //oCompany.Cod_company = faCorr_modules.GetCorrModule(Comun.Formulario.fmEmpresa.ToString()); oCompany.Ruc = tbClientRuc.Text; oCompany.Business_name = cbCompany.Text; oCompany.Domicile = tbClientDomicile.Text; oCompany.Type_company = 'C'; // --- client oCompany.Phone_client = tbClientPhone.Text; if (!(result_company = faCompany.Update(oCompany))) { result_company = faCompany.Insert(oCompany); } } bool result_price = false; if (oPrice == null) { oPrice = new CPrice(); } CPriceFactory faPrice = new CPriceFactory(); if (!(loadData == LoadData.FromPrice_ToNewVersion)) { oPrice.Cod_price = new ModCorrelatives().GetCorrelative(Comun.Correlative.Price); } // --- person if (ckDispatchPerson.Checked) { oPrice.Dispatch_person = 1; } else { oPrice.Dispatch_person = 0; } // --- curier if (ckDispatchCurier.Checked) { oPrice.Dispatch_curier = 1; } else { oPrice.Dispatch_curier = 0; } // --- transport if (ckDispatchTransport.Checked) { oPrice.Dispatch_transport = 1; } else { oPrice.Dispatch_transport = 0; } // --- fax if (ckDispatchFax.Checked) { oPrice.Dispatch_fax = 1; } else { oPrice.Dispatch_fax = 0; } if (!(result_price = faPrice.Update(oPrice))) { result_price = faPrice.Insert(oPrice); } // --- save contacts CPerson oContact = new CPerson(); CPersonFactory faPerson = new CPersonFactory(); CPrice_company_person oPrice_company_person = new CPrice_company_person(); CPrice_company_personFactory faPrice_company_person = new CPrice_company_personFactory(); // --- delete all if (result_price) { oPrice_version = new CPrice_version(); CPrice_versionFactory faPrice_version = new CPrice_versionFactory(); oPrice_version.Idprice = oPrice.Idprice; oPrice_version.Idcompany = null; if (cbCompany.EditValue != null) { oPrice_version.Idcompany = Convert.ToInt16(cbCompany.EditValue); } oPrice_version.Cod_type_sample = cbTypeSample.EditValue.ToString(); oPrice_version.Num_version = new ModPrice().GetNextNumVersion(oPrice.Idprice); oPrice_version.Date_creation = deDateCreation.DateTime; oPrice_version.Num_days_valid = Convert.ToInt16(tbNumDaysValid.Value); oPrice_version.Observation = tbObservation.Text; oPrice_version.Iduser = Comun.User_system.Iduser; oPrice_version.Status_price = 1; bool result_price_version = false; if (!(result_price_version = faPrice_version.Update(oPrice_version))) { result_price_version = faPrice_version.Insert(oPrice_version); } if (result_price_version) { //guardar párrafos iniciales CMemo_price oMemoPrice; CMemo_priceFactory faMemo_price = new CMemo_priceFactory(); //guardando el parrafo inicial oMemoPrice = new CMemo_price(); oMemoPrice.Idprice_version = oPrice_version.Idprice_version; oMemoPrice.Paragraph = richTextIni.RichTextBox.Rtf; oMemoPrice.Memo_type = 1; faMemo_price.Insert(oMemoPrice); //guardando el parrafo final oMemoPrice = new CMemo_price(); oMemoPrice.Idprice_version = oPrice_version.Idprice_version; oMemoPrice.Paragraph = richTextEnd.RichTextBox.Rtf; oMemoPrice.Memo_type = 2; faMemo_price.Insert(oMemoPrice); if (ckSaveHistoryIni.Checked) { CMemo_template oMemo_template = new CMemo_template(); CMemo_templateFactory faMemo_template = new CMemo_templateFactory(); oMemo_template.Paragraph = richTextIni.RichTextBox.Text; oMemo_template.Paragraph_rtf = richTextIni.RichTextBox.Rtf.ToString(); oMemo_template.Memo_type = 1; faMemo_template.Insert(oMemo_template); } //guardar párrafos finales if (ckSaveHistoryEnd.Checked) { CMemo_template oMemo_template = new CMemo_template(); CMemo_templateFactory faMemo_template = new CMemo_templateFactory(); oMemo_template.Paragraph_rtf = richTextEnd.RichTextBox.Rtf; oMemo_template.Paragraph = richTextEnd.RichTextBox.Text.ToString(); oMemo_template.Memo_type = 2; faMemo_template.Insert(oMemo_template); } } if (result_price) { CCompany_person oCompany_person = new CCompany_person(); CCompany_personFactory faCompany_person = new CCompany_personFactory(); for (int i = 0; i < gvContact.RowCount; i++) { oContact.Idperson = Convert.ToInt16(gvContact.GetRowCellValue(i, gcCon_Idperson)); oContact.Phone = gvContact.GetRowCellValue(i, gcCon_Phone).ToString(); oContact.Cellphone = gvContact.GetRowCellValue(i, gcCon_Cellphone).ToString(); oContact.Mail = gvContact.GetRowCellValue(i, gcCon_Mail).ToString(); oContact.Allname = gvContact.GetRowCellValue(i, gcCon_Allname).ToString(); bool result_contact = false; if (!(result_contact = faPerson.Update(oContact))) { result_contact = faPerson.Insert(oContact); } if (result_contact) { oPrice_company_person = new CPrice_company_person(); oPrice_company_person.Idprice_company_person = 0; oPrice_company_person.Idcompany = oCompany.Idcompany; oPrice_company_person.Idprice = oPrice.Idprice; oPrice_company_person.Idperson = oContact.Idperson; oPrice_company_person.Idprice_version = oPrice_version.Idprice_version; oPrice_company_person.Person_type = Convert.ToInt16(gvContact.GetRowCellValue(i, gcCon_Person_type)); if (!faPrice_company_person.Update(oPrice_company_person)) { faPrice_company_person.Insert(oPrice_company_person); } } // --- save history company person if (!faCompany_person.GetAll().Exists(c => c.Idcompany == oCompany.Idcompany && c.Idperson == oContact.Idperson)) { oCompany_person = new CCompany_person(); oCompany_person.Idcompany = oCompany.Idcompany; oCompany_person.Idperson = oContact.Idperson; if (!faCompany_person.Update(oCompany_person)) { faCompany_person.Insert(oCompany_person); } } } } if (result_price_version) { // guardar detalle CPrice_version_detail oPrice_version_detail = new CPrice_version_detail(); CPrice_version_detailFactory faPrice_version_detail = new CPrice_version_detailFactory(); for (int i = 0; i < gvPrice.RowCount; i++) { oPrice_version_detail = new CPrice_version_detail(); oPrice_version_detail.Idprice_version = oPrice_version.Idprice_version; oPrice_version_detail.Idtemplate_method = Convert.ToInt32(gvPrice.GetRowCellValue(i, gcolItem_Idtemplate_method)); oPrice_version_detail.Num_item = Convert.ToInt32(gvPrice.GetRowCellValue(i, gcolItem_Num_item)); oPrice_version_detail.Amount_item = Convert.ToInt32(gvPrice.GetRowCellValue(i, gcolItem_Amount_item)); oPrice_version_detail.Sale_price = Convert.ToDecimal(gvPrice.GetRowCellValue(i, gcolItem_Sale_price)); oPrice_version_detail.Unit_price = Convert.ToDecimal(gvPrice.GetRowCellValue(i, gcolItem_Unit_price)); if (!faPrice_version_detail.Update(oPrice_version_detail)) { faPrice_version_detail.Insert(oPrice_version_detail); } } } if (result_price_version) { if (gvAnexos.RowCount > 0) { // guardar adjuntos ListCopy lstCopySave = new ListCopy(); List <Anexos> lstAnexos = (gcAnexos.DataSource as BindingList <Anexos>).ToList(); if (lstAnexos != null && lstAnexos.Count > 0) { foreach (Anexos item in lstAnexos) { if (item.Source_filename.Trim().Length > 0) { string destiny_directory = oSettings.GetPathAttachPrice(); lstCopySave.Add( new CItemCopy() { Filename = item.Filename, Source_file = item.Source_filename, Destiny_directory = destiny_directory }); } } lstCopySave.Save(oPrice, oPrice_version); } } } } return(true); }
private bool IsEligible(CPerson person) { return api.SiteConfiguration.IsKilnEnabled && !person.fAdministrator; }
private void ddlPersonChoose_SelectedValueChanged(object sender, EventArgs e) { chosenPerson = personManager.getPerson((int)ddlPersonChoose.SelectedValue); ddlSexChoose.SelectedValue = chosenPerson.sex; }
protected string GetPersonLink(CPerson person) { return string.Format("<a href=\"default.asp?pg=pgPersonInfo&ixPerson={0}\">{1}</a>", person.ixPerson, person.sFullName); }