void InitDataControls()
{
deDateCreation.DateTime = Comun.GetDate();
tbNumDaysValid.Value = new CSettings().GetNumDaysPriceDefault();
// --- init company
cbCompany.Properties.DataSource = new CCompanyFactory().GetAll();
cbCompany.Properties.DisplayMember = "Business_name";
cbCompany.Properties.ValueMember = "Idcompany";
// --- 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";
Reception oReception = new Reception();
// --- init type person
repPerson_type.DataSource = oReception.GetLstPersonType();
repPerson_type.DisplayMember = "Name";
repPerson_type.ValueMember = "Id";
// --- init methods
gcPrice.DataSource = new BindingList <PriceMethod>(new ModPrice().GetPriceMethod(null));
// --- init plantillas
CMemo_templateFactory faMemo_template = new CMemo_templateFactory();
gcParagraphHistoryIni.DataSource = faMemo_template.GetAll().Where(c => c.Memo_type == 1).ToList();
gcParagraphHistoryEnd.DataSource = faMemo_template.GetAll().Where(c => c.Memo_type == 2).ToList();
// --- init adjuntos
List <Anexos> list = new ModPrice().GetLstAnexos(null);
gcAnexos.DataSource = new BindingList <Anexos>(list);
}
protected override void Recuperar_Registro()
{
if (oPrice != null && oPrice_version != null)
{
tabHead.Text = oPrice.Cod_price;
tbCodPrice.Text = oPrice.Cod_price;
tbNumVersion.Text = oPrice_version.Num_version.ToString();
cbTypeSample.EditValue = oPrice_version.Cod_type_sample;
cbCompany.EditValue = oPrice_version.Idcompany;
deDateCreation.EditValue = oPrice_version.Date_creation;
tbNumDaysValid.Value = Convert.ToInt32(oPrice_version.Num_days_valid);
tbObservation.Text = oPrice_version.Observation;
// --- person
if (oPrice.Dispatch_person > 0)
{
ckDispatchPerson.Checked = true;
}
else
{
ckDispatchPerson.Checked = false;
}
// --- curier
if (oPrice.Dispatch_curier > 0)
{
ckDispatchCurier.Checked = true;
}
else
{
ckDispatchCurier.Checked = false;
}
// --- transport
if (oPrice.Dispatch_transport > 0)
{
ckDispatchTransport.Checked = true;
}
else
{
ckDispatchTransport.Checked = false;
}
// --- fax
if (oPrice.Dispatch_fax > 0)
{
ckDispatchFax.Checked = true;
}
else
{
ckDispatchFax.Checked = false;
}
// --- get contacts
gcContact.DataSource = new BindingList <CContact_price>(new ModPrice().GetLstContactsByPrice(oPrice.Idprice, oPrice_version.Idprice_version));
// --- recuperando métodos
List <PriceMethod> myLstPriceMethod = new ModPrice().GetPriceMethod(oPrice_version);
gcPrice.DataSource = new BindingList <PriceMethod>(myLstPriceMethod);
// --- recuperando parrafos
var lstmemo =
(from m in new CMemo_priceFactory().GetAll()
where m.Idprice_version == oPrice_version.Idprice_version
select new
{
m.Paragraph,
m.Memo_type
}).ToList();
foreach (var item in lstmemo)
{
if (item.Memo_type == 1)
{
richTextIni.RichTextBox.Rtf = item.Paragraph;
}
else if (item.Memo_type == 2)
{
richTextEnd.RichTextBox.Rtf = item.Paragraph;
}
}
// --- recuperar memo template
var lsttemplate_memo = new CMemo_templateFactory().GetAll();
gcParagraphHistoryIni.DataSource = lsttemplate_memo.Where(c => c.Memo_type == 1).ToList();
gcParagraphHistoryEnd.DataSource = lsttemplate_memo.Where(c => c.Memo_type == 2).ToList();
// --- recalcular tamaño de celdas de texto amplio
gvPrice.OptionsView.RowAutoHeight = true;
gvPrice.LayoutChanged();
gvParagraphHistoryIni.OptionsView.RowAutoHeight = true;
gvParagraphHistoryIni.LayoutChanged();
gvParagraphHistoryEnd.OptionsView.RowAutoHeight = true;
gvParagraphHistoryEnd.LayoutChanged();
// --- recuperar suma totales
SumTotals();
// --- recuperar reporte de cotización
ShowPreviewReport();
// --- recuperar archivos adjuntos
gcAnexos.DataSource = new BindingList <Anexos>(new ModPrice().GetLstAnexos(oPrice_version));
}
else
{
ckDispatchPerson.Checked = false;
ckDispatchCurier.Checked = true;
ckDispatchTransport.Checked = false;
ckDispatchFax.Checked = false;
}
}
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);
}
