protected void submitFacility(Object sender, EventArgs e)
{
//If null then this is creating a facility to add
if (selected_facility == null)
{
selected_facility = new facility();
selected_address = new address();
selected_address.line_1 = Address1.Text;
selected_address.line_2 = Address2.Text;
selected_address.city = CityName.Text;
selected_address.state = StateName.Text;
selected_address.zip = ZipName.Text;
db.addresses.InsertOnSubmit(selected_address);
db.SubmitChanges();
selected_facility.user_id = user_id;
selected_facility.name = FacilityName.Text;
selected_facility.address_id = selected_address.id;
selected_facility.add_date = DateTime.Now;
db.facilities.InsertOnSubmit(selected_facility);
db.SubmitChanges();
}
//If not then we are editing an existing facility
else
{
selected_facility.name = FacilityName.Text;
selected_address.line_1 = Address1.Text;
selected_address.line_2 = Address2.Text;
selected_address.city = CityName.Text;
selected_address.state = StateName.Text;
selected_address.zip = ZipName.Text;
db.SubmitChanges();
}
Response.Redirect("~/Pages/Inventory/Facilities.aspx");
}
public DriverForm(driver d)
{
InitializeComponent();
ControlsUtil.SetBackColor(this.Controls);
lbBirthday.Text = "";
bdgState.DataSource = state.Fetch("");
address ad;
if (d == null)
IsNew = true;
if (IsNew)
{
d = new driver() { birthday = null, admitted_at = null, dismissed_at = null, genre = -1 };
ad = new address();
btnFiles.Enabled = false;
}
else
{
ad = address.SingleOrDefault(d.address);
tfCpf.Properties.ReadOnly = true;
//tfNumberCnh.Properties.ReadOnly = true;
if (d.inactive)
{
pnGeneral.Enabled = false;
btnSave.Visible = false;
}
}
bdgAddress.DataSource = ad;
bdgDriver.DataSource = d;
DateTime now = driver.Now();
tfBirthday.Properties.MaxValue = now;
tfAdmittedAt.Properties.MaxValue = now;
tfDismissedAt.Properties.MaxValue = now;
}
public CustomerForm(customer c)
{
InitializeComponent();
ControlsUtil.SetBackColor(this.Controls);
bdgStates.DataSource = state.Fetch("ORDER BY symbol");
address d;
if (c == null)
IsNew = true;
if (IsNew)
{
c = new customer();
d = new address();
}
else
{
d = address.SingleOrDefault(c.address_id);
tfCnpj.Properties.ReadOnly = true;
tfIE.Properties.ReadOnly = true;
rgType.Properties.ReadOnly = true;
if (c.inactive || c.is_business)
{
pnData.Enabled = false;
pnAddress.Enabled = false;
}
}
bdgCustomer.DataSource = c;
bdgAddress.DataSource = d;
}
/// <summary>
/// Calls the Post method of the MessageDisposed Service
/// </summary>
/// <param name="messageId">MessageId of the message to be marked as Disposed</param>
/// <param name="address">Recipient Address Related to Disposition</param>
/// <param name="dispositionType">Disposition Type</param>
/// <param name="certificate">Client Certificate</param>
/// <returns>True if Successful</returns>
public static bool Post(Guid messageId, address address, dispositionType dispositionType, X509Certificate2 certificate)
{
using (var client = getMessagesClient(certificate))
{
return client.post(messageId, address, dispositionType);
}
}
public void loadFromCnpj(customer c, address d)
{
rgType.EditValue = c.type;
bdgCustomer.DataSource = c;
bdgAddress.DataSource = d;
IsNew = true;
subPnData.Enabled = true;
pnAddress.Enabled = true;
}
public void update(address editItem)
{
address selectedItem = db.addresses.SingleOrDefault(item => item.id == editItem.id);
selectedItem.buildingname = editItem.buildingname;
selectedItem.houseno = editItem.houseno;
selectedItem.street = editItem.street;
selectedItem.locality = editItem.locality;
selectedItem.postaltown = editItem.postaltown;
selectedItem.country = editItem.country;
selectedItem.postcode_id = editItem.postcode_id;
db.SaveChanges();
}
public address address_update(int ID)
{
address = address.Select(ID);
address.city = Update_Client_city_txt.Text;
address.country = Update_Client_country_txt.Text;
address.County_Township = Update_Client_County_Township_txt.Text;
address.longitude = Convert.ToDecimal(Update_Client_longitude_txt.Text);
address.latitude = Convert.ToDecimal(Update_Client_latitude_txt.Text);
address.state = Update_Client_state_txt.Text;
address.str_add = Update_Client_str_add_txt.Text;
address.str_add2 = Update_Client_str_add2_txt.Text;
address.zip_plus_four = Update_Client_zip_plus_four_txt.Text;
address.Update(address);
//GridView1.DataBind();
return address;
}
/////////////////////////////////////////////////////////////////////
/////////////////////////////////////////
//////////////////////
//Methods To Call
//INSERT
public address address_insert()
{
address.address_type_id = 1;
address.city = Insert_Client_city_txt.Text;
address.country = Insert_Client_country_txt.Text;
address.County_Township = Insert_Client_County_Township_txt.Text;
address.longitude = Convert.ToDecimal(Insert_Client_longitude_txt.Text);
address.latitude = Convert.ToDecimal(Insert_Client_latitude_txt.Text);
address.state = Insert_Client_state_txt.Text;
address.str_add = Insert_Client_str_add_txt.Text;
address.str_add2 = Insert_Client_str_add2_txt.Text;
address.zip_plus_four = Insert_Client_zip_plus_four_txt.Text;
address = address.Insert(address);
//GridView1.DataBind();
return address;
}
public CredentialedForm(credentialed c)
{
InitializeComponent();
ControlsUtil.SetBackColor(this.Controls);
try
{
SplashScreenManager.ShowForm(null, typeof(PleaseWaitForm), false, false, false);
if (c == null)
{
c = new credentialed();
_address = new address();
btnInactive.Enabled = false;
IsNew = true;
}
else
{
peLogo.Image = new FTPUtil().getImageFromFile(c.directory_logo);
pCNPJ.Enabled = false;
_address = address.SingleOrDefault(c.address_id);
pData.Enabled = true;
if (c.inactive)
{
btnInactive.Visible = false;
btnSave.Visible = false;
//pData.Enabled = false;
}
else
btnReceivePayment.Enabled = true;
IsNew = false;
}
bdgStates.DataSource = state.Fetch("");
bdgCredentialed.DataSource = c;
bdgAddress.DataSource = _address;
}
catch (Exception ex)
{
XtraMessageBox.Show(String.Format("Ocorreu um erro:\n\n{0}\n{1}", ex.Message, ex.InnerException));
btnSave.Enabled = false;
}
finally
{
SplashScreenManager.CloseForm(false);
}
}
public CustomerForm(customer c)
{
try
{
SplashScreenManager.ShowForm(null, typeof(PleaseWaitForm), false, false, false);
address ad;
InitializeComponent();
ControlsUtil.SetBackColor(this.Controls);
if (c == null)
{
c = new customer();
ad = new address();
IsNew = true;
}
else
{
IsNew = false;
ad = address.SingleOrDefault(c.address_id);
foreach (phones_customer pc in phones_customer.Fetch("WHERE customer_id=@0", c.id))
listPhones.Items.Add(pc.phone);
pePicture.Image = new FTPUtil().getImageFromFile(c.directory_picture);
cbOrganEmitter.EditValue = c.organ_emitter_rg.Split('/')[0];
cbStateRG.EditValue = c.organ_emitter_rg.Split('/')[1];
}
List<state> listS = state.Fetch("");
bdgStates.DataSource = listS;
foreach (state e in listS)
cbStateRG.Properties.Items.Add(e.symbol);
bdgOrganEmitter.DataSource = organ_emitter.Fetch("");
bdgAddress.DataSource = ad;
bdgCustomer.DataSource = c;
Validations.ValidatorCPFCNPJ vcpf = new Validations.ValidatorCPFCNPJ() { ErrorText = "O CPF informado é inválido." };
validatorCustomer.SetValidationRule(tfCPF, vcpf);
}
catch (Exception ex)
{
XtraMessageBox.Show(String.Format("Ocorreu um erro.\n\n{0}\n{1}", ex.Message, ex.InnerException));
}
finally
{
SplashScreenManager.CloseForm(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.RouteData.Values["facility_id"] != null)
{
facility_id = Convert.ToInt32(Page.RouteData.Values["facility_id"]);
selected_facility = (from f in db.facilities
where f.id == facility_id
select f).Single();
selected_address = (from a in db.addresses
where a.id == selected_facility.address_id
select a).Single();
if (!Page.IsPostBack)
{
FacilityName.Text = selected_facility.name;
Address1.Text = selected_address.line_1;
Address2.Text = selected_address.line_2;
CityName.Text = selected_address.city;
StateName.Text = selected_address.state;
ZipName.Text = selected_address.zip;
}
}
}
public void insert(address newItem)
{
db.addresses.Add(newItem);
db.SaveChanges();
}
protected void updateDatabase()
{
//product_id_array has all product ids
call_center = call_center.Select(Convert.ToInt32(DDL_Call_Center.SelectedValue));
selected_Warehouse = selected_Warehouse.Select(Convert.ToInt32(passWarehouseID_hf.Value));
address = address.Select(selected_Warehouse.address_id);
//case_intake
case_intake = case_intake_insert();
//encounter
encounter = encounter_insert();
//requestor
requestor = requestor_insert();
//requestor_Order
requestor_Order = requestor_Order_insert();
//Order_product
Order_Product = Order_Product_insert();
}
public orderDto()
{
address = new address();
}
protected void Save_Client_information()
{
decimal[] add1cord = new decimal[2];
decimal[] add2cord = new decimal[2];
clientperson.SetColumnDefaults();
clientAddress.SetColumnDefaults();
clientAddress2.SetColumnDefaults();
client.SetColumnDefaults();
clientperson.person_id = GlobalVariables.PersonID;
clientperson.address_id = GlobalVariables.ClientAddressID;
clientperson.address_id2 = GlobalVariables.ClientAddressID2;
clientAddress.address_id = GlobalVariables.ClientAddressID;
clientAddress2.address_id = GlobalVariables.ClientAddressID2;
client.client_id = GlobalVariables.ClientID;
client.Info_Field = null;
clientperson.f_name = txt_F_Name.Text;
clientperson.l_name = txt_L_Name.Text;
clientperson.person_type = "C";
clientperson.m_initial = txt_M_Initial.Text;
clientperson.Maiden_Name = txt_Maiden_Name.Text;
clientperson.gender = ddl_Gender.SelectedValue;
clientperson.email = txt_email.Text;
if (txt_SSN.Text != "")
{
clientperson.ssn = Convert.ToInt32(txt_SSN.Text);
}
clientperson.Driver_State_ID = txt_DrvLic.Text;
if (txt_Birthdate.Text != "")
{
clientperson.birthdate = Convert.ToDateTime(txt_Birthdate.Text);
}
clientperson.phone_primary = txt_Phone_Primary.Text;
clientperson.phone_secondary = txt_Phone_Secondary.Text;
clientperson.Marital_Status = ddl_Marital_Status.SelectedValue.ToString();
clientperson.Citizenship = ddl_CitizenShip.SelectedValue.ToString();
Set_Visa_Type();
if (TxtVisaIssDate.Text != "")
{
clientperson.Visa_Issue_Date = Convert.ToDateTime(TxtVisaIssDate.Text.ToString());
}
if (TxtVisaExpDate.Text != "")
{
clientperson.Visa_Expire_Date = Convert.ToDateTime(TxtVisaExpDate.Text.ToString());
}
if (TxtUSCISNum.Text != "")
{
clientperson.Perm_Resident_Alien_USCIS_number = Convert.ToInt32(TxtUSCISNum.Text);
}
if (TxtANumber.Text != "")
{
clientperson.Perm_Resident_Alien_A_number = Convert.ToInt32(TxtANumber.Text);
}
if (TxtresDate.Text != "")
{
clientperson.Perm_Resident_Alien_Resid_Date = Convert.ToDateTime(TxtresDate.Text);
}
if (TxtResExpDate.Text != "")
{
clientperson.Perm_Resident_Alien_Expire_Date = Convert.ToDateTime(TxtResExpDate.Text);
}
clientperson.Perm_Resident_Alien_Birth_Country = TxtCountryOfBirth.Text;
clientperson.Perm_Resident_Alien_Category = TxtCategory.Text;
clientAddress.address_type_id = 2;
clientAddress.str_add = txtCurr_str_addr.Text;
clientAddress.str_add2 = TxtCurr_str_addr2.Text;
clientAddress.city = txtCurr_city.Text;
clientAddress.state = ddlCurr_st.SelectedValue;
clientAddress.zip_plus_four = txtCurr_zip.Text;
clientAddress.country = TxtCurr_Country.Text;
clientAddress.County_Township = TxtCurr_CountyTownship.Text;
add1cord = GeoLocation.getCoordinates(clientAddress.str_add, clientAddress.str_add2, clientAddress.city, clientAddress.state, clientAddress.zip_plus_four, "DMCS");
clientAddress.latitude = add1cord[0];
clientAddress.longitude = add1cord[1];
client.client_status = ddl_client_status.SelectedValue;
if (clientAddress.address_id == 0)
{
clientAddress = clientAddress.Insert(clientAddress);
clientperson.address_id = clientAddress.address_id;
}
else
{
clientAddress.Update(clientAddress);
}
if (txtPrev_city.Text != "" && TxtPrev_Country.Text != "" &&
ddlPrev_st.SelectedValue != "" && txtPrev_str_addr.Text != "")
{
clientAddress2.address_type_id = 3;
clientAddress2.str_add = txtPrev_str_addr.Text;
clientAddress2.str_add2 = txtPrev_str_addr2.Text;
clientAddress2.city = txtPrev_city.Text;
clientAddress2.state = ddlPrev_st.SelectedValue;
clientAddress2.zip_plus_four = txtPrev_zip.Text;
clientAddress2.str_add2 = txtPrev_str_addr2.Text;
clientAddress2.country = TxtPrev_Country.Text;
clientAddress2.County_Township = TxtPrev_countyTownship.Text;
add2cord = GeoLocation.getCoordinates(clientAddress2.str_add, clientAddress2.str_add2, clientAddress2.city, clientAddress2.state, clientAddress2.zip_plus_four, "DMCS");
clientAddress2.latitude = add2cord[0];
clientAddress2.longitude = add2cord[1];
if (clientAddress2.address_id == 0)
{
clientAddress2 = clientAddress2.Insert(clientAddress2);
clientperson.address_id2 = clientAddress2.address_id;
}
else
{
clientAddress2.Update(clientAddress2);
}
}
if (clientperson.person_id == 0)
{
clientperson = clientperson.Insert(clientperson);
}
else
{
clientperson.Update(clientperson);
}
if (client.client_id == 0)
{
client.client_id = clientperson.person_id;
client = client.Insert(client);
}
else
{
client.Update(client);
}
}
protected void fill_Client_information()
{
client = client.Select(GlobalVariables.PersonID);
GlobalVariables.ClientID = client.client_id;
clientAddress = clientAddress.Select(clientperson.address_id);
clientAddress2 = clientAddress2.Select(clientperson.address_id2);
GlobalVariables.ClientAddressID = clientAddress.address_id;
GlobalVariables.ClientAddressID2 = clientAddress2.address_id;
ddl_client_status.SelectedValue = client.client_status;
txt_L_Name.Text = clientperson.l_name.ToString();
txt_F_Name.Text = clientperson.f_name.ToString();
txt_M_Initial.Text = clientperson.m_initial.ToString();
txt_email.Text = clientperson.email.ToString();
txt_Maiden_Name.Text = clientperson.Maiden_Name.ToString();
ddl_Gender.SelectedValue = clientperson.gender;
txt_SSN.Text = clientperson.ssn.ToString();
txt_DrvLic.Text = clientperson.Driver_State_ID;
txt_Birthdate.Text = clientperson.birthdate.ToString();
txt_Phone_Primary.Text = clientperson.phone_primary;
txt_Phone_Secondary.Text = clientperson.phone_secondary;
ddl_Marital_Status.SelectedValue = clientperson.Marital_Status;
ddl_CitizenShip.SelectedValue = clientperson.Citizenship;
get_visa_type();
TxtVisaIssDate.Text = clientperson.Visa_Issue_Date.ToString();
TxtVisaExpDate.Text = clientperson.Visa_Expire_Date.ToString();
TxtUSCISNum.Text = clientperson.Perm_Resident_Alien_USCIS_number.ToString();
TxtANumber.Text = clientperson.Perm_Resident_Alien_A_number.ToString();
TxtresDate.Text = clientperson.Perm_Resident_Alien_Resid_Date.ToString();
TxtResExpDate.Text = clientperson.Perm_Resident_Alien_Expire_Date.ToString();
TxtCountryOfBirth.Text = clientperson.Perm_Resident_Alien_Birth_Country;
TxtCategory.Text = clientperson.Perm_Resident_Alien_Category;
txtCurr_str_addr.Text = clientAddress.str_add;
TxtCurr_str_addr2.Text = clientAddress.str_add2;
txtCurr_city.Text = clientAddress.city;
if (clientAddress.state != null)
{
ddlCurr_st.SelectedValue = clientAddress.state;
}
txtCurr_zip.Text = clientAddress.zip_plus_four.ToString();
TxtCurr_Country.Text = clientAddress.country;
TxtCurr_CountyTownship.Text = clientAddress.County_Township;
txtPrev_str_addr.Text = clientAddress2.str_add;
txtPrev_str_addr2.Text = clientAddress2.str_add2;
txtPrev_city.Text = clientAddress2.city;
if (clientAddress2.state != "")
{
ddlPrev_st.SelectedValue = clientAddress2.state;
}
txtPrev_zip.Text = clientAddress2.zip_plus_four.ToString();
TxtPrev_Country.Text = clientAddress2.country;
TxtPrev_countyTownship.Text = clientAddress2.County_Township;
}
private static bool HasSameName(address c, Contact f)
{
return(c.name == f.Firstname + " " + f.Surname);
}
public ActionResult Add(FormCollection form, int id, String msg = null)
{
ViewBag.m = msg;
List <SelectListItem> CustomerInfo = new List <SelectListItem>();
CustomerInfo.AddRange(db.customers.Where(x => x.deleted != true).Select(a => new SelectListItem
{
Text = a.customer_lastname,
Selected = false,
Value = a.customer_number.ToString()
}));
var ClassInfo = new List <SelectListItem>();
ClassInfo.AddRange(db.project_class.Where(x => x.deleted != true).Select(LLL => new SelectListItem
{
Text = LLL.class_name,
Selected = false,
Value = LLL.class_number.ToString()
}));
var StatusInfo = new List <SelectListItem>();
StatusInfo.AddRange(db.project_status.Where(x => x.deleted != true).Select(c => new SelectListItem
{
Text = c.project_status_name,
Selected = false,
Value = c.project_status_number.ToString()
}));
var ProjectTypeInfo = new List <SelectListItem>();
ProjectTypeInfo.AddRange(db.project_type.Where(x => x.deleted != true).Select(VVVb => new SelectListItem
{
Text = VVVb.project_type_name,
Selected = false,
Value = VVVb.project_type_number.ToString()
}));
var SourceInfo = new List <SelectListItem>();
SourceInfo.AddRange(db.lead_source.Where(x => x.deleted != true).Select(ffb => new SelectListItem
{
Text = ffb.source_name,
Selected = false,
Value = ffb.source_number.ToString()
}));
var AddressInfo = new List <SelectListItem>();
AddressInfo.AddRange(db.addresses.Where(x => x.deleted != true).Select(a => new SelectListItem
{
Text = a.address_type,
Selected = false,
Value = a.address_number.ToString()
}));
var AddressCityInfo = new List <SelectListItem>();
var EmpInfo = new List <SelectListItem>();
EmpInfo.AddRange(db.employees.Where(x => x.deleted != true).Select(a => new SelectListItem
{
Text = a.emp_firstname + " " + a.emp_lastname,
Selected = false,
Value = a.emp_number.ToString()
}));
var BranchInfo = new List <SelectListItem>();
BranchInfo.AddRange(db.branches.Where(x => x.deleted != true).Select(a => new SelectListItem
{
Text = a.branch_name,
Selected = false,
Value = a.branch_number.ToString()
}));
var DeliveryStatusInfo = new List <SelectListItem>();
DeliveryStatusInfo.AddRange(db.delivery_status.Select(a => new SelectListItem
{
Text = a.delivery_status_name,
Selected = false,
Value = a.delivery_status_number.ToString()
}));
var TaxExemptInfo = new List <SelectListItem> {
new SelectListItem()
{
Text = "Taxable", Value = "0"
},
new SelectListItem {
Text = "Tax Exempt", Value = "1"
}
};
ViewBag.TaxExemptInfo = TaxExemptInfo;
//setting variable passing
ViewBag.Customer_Info = CustomerInfo;
ViewBag.Class_Info = ClassInfo;
ViewBag.Status_Info = StatusInfo;
ViewBag.ProjectType_Info = ProjectTypeInfo;
ViewBag.Source_Info = SourceInfo;
ViewBag.Address_Info = AddressInfo;
ViewBag.Emp_Info = EmpInfo;
ViewBag.Branch_Info = BranchInfo;
ViewBag.DeliveryStatus_Info = DeliveryStatusInfo;
var Sstate = new List <SelectListItem> {
new SelectListItem()
{
Text = "Alabama", Value = "AL"
},
new SelectListItem()
{
Text = "Alaska", Value = "AK"
},
new SelectListItem()
{
Text = "Arizona", Value = "AZ"
},
new SelectListItem()
{
Text = "Arkansas", Value = "AR"
},
new SelectListItem()
{
Text = "California", Value = "CA"
},
new SelectListItem()
{
Text = "Colorado", Value = "CO"
},
new SelectListItem()
{
Text = "Connecticut", Value = "CT"
},
new SelectListItem()
{
Text = "District of Columbia", Value = "DC"
},
new SelectListItem()
{
Text = "Delaware", Value = "DE"
},
new SelectListItem()
{
Text = "Florida", Value = "FL"
},
new SelectListItem()
{
Text = "Georgia", Value = "GA"
},
new SelectListItem()
{
Text = "Hawaii", Value = "HI"
},
new SelectListItem()
{
Text = "Idaho", Value = "ID"
},
new SelectListItem()
{
Text = "Illinois", Value = "IL"
},
new SelectListItem()
{
Text = "Indiana", Value = "IN"
},
new SelectListItem()
{
Text = "Iowa", Value = "IA"
},
new SelectListItem()
{
Text = "Kansas", Value = "KS"
},
new SelectListItem()
{
Text = "Kentucky", Value = "KY"
},
new SelectListItem()
{
Text = "Louisiana", Value = "LA"
},
new SelectListItem()
{
Text = "Maine", Value = "ME"
},
new SelectListItem()
{
Text = "Maryland", Value = "MD"
},
new SelectListItem()
{
Text = "Massachusetts", Value = "MA"
},
new SelectListItem()
{
Text = "Michigan", Value = "MI"
},
new SelectListItem()
{
Text = "Minnesota", Value = "MN"
},
new SelectListItem()
{
Text = "Mississippi", Value = "MS"
},
new SelectListItem()
{
Text = "Missouri", Value = "MO"
},
new SelectListItem()
{
Text = "Montana", Value = "MT"
},
new SelectListItem()
{
Text = "Nebraska", Value = "NE"
},
new SelectListItem()
{
Text = "Nevada", Value = "NV"
},
new SelectListItem()
{
Text = "New Hampshire", Value = "NH"
},
new SelectListItem()
{
Text = "New Jersey", Value = "NJ"
},
new SelectListItem()
{
Text = "New Mexico", Value = "NM"
},
new SelectListItem()
{
Text = "New York", Value = "NY"
},
new SelectListItem()
{
Text = "North Carolina", Value = "NC"
},
new SelectListItem()
{
Text = "North Dakota", Value = "ND"
},
new SelectListItem()
{
Text = "Ohio", Value = "OH"
},
new SelectListItem()
{
Text = "Oklahoma", Value = "OK"
},
new SelectListItem()
{
Text = "Oregon", Value = "OR"
},
new SelectListItem()
{
Text = "Pennsylvania", Value = "PA"
},
new SelectListItem()
{
Text = "Rhode Island", Value = "RI"
},
new SelectListItem()
{
Text = "South Carolina", Value = "SC"
},
new SelectListItem()
{
Text = "South Dakota", Value = "SD"
},
new SelectListItem()
{
Text = "Tennessee", Value = "TN"
},
new SelectListItem()
{
Text = "Texas", Value = "TX"
},
new SelectListItem()
{
Text = "Utah", Value = "UT"
},
new SelectListItem()
{
Text = "Vermont", Value = "VT"
},
new SelectListItem()
{
Text = "Virginia", Value = "VA"
},
new SelectListItem()
{
Text = "Washington", Value = "WA"
},
new SelectListItem()
{
Text = "West Virginia", Value = "WV"
},
new SelectListItem()
{
Text = "Wisconsin", Value = "WI"
},
new SelectListItem()
{
Text = "Wyoming", Value = "WY"
}
};
ViewBag.Sstate = Sstate;
try
{
lead target = new lead();
{
target.customer = db.customers.Where(aa => aa.customer_number == id).FirstOrDefault();
int a = Int32.Parse(form["class_number"]);
target.project_class = db.project_class.Where(KL => KL.class_number == a).FirstOrDefault();
int c = Int32.Parse(form["project_type_number"]);
target.project_type = db.project_type.Where(GH => GH.project_type_number == c).FirstOrDefault();
int dd = Int32.Parse(form["source_number"]);
target.lead_source = db.lead_source.Where(TY => TY.source_number == dd).FirstOrDefault();
int ee = Int32.Parse(form["source_number"]);
target.lead_source = db.lead_source.Where(qq => qq.source_number == ee).FirstOrDefault();
int ff = Int32.Parse(form["emp_number"]);
target.employee = db.employees.Where(ww => ww.emp_number == ff).FirstOrDefault();
int gg = Int32.Parse(form["branch_number"]);
target.branch = db.branches.Where(ss => ss.branch_number == gg).FirstOrDefault();
int hh = Int32.Parse(form["delivery_status_number"]);
target.delivery_status = db.delivery_status.Where(xx => xx.delivery_status_number == hh).FirstOrDefault();
target.in_city = Convert.ToBoolean(form["Item1.in_city"].Split(',')[0]);
string aaa = form["Item1.in_city"];
// target.tax_exempt = Convert.ToBoolean(form["Item1.tax_exempt"].Split(',')[0]);
target.tax_exempt = string.Equals(form["tax_exempt"], "1")?true:false;
target.project_name = form["Item1.project_name"];
target.phone_number = form["Item1.phone_number"];
target.second_phone_number = form["Item1.second_phone_number"];
target.email = form["Item1.email"];
target.lead_creator = User.Identity.GetUserName();
target.note = form["Item1.note"];
target.deleted = false;
// target.address_number = b.address_number;
target.project_status_number = 3;
target.lead_date = System.DateTime.Now;
target.Last_update_date = System.DateTime.Now;
};
db.leads.Add(target);
db.SaveChanges();
address b = new address
{
address1 = form["Item2.address1"],
address_type = "JobAddress",
city = form["Item2.city"],
// state = form["state"],
state = form["state1"],
county = form["Item2.county"],
zipcode = form["Item2.zipcode"],
deleted = false,
lead_number = target.lead_number
};
db.addresses.Add(b);
db.SaveChanges();
if (string.IsNullOrEmpty(form["Item3.address1"]))
{
}
else
{
address BC = new address
{
address1 = form["Item3.address1"],
// address_type = form["Item2.address_type"],
address_type = "alternativeAddress",
city = form["Item3.city"],
state = form["state2"],
// state = form["state"],
// state = "Not fixed yet",
county = form["Item3.county"],
zipcode = form["Item3.zipcode"],
deleted = false,
lead_number = target.lead_number
};
db.addresses.Add(BC);
db.SaveChanges();
}
ViewBag.m = " The lead was successfully created to " + target.customer.customer_firstname + " " + target.customer.customer_lastname + " on " + System.DateTime.Now;
return(RedirectToAction("Edit/" + target.lead_number, "lead", new { msg = ViewBag.m }));
}
catch (Exception e)
{
ViewBag.m = "The lead was not created ..." + e.Message;
return(View());
}
}
public ApiMessage <bool> Save(address model)
{
model.UserID = UserInfo.Id;
model.CreateDate = DateTime.Now;
return(bll.Save(model));
}
public static void InsertAddress(address insertadd)
{
DAL.InsertAddress(insertadd);
}
public MeetTest(int testId, string teacherId, string studentId, DateTime time, address testAddress, bool distanceKeeping, bool reverseParking, bool lookingAtMirrors, bool signaling, int testGrade, string testersNote)
{
this.TestId = testId;
this.TeacherId = teacherId;
this.StudentId = studentId;
this.Time = time;
this.TestAddress = testAddress;
this.DistanceKeeping = distanceKeeping;
this.ReverseParking = reverseParking;
this.LookingAtMirrors = lookingAtMirrors;
this.Signaling = signaling;
this.TestGrade = testGrade;
this.TestersNote = testersNote;
group = new List <string>();
//
}
public void replaceAddress(address addr)
{
string str = str = "replace into all_address (name, lat, lon) values ('" + addr.name + "', " + addr.pos.Lat + ", " + addr.pos.Lng + ")";
excuteCommand(str);
}
public void insert(address newItem)
{
db.addresses.Add(newItem);
db.SaveChanges();
}
public address selectSingle(address findItem)
{
address selectedItem = db.addresses.SingleOrDefault(item => item.id == findItem.id);
return(selectedItem);
}
private static bool HasSameICO(address c, Contact f)
{
return(c.ico is string && ((string)c.ico).Length > 0 && ((string)c.ico) == f.IdentificationNumber);
}
protected void createInvoicePreview()
{
//create invoice preview
final_invoice_div.Style.Add("display", "block");
FINAL_to_Name_L.Text = selected_Warehouse.warehouse_name;
FINAL_to_CompanyName_L.Text = selected_Warehouse.warehouse_name;
FINAL_to_StreetAddress_L.Text = address.str_add;
FINAL_to_CityStateZip_L.Text = address.city + " " + address.state + " " + address.zip_plus_four;
FINAL_caseNumber_L.Text = "Case #/Order #: " + case_intake.case_id + " / " + requestor_Order.OrderID;
FINAL_date_L.Text = Convert.ToString(DateTime.Now);
for (int i = 0; i < product_id_array.Length; i++)
{
products = products.Select(Convert.ToInt32(product_id_array[i]));
warehouse_product_location = warehouse_product_location.Select_By_Product_ID(products.product_id);
warehouse = warehouse.Select(warehouse_product_location.warehouse_id);
checkWarehouseIDs.Add(warehouse.warehouse_id);
for (int j = 0; j < checkWarehouseIDs.Count; j++)
{
if (warehouse.warehouse_id != checkWarehouseIDs[j] || checkWarehouseIDs.Count == 1)
{
selectedWarehouseIDs.Add(warehouse.warehouse_id);
}
}
int itemNum = i + 1;
FINAL_orderNum_div.InnerHtml += itemNum + "<br/>";
FINAL_ProductID_and_WarehouseID_div.InnerHtml += products.product_id + " / " + warehouse.warehouse_id + "<br/>";
FINAL_orderQTY_div.InnerHtml += 1 + "<br/>";
FINAL_orderDESCRIPTION_div.InnerHtml += products.product_name + "<br/>";
}
FINAL_from_Name_L.Text = "";
FINAL_from_CompanyName_L.Text = "";
FINAL_from_StreetAddress_L.Text = "";
FINAL_from_CityStateZip_L.Text = "";
for (int k = 0; k < selectedWarehouseIDs.Count; k++)
{
warehouse = warehouse.Select(selectedWarehouseIDs[k]);
address = address.Select(warehouse.address_id);
if (selectedWarehouseIDs[k] == selectedWarehouseIDs.Count - 1 && selectedWarehouseIDs.Count > 0)
{
FINAL_from_Name_L.Text += selectedWarehouseIDs[k] + ": " + warehouse.warehouse_name + " | ";
FINAL_from_CompanyName_L.Text += selectedWarehouseIDs[k] + ": " + warehouse.warehouse_name + " | ";
FINAL_from_StreetAddress_L.Text += selectedWarehouseIDs[k] + ": " + address.str_add + " | ";
FINAL_from_CityStateZip_L.Text += selectedWarehouseIDs[k] + ": " + address.city + " " + address.state + " " + address.zip_plus_four + " | ";
}
else if (selectedWarehouseIDs[k] != selectedWarehouseIDs.Count - 1 && selectedWarehouseIDs.Count > 0)
{
FINAL_from_Name_L.Text += selectedWarehouseIDs[k] + ": " + warehouse.warehouse_name;
FINAL_from_CompanyName_L.Text += selectedWarehouseIDs[k] + ": " + warehouse.warehouse_name;
FINAL_from_StreetAddress_L.Text += selectedWarehouseIDs[k] + ": " + address.str_add;
FINAL_from_CityStateZip_L.Text += selectedWarehouseIDs[k] + ": " + address.city + " " + address.state + " " + address.zip_plus_four;
}
else
{
FINAL_from_Name_L.Text += warehouse.warehouse_name;
FINAL_from_CompanyName_L.Text += warehouse.warehouse_name;
FINAL_from_StreetAddress_L.Text += address.str_add;
FINAL_from_CityStateZip_L.Text += address.city + " " + address.state + " " + address.zip_plus_four;
}
}
placeOrder_div.Style.Add("display", "none");
}
set => Write(address, value);
set => write(address, value);
private Contact MatchContact(address c)
{
return(_prefetchedContacts.FirstOrDefault(f => HasSameICO(c, f) || HasSameName(c, f)));
}
//select a client and display data
protected void Update_gvClientSearchresult_SelectedIndexChanged(object sender, EventArgs e)
{
person = person.Select(Convert.ToInt32(Update_gvClientSearchresult.SelectedDataKey.Value));
GlobalVariables.PersonID = Convert.ToInt32(Update_gvClientSearchresult.SelectedDataKey.Value);
address = address.Select(person.address_id);
missing = missing.Select(person.person_id);
deceased = deceased.Select(person.person_id);
client = client.Select(person.person_id);
GlobalVariables.ClientID = client.client_id;
Update_LocationDiscription_txt.Text = missing.last_known_location;
Update_reason_of_death_txt.Text = deceased.reason_of_death;
Update_time_of_death_txt.Text = Convert.ToString(deceased.time_of_death);
Update_identifying_marks_txt.Text = deceased.identifying_marks;
Update_external_exam_txt.Text = deceased.external_exam;
Update_date_of_autopsy_txt.Text = Convert.ToString(deceased.date_of_autopsy.ToShortDateString());
Update_internal_exam_txt.Text = deceased.external_exam;
Update_client_other_info_txt.Text = missing.client_other_info;
Update_Client_latitude_txt.Text = Convert.ToString(address.latitude);
Update_Client_longitude_txt.Text = Convert.ToString(address.longitude);
Update_Client_zip_plus_four_txt.Text = Convert.ToString(address.zip_plus_four);
Update_Client_str_add2_txt.Text = address.str_add;
Update_Client_str_add_txt.Text = address.str_add2;
Update_Client_County_Township_txt.Text = address.County_Township;
Update_Client_country_txt.Text = address.country;
Update_Client_state_txt.Text = address.state;
Update_Client_city_txt.Text = address.city;
Update_hair_color_ddl.SelectedValue = client.hair_color;
Update_skin_color_ddl.SelectedValue = client.skin_color;
Update_eye_color_ddl.SelectedValue = client.eye_color;
Update_ethnicity_txt.Text = client.ethnicity;
Update_weight_txt.Text = Convert.ToString(client.weight);
Update_height_ddl.SelectedValue = Convert.ToString(client.height);
Update_date_of_disappearance_txt.Text = Convert.ToString(missing.date_of_disappearance.ToShortDateString());
Update_clothing_txt.Text = missing.clothing;
Update_phone_primary_txt.Text = person.phone_primary;
Update_ssn_txt.Text = Convert.ToString(person.ssn);
Update_gender_ddl.SelectedValue = person.gender;
Update_l_name_txt.Text = person.l_name;
Update_m_initial_txt.Text = person.m_initial;
Update_f_name_txt.Text = person.f_name;
//change condishions
Update_txtFirstName.Text = person.f_name.ToString();
Update_txtLastName.Text = person.l_name.ToString();
if (client.client_status == "D")
{
Update_Deceased_Div.Style.Add("display", "block");
Update_deceasedYes.Checked = true;
Update_missingYes.Checked = false;
}
else
{
Update_Deceased_Div.Style.Add("display", "none");
Update_deceasedYes.Checked = false;
Update_missingYes.Checked = true;
}
Update_sClient_L.Text = "</br>" + person.f_name + " " + person.l_name + " is selected.";
}
public Teacher(string id, string firstName, string lastName, DateTime birthDay, address adress, string phoneNumber, int maxHoursPerWeek, int maxKMFromHome, Schedule hours, typecar carTypeSpecialization, gearbox gear, int seniorityYears, Gender gender)
{
Id = id;
FirstName = firstName;
LastName = lastName;
BirthDay = birthDay;
Adress = adress;
PhoneNumber = phoneNumber;
this.maxHoursPerWeek = maxHoursPerWeek;
this.maxKMFromHome = maxKMFromHome;
Hours = hours;
this.carTypeSpecialization = carTypeSpecialization;
Gear = gear;
SeniorityYears = seniorityYears;
this.gender = gender;
Hours = new Schedule();
group = new List <string>();
}
/// <summary>
/// Primary constructor for the query_sm PDU
/// </summary>
/// <param name="msgid">Message ID of the message whose state is being queried.</param>
/// <param name="saddr">Source Address of the original request</param>
public query_sm(string msgid, address saddr)
: this()
{
this.MessageID = msgid;
this.SourceAddress = saddr;
}
/// <summary>
/// Primary constructor for the list_dls PDU
/// </summary>
/// <param name="source">ESME source address</param>
public list_dls(address source)
: this()
{
this.Address = source;
}
private void cbAddress_SelectedIndexChanged(object sender, EventArgs e)
{
address a = (address)cbAddress.SelectedItem;
filter.address = a.addressId;
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="address">address表实例</param>
/// <returns>int</returns>
public int Insert(address addressExample)
{
sqlstr = "insert into address (aAddress,aCity,aDistrict,aid,aPostNumber,aProvince,aremark,astate)values(@aAddress,@aCity,@aDistrict,@aid,@aPostNumber,@aProvince,@aremark,@astate)";
return(ExecuteNonQuery(GetOleDbParameter(addressExample)));
}
/// <summary>
/// The set regulatory.
/// </summary>
/// <param name="address">
/// The address.
/// </param>
/// <param name="regulatoryAddress">
/// The regulatory address.
/// </param>
public static void SetRegulatory(this address address, IAddress regulatoryAddress)
{
address.RegulatoryId = regulatoryAddress.Id;
}
/// <summary>
/// 更新
/// </summary>
/// <param name="address">address表实例</param>
/// <returns>int</returns>
public int Update(address addressExample)
{
sqlstr = "update address set aAddress=@aAddress,aCity=@aCity,aDistrict=@aDistrict,aPostNumber=@aPostNumber,aProvince=@aProvince,aremark=@aremark,astate=@astate where aid=" + addressExample.aid;
return(ExecuteNonQuery(GetOleDbParameter(addressExample)));
}
protected void Save_Employer_info()
{
decimal[] emplradd = new decimal[2];
clientEmplrAddress.address_id = GlobalVariables.EmplrAddressID;
clientemployer.emplr_id = GlobalVariables.EmployerID;
clientEmplrAddress.address_type_id = 2;
clientEmplrAddress.str_add = txtempr_str_addr.Text;
clientEmplrAddress.str_add2 = Txtempr_str_addr2.Text;
clientEmplrAddress.city = txtempr_city.Text;
clientEmplrAddress.state = ddlempr_st.SelectedValue;
clientEmplrAddress.zip_plus_four = txtempr_zip.Text;
clientEmplrAddress.country = TxtEmpr_Country.Text;
clientEmplrAddress.County_Township = Txtempr_CountyTownship.Text;
emplradd = GeoLocation.getCoordinates(clientEmplrAddress.str_add, clientEmplrAddress.str_add2, clientEmplrAddress.city, clientEmplrAddress.state, clientEmplrAddress.zip_plus_four, "DMCS");
clientEmplrAddress.latitude = emplradd[0];
clientEmplrAddress.longitude = emplradd[1];
if (clientEmplrAddress.address_id == 0)
{
clientEmplrAddress = clientEmplrAddress.Insert(clientEmplrAddress);
}
else
{
clientEmplrAddress.Update(clientEmplrAddress);
}
clientemployer.address_id = clientEmplrAddress.address_id;
clientemployer.case_id = clientCase_intake.case_id;
clientemployer.client_id = client.client_id;
clientemployer.emplr_name = TxtEmplr_Name.Text;
clientemployer.emplr_phone = TxtEmplr_Phone.Text;
if (TxtEmpSrtDate.Text != "")
{
clientemployer.strt_date = Convert.ToDateTime(TxtEmpSrtDate.Text);
}
if (TxtEmpEndDate.Text != "")
{
clientemployer.end_date = Convert.ToDateTime(TxtEmpEndDate.Text);
}
else
{
clientemployer.end_date = Convert.ToDateTime("9/9/9999");
}
clientemployer.term_reason = TxtTermReas.Text;
if (clientemployer.emplr_id == 0)
{
clientemployer = clientemployer.Insert(clientemployer);
}
else
{
clientemployer.Update(clientemployer);
}
}
/// <summary>
/// 根据表,获取一个OleDbParameter数组
/// </summary>
/// <returns>OleDbParameter[]</returns>
public static OleDbParameter[] GetOleDbParameter(address addressExample)
{
List <OleDbParameter> list_param = new List <OleDbParameter>();
if (!string.IsNullOrEmpty(addressExample.aAddress))
{
list_param.Add(new OleDbParameter("@aAddress", addressExample.aAddress));
}
else
{
list_param.Add(new OleDbParameter("@aAddress", DBNull.Value));
}
if (!string.IsNullOrEmpty(addressExample.aCity))
{
list_param.Add(new OleDbParameter("@aCity", addressExample.aCity));
}
else
{
list_param.Add(new OleDbParameter("@aCity", DBNull.Value));
}
if (!string.IsNullOrEmpty(addressExample.aDistrict))
{
list_param.Add(new OleDbParameter("@aDistrict", addressExample.aDistrict));
}
else
{
list_param.Add(new OleDbParameter("@aDistrict", DBNull.Value));
}
if (!string.IsNullOrEmpty(addressExample.aPostNumber))
{
list_param.Add(new OleDbParameter("@aPostNumber", addressExample.aPostNumber));
}
else
{
list_param.Add(new OleDbParameter("@aPostNumber", DBNull.Value));
}
if (!string.IsNullOrEmpty(addressExample.aProvince))
{
list_param.Add(new OleDbParameter("@aProvince", addressExample.aProvince));
}
else
{
list_param.Add(new OleDbParameter("@aProvince", DBNull.Value));
}
if (!string.IsNullOrEmpty(addressExample.aremark))
{
list_param.Add(new OleDbParameter("@aremark", addressExample.aremark));
}
else
{
list_param.Add(new OleDbParameter("@aremark", DBNull.Value));
}
if (!string.IsNullOrEmpty(addressExample.astate))
{
list_param.Add(new OleDbParameter("@astate", addressExample.astate));
}
else
{
list_param.Add(new OleDbParameter("@astate", DBNull.Value));
}
OleDbParameter[] param = new OleDbParameter[list_param.Count];
int index = 0;
foreach (OleDbParameter p in list_param)
{
param[index] = p;
index++;
}
return(param);
}
protected void fill_employer_info()
{
String whereclause = "Client_id = " + clientcase.client_id + " and Case_Id = " + clientcase.case_id;
DataTable dt = clientemployer.Select(whereclause);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
TxtEmplr_Name.Text = dr.Field<String>(4);
TxtEmplr_Phone.Text = dr.Field<String>(5);
TxtEmpSrtDate.Text = Convert.ToString(dr.Field<DateTime>(7));
TxtEmpEndDate.Text = Convert.ToString(dr.Field<DateTime>(6));
TxtTermReas.Text = dr.Field<String>(8);
clientEmplrAddress = clientEmplrAddress.Select(dr.Field<int>(3));
GlobalVariables.EmplrAddressID = dr.Field<int>(3);
GlobalVariables.EmployerID = dr.Field<int>(0);
if (clientEmplrAddress.address_id != 0)
{
txtempr_str_addr.Text = clientEmplrAddress.str_add;
Txtempr_str_addr2.Text = clientEmplrAddress.str_add2;
txtempr_city.Text = clientEmplrAddress.city;
ddlempr_st.SelectedValue = clientEmplrAddress.state;
txtempr_zip.Text = clientEmplrAddress.zip_plus_four.ToString();
TxtEmpr_Country.Text = clientEmplrAddress.country;
Txtempr_CountyTownship.Text = clientEmplrAddress.County_Township;
}
}
}
public ActionResult Edit([Bind(Include = "Venue_ID,Venue_Name,Venue_Description,Venue_Size,Address_ID")] venue venue, address address)
{
bool val = db.venues.Any(s => s.Venue_Name == venue.Venue_Name && s.Venue_ID != venue.Venue_ID);
if (val == false)
{
//address.Address_ID = venue.Address_ID;
db.Entry(address).State = EntityState.Modified;
db.Entry(venue).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else if (val == true)
{
ViewBag.StatusMessage = "There is already a venue called: " + venue.Venue_Name + " in the database.";
ViewBag.Address_ID = new SelectList(db.addresses, "Address_ID", "Street_Name", venue.Address_ID);
return(View());
}
ViewBag.Address_ID = new SelectList(db.addresses, "Address_ID", "Street_Name", venue.Address_ID);
return(View(venue));
}
private void btnSearchCNPJ_Click(object sender, EventArgs e)
{
if (!validatorCNPJ.Validate())
return;
try
{
//validações
var countcnpj = credentialed.repo.ExecuteScalar<string>("SELECT COUNT(id) FROM credentialeds WHERE cnpj=@0",
tfCNPJ.EditValue);
if (!countcnpj.Equals(DBNull.Value) && !String.IsNullOrEmpty(countcnpj))
{
if (Convert.ToInt32(countcnpj) >= 1)
{
DialogResult rs = XtraMessageBox.Show("CNPJ já consta cadastrado, deseja carregar os dados?",
"Cadore Tecnologia", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (rs == DialogResult.No)
return;
credentialed cre = credentialed.SingleOrDefault("WHERE cnpj=@0", tfCNPJ.EditValue);
bdgAddress.DataSource = address.SingleOrDefault(cre.address_id);
bdgCredentialed.DataSource = cre;
peLogo.Image = new FTPUtil().getImageFromFile(cre.directory_logo);
pCNPJ.Enabled = false;
pData.Enabled = true;
IsNew = false;
return;
}
}
SearchCPFCNPJUtil cc = new SearchCPFCNPJUtil();
if (cc.Search(Document.CNPJ, tfCNPJ.Text))
{
credentialed cre = new credentialed() { registered_at = null, inactived_at = null };
address d = new address();
cre.cnpj = cc.NCNPJ;
cre.company_name = cc.RAZAOSOCIAL;
cre.fantasy_name = cc.FANTASIA;
cre.opening_at = Convert.ToDateTime(cc.ABERTURA);
d.name = cc.ENDERECO;
d.number = cc.NUMERO;
d.complement = cc.COMPLEMENTO;
d.district = cc.BAIRRO;
d.cep = cc.CEP;
state st = state.SingleOrDefault("WHERE symbol=@0", cc.UF);
d.state_id = st != null ? st.id : 0;
List<city> lci = city.Fetch("WHERE name ILIKE @0 AND state_id=@1", city.Concat(cc.CIDADE), st.id);
d.city_id = lci[0] != null ? lci[0].id : 0;
string[] f = cc.TELEFONE.Replace(" ", "").Split('/');
if (f.Length >= 1)
cre.phone_fixed = f[0];
if (f.Length >= 2)
cre.phone_mobile = f[1];
bdgAddress.DataSource = d;
bdgCredentialed.DataSource = cre;
pCNPJ.Enabled = false;
pData.Enabled = true;
}
}
catch (Exception ex)
{
XtraMessageBox.Show(String.Format("Ocorreu um erro:\n\n{0}\n{1}", ex.Message, ex.InnerException));
}
}
public ActionResult Create([Bind(Include = "Venue_ID,Venue_Name,Venue_Description,Venue_Size")] venue venue, address address)
{
bool val = Validate(venue.Venue_Name);
if (val == false)
{
db.addresses.Add(address);
venue.Address_ID = address.Address_ID;
db.venues.Add(venue);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else if (val == true)
{
//ViewBag.StatusMessage = "There is already a venue called: " + venue.Venue_Name + " in the database.";
ViewBag.Address_ID = new SelectList(db.addresses, "Address_ID", "Street_Name", venue.Address_ID);
return(View());
}
//ViewBag.Address_ID = new SelectList(db.addresses, "Address_ID", "Street_Name", venue.Address_ID);
return(View(venue));
}
public void delete(address deleteItem)
{
address selectedItem= db.addresses.First(item => item.id == deleteItem.id);
db.addresses.Remove(selectedItem);
db.SaveChanges();
}
Write(numberFormatter, numberOptions, address, symbol, showSymbolAddress, true, false);
public address selectSingle(address findItem)
{
address selectedItem = db.addresses.SingleOrDefault(item => item.id == findItem.id);
return selectedItem;
}
protected void view_btn_Click(object sender, EventArgs e)
{
ChooseCPL.ClientState = "true";
ChooseCPL.Collapsed = true;
ChooseCPL.CollapsedText = "Search For a Different Warehouse";
warehouseViewInfoHead.Visible = true;
warehouseViewInfoBody.Visible = true;
warehouseInformation_L.Text = warehouseInformation_L_hf.Value;
//sdsProductType.SelectCommand += "and warehouse_id = " + Convert.ToString(passWarehouseID_hf.Value);
GlobalVariables.WarehouseID = Convert.ToInt32(passWarehouseID_hf.Value);
warehouse = warehouse.Select(Convert.ToInt32(passWarehouseID_hf.Value));
address = address.Select(warehouse.address_id);
//warehouse_product_Location = warehouse_product_Location.Select()
name_txt.Text = warehouse.warehouse_name.ToString();
address_txt.Text = address.str_add.ToString() + "" + address.city.ToString() + ", " + address.state.ToString() + "" + address.zip_plus_four.ToString();
type_txt.Text = warehouse.warehouse_type.ToString();
int returnValue = getWarehouseProductQty(GlobalVariables.WarehouseID);
amountOfResources_txt.Text = Convert.ToString(returnValue);
}
protected void createEmail()
{
call_center = call_center.Select(Convert.ToInt32(DDL_Call_Center.SelectedValue));
selected_Warehouse = selected_Warehouse.Select(Convert.ToInt32(passWarehouseID_hf.Value));
address = address.Select(selected_Warehouse.address_id);
//email
callcenter_Address = call_center.call_center_name + "<br />" + "(219) 564 5567";// +address.str_add + "<br />" + address.city + " " + address.state + " " + address.zip_plus_four + "<br />" + "(219) 564 5567";
NameOrderData = "<td colspan='1' width='10%' align='left' style='height: 87px'>" + "<b>Product Name: </b><br/><br/>";
TypeOrderData = "<td colspan='1' width='10%' align='left' style='height: 87px'>" + "<b>Type: </b><br/><br/>";
DescriptionOrderData = "<td colspan='1' width='10%' align='left' style='height: 87px'>" + "<b>Item Discription: </b><br/><br/>";
for (int i = 0; i < EName.Count; i++)
{
NameOrderData += EName[i] + "<br/>";
TypeOrderData += EType[i] + "<br/>";
DescriptionOrderData += EDescription[i] + "<br/>";
}
NameOrderData += "</td>";
TypeOrderData += "</td>";
DescriptionOrderData += "</td>";
var result = string.Join("|", EName.ToArray());
var message = new MailMessage("*****@*****.**", "*****@*****.**");
// here is an important part:
message.Subject = result + " -Has just been assigned a new location";
message.Body =
"<Table><tr><tb><b><font size='3'>The following product has been assigned a new location:</b></font></td></tr></table>" +
"<table id='Table1' width='100%' cellspacing='10' bgcolor='Silver'>" +
"<tr>" +
"<td colspan='12' align='left' style='border-style: none'>" +
"</td>" +
"</tr>" +
"<tr>" +
"<td colspan='12' style='background-color: Gray' height='5px'>" + "</td>" +
"</tr>" +
"<tr>" +
"<td rowspan='3' align='left' valign='top'>" +
"<font size='6' color='red'>DMCS</font>" +
"<br />" +
"Disaster Management Communication System" +
"<br />" +
"<br />" +
"<b>This order was placed at: </b><br />" +
callcenter_Address +
"</td>" +
"<td align='right' style='font-size: x-large; color: #808080; font-family: 'Times New Roman'; font-weight: bold;'>" + "<b>INVOICE</b>" +
"</td>" +
"</tr>" +
"<tr>" +
"<td>" +
"<br />" +
"<br />" +
"</td>" +
"</tr>" +
"<tr>" +
"<td align='right' style='color: #000000'>" +
"<b>Invoice/Case/Order</b> #3" +
"<br />" +
Convert.ToString(System.DateTime.Now) +
"</td>" +
"</tr>" +
"</table>" +
"<table id='Table2' width='100%' cellspacing='10' bgcolor='Silver'>" +
"<tr>" +
"<td width='50%' align='left'>" +
"<b>Shipping To:</b>" + "<br />" +
"United States Steel Corporation" + "<br />" +
"1 Broadway" + "<br />" +
"Gary,IN" + "<br />" +
"(219) 888-2000" + "<br />" +
"</td>" +
"<td width='50%' align='left'>" +
"<b>Shiping From:</b>" + "<br />" +
selected_Warehouse.warehouse_name + "<br />" +
address.str_add + "<br />" +
address.city + " " + address.state + " " + address.zip_plus_four + "<br />" +
"(219) 564 5567" + "<br />" +
"</td>" +
"</tr>" +
"</table>" +
"<table id='Table7' width='100%' cellspacing='10' bgcolor='Silver'>" +
"<tr>" +
"<td colspan='10' width='100%' align='left'>" +
"<br />" +
"<b>ORDER:</b>" +
"<br />" +
"</td>" +
"</tr>" +
"<tr>" +
"<tr>" +
"<td colspan='12' style='background-color: Gray' height='5px'>" + "</td>" +
"</tr>" +
"<tr>" +
NameOrderData +
TypeOrderData +
DescriptionOrderData +
"</tr>" +
"<tr>" +
"<td colspan='12' style='background-color: Gray' height='5px'>" + "</td>" +
"</tr>" +
"<tr>" +
"</table>" +
"<table><tr><tb></td></tr>" +
"<tr><tb><br/><br/><br/><br/>DO NOT RESPOND TO THIS MESSAGE." + "</td></tr>" +
"<tr><tb>THIS WAS A AUTOMATED MESSAGE SENT FROM THE DMSC SERVERS. </td></tr></table>";
//Set html to true! This allows for more then just a string with no breaks.
message.IsBodyHtml = true;
var client = new SmtpClient();
client.EnableSsl = true;
client.Send(message);
/////////////////////////////////////////////////////// EMAIL SENT
}
symbol = new SymbolResult(address, addrInfo.Name);
//INSERT
protected void insert_Click(object sender, EventArgs e)
{
try
{
address = address_insert();
person = person_insert();
client = client_insert();
missing = missing_insert();
if (Insert_deceasedYes.Checked == true)
{
deceased = deceased_insert();
}
case_intake = case_intake_insert();
case_client = case_client_insert();
encounter = encounter_insert();
}
catch { Insert_lbl_Client_Error.Text = "There has been an error updating information for the missing client."; }
finally { Insert_lbl_Client_Error.Text = "The missing client's information has been successfully updated."; }
}
: BalanceGetter(address, currency);
//UPDATE
protected void update_Click(object sender, EventArgs e)
{
try
{
//check to see if a insert is needed for deceased
person = person.Select(Convert.ToInt32(Update_gvClientSearchresult.SelectedValue));
client = client.Select(person.person_id);
if (Update_deceasedYes.Checked == true)
{
person = person_update(Convert.ToInt32(Update_gvClientSearchresult.SelectedValue));
missing = missing_update(person.person_id);
//check if update of insert of deceased
deceased = deceased.Select(client.client_id);
if (deceased.deceased_id == 0) { deceased = deceased_insert_For_Update(); }
else { deceased = deceased_update(person.person_id); }
}
else
{
person = person_update(Convert.ToInt32(Update_gvClientSearchresult.SelectedValue));
missing = missing_update(person.person_id);
}
address = address_update(person.address_id);
client = client_update(person.person_id);
encounter = encounter_insert();
Update_refreshclient();
}
catch { Update_lbl_Client_Error.Text = "There has been an error updating information for the missing client."; }
finally { Update_lbl_Client_Error.Text = "The missing client's information has been successfully updated."; }
}
public customerAddressDto()
{
isdefault = false;
shutout = false;
reciptaddress = new address();
}
public DataTable PrepararPedidos()
{
DataTable Prestashop = new DataTable("Ordenes");
DataColumn column;
DataRow row;
pedidosEcommerce = ListaPedidosPagados();
customer cliente = new customer();
address direccion_cli = new address();
address direccion_ent = new address();
order_payment pago = new order_payment();
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "ped_id";
column.Caption = "ped_id";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "ped_ref";
column.Caption = "ped_ref";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "ped_fecha";
column.Caption = "ped_fecha";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "ped_ubigeo_ent";
column.Caption = "ped_ubigeo_ent";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "ped_dir_ent";
column.Caption = "ped_dir_ent";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Decimal");
column.ColumnName = "ped_total_sigv";
column.Caption = "ped_total_sigv";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Decimal");
column.ColumnName = "ped_total_cigv";
column.Caption = "ped_total_cigv";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Decimal");
column.ColumnName = "ped_dcto_sigv";
column.Caption = "ped_dcto_sigv";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Decimal");
column.ColumnName = "ped_dcto_cigv";
column.Caption = "ped_dcto_cigv";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Decimal");
column.ColumnName = "ped_ship_sigv";
column.Caption = "ped_ship_sigv";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Decimal");
column.ColumnName = "ped_ship_cigv";
column.Caption = "ped_ship_cigv";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "cli_id";
column.Caption = "cli_id";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "cli_nombres";
column.Caption = "cli_nombres";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "cli_apellidos";
column.Caption = "cli_apellidos";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "cli_fec_nac";
column.Caption = "cli_fec_nac";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "cli_email";
column.Caption = "cli_email";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "cli_ubigeo";
column.Caption = "cli_ubigeo";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "cli_direc";
column.Caption = "cli_direc";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "cli_telf";
column.Caption = "cli_telf";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "cli_dni";
column.Caption = "cli_dni";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "det_artic";
column.Caption = "det_artic";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "det_artic_ref";
column.Caption = "det_artic_ref";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "det_desc_artic";
column.Caption = "det_desc_artic";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "det_cant";
column.Caption = "det_cant";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Double");
column.ColumnName = "det_prec_sigv";
column.ColumnName = "det_prec_sigv";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Double");
column.ColumnName = "det_dcto_sigv";
column.ColumnName = "det_dcto_sigv";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "pag_metodo";
column.ColumnName = "pag_metodo";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "pag_nro_trans";
column.ColumnName = "pag_nro_trans";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "pag_nro_tarj";
column.ColumnName = "pag_nro_tarj";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "pag_fecha";
column.ColumnName = "pag_fecha";
Prestashop.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Double");
column.ColumnName = "pag_monto";
column.ColumnName = "pag_monto";
Prestashop.Columns.Add(column);
foreach (order orden in pedidosEcommerce)
{
int idCliente = Convert.ToInt32((orden).id_customer);
cliente = GetCliente(idCliente);
int idDireccion = Convert.ToInt32((orden).id_address_delivery);
direccion_ent = GetDireccion(idDireccion);
int idDireccion2 = Convert.ToInt32((orden).id_address_invoice);
direccion_cli = GetDireccion(idDireccion);
string idPago = Convert.ToString((orden).reference);
pago = GetPayment(idPago);
foreach (order_row detalle in orden.associations.order_rows)
{
row = Prestashop.NewRow();
row["ped_id"] = orden.id;
row["ped_ref"] = orden.reference;
row["ped_fecha"] = orden.date_add;
row["ped_ubigeo_ent"] = direccion_ent.id_state;
row["ped_dir_ent"] = direccion_ent.address1;
row["ped_total_sigv"] = orden.total_paid_tax_excl;
row["ped_total_cigv"] = orden.total_paid_real;
row["ped_dcto_sigv"] = orden.total_discounts_tax_excl;
row["ped_dcto_cigv"] = orden.total_discounts;
row["ped_ship_sigv"] = orden.total_shipping_tax_excl;
row["ped_ship_cigv"] = orden.total_shipping;
row["cli_id"] = orden.id_customer;
row["cli_nombres"] = cliente.firstname;
row["cli_apellidos"] = cliente.lastname;
row["cli_fec_nac"] = cliente.birthday;
row["cli_email"] = cliente.email;
row["cli_ubigeo"] = direccion_cli.id_state;
row["cli_direc"] = direccion_cli.address1;
row["cli_telf"] = direccion_cli.phone;
row["cli_dni"] = direccion_cli.dni;
row["det_artic"] = detalle.product_id;
row["det_artic_ref"] = detalle.product_reference;
row["det_desc_artic"] = detalle.product_name;
row["det_cant"] = detalle.product_quantity;
row["det_prec_sigv"] = detalle.product_price;
row["det_dcto_sigv"] = detalle.unit_price_tax_excl;
row["pag_metodo"] = pago.payment_method;
row["pag_nro_trans"] = pago.transaction_id;
row["pag_nro_tarj"] = pago.card_number;
row["pag_fecha"] = pago.date_add;
row["pag_monto"] = pago.amount;
Prestashop.Rows.Add(row);
}
}
return(Prestashop);
}
/// <summary>
/// Расчитывает и сохраняет пользовательские ключи для заявления
/// </summary>
/// <param name="keyTypeList">
/// The key Type List.
/// </param>
/// <param name="pd">
/// The pd.
/// </param>
/// <param name="doc">
/// The doc.
/// </param>
/// <param name="addr1">
/// The addr 1.
/// </param>
/// <param name="addr2">
/// The addr 2.
/// </param>
/// <param name="medicalInsurances">
/// The medical Insurances.
/// </param>
/// <param name="okato">
/// The okato.
/// </param>
/// <returns>
/// The <see cref="IList{SearchKey}"/>.
/// </returns>
public IList <SearchKey> CalculateUserKeys(
IList <SearchKeyType> keyTypeList,
InsuredPersonDatum pd,
Document doc,
address addr1,
address addr2,
IList <MedicalInsurance> medicalInsurances,
string okato)
{
var result = new List <SearchKey>();
foreach (var kt in keyTypeList)
{
// Перекодирование типа ключа
var keyType = new database.business.model.SearchKeyType
{
RowId = kt.Id,
FirstName = kt.FirstName,
LastName = kt.LastName,
MiddleName = kt.MiddleName,
Birthday = kt.Birthday,
Birthplace = kt.Birthplace,
Snils = kt.Snils,
DocumentType = kt.DocumentType,
DocumentSeries = kt.DocumentSeries,
DocumentNumber = kt.DocumentNumber,
Okato = kt.Okato,
PolisType = kt.PolisType,
PolisSeria = kt.PolisSeria,
PolisNumber = kt.PolisNumber,
FirstNameLength = kt.FirstNameLength,
LastNameLength = kt.LastNameLength,
MiddleNameLength = kt.MiddleNameLength,
BirthdayLength = kt.BirthdayLength,
AddressStreet = kt.AddressStreet,
AddressStreetLength = kt.AddressStreetLength,
AddressHouse = kt.AddressHouse,
AddressRoom = kt.AddressRoom,
AddressStreet2 = kt.AddressStreet2,
AddressStreetLength2 = kt.AddressStreetLength2,
AddressHouse2 = kt.AddressHouse2,
AddressRoom2 = kt.AddressRoom2,
IdenticalLetters = kt.IdenticalLetters
};
// Перекодировка персональных данных
var personData = new database.business.model.InsuredPersonDatum
{
RowId = pd.Id,
LastName = pd.LastName,
FirstName = pd.FirstName,
MiddleName = pd.MiddleName,
Birthday = pd.Birthday,
Birthplace = pd.Birthplace,
Snils = pd.Snils,
};
// Перекодировка документа
database.business.model.Document document = null;
if (doc != null && doc.DocumentType != null)
{
document = new database.business.model.Document
{
RowId = doc.Id,
DocumentTypeId = doc.DocumentType.Id,
Series = doc.Series,
Number = doc.Number,
};
}
// Перекодировка адреса регистрации
var address1 = new database.business.model.address
{
RowId = addr1.Id,
Street = addr1.Street,
House = addr1.House,
Room = addr1.Room,
Okato = addr1.Okato,
};
// Перекодировка адреса проживания
database.business.model.address address2 = null;
if (addr2 != null)
{
address2 = new database.business.model.address
{
RowId = addr2.Id,
Street = addr2.Street,
House = addr2.House,
Room = addr2.Room,
Okato = addr2.Okato,
};
}
// Перекодировка страховок
foreach (var medicalInsurance in medicalInsurances)
{
var insurance = new database.business.model.MedicalInsurance
{
RowId = medicalInsurance.Id,
PolisTypeId = medicalInsurance.PolisType.Id,
PolisSeria = medicalInsurance.PolisSeria,
PolisNumber = medicalInsurance.PolisNumber,
};
// Расчет ключа
var keyValue = database.business.ObjectFactory.GetPseudonymizationManager()
.CalculateUserSearchKey(
keyType,
personData,
document,
address1,
address2,
insurance,
okato);
var conceptCacheManager = ObjectFactory.GetInstance <IConceptCacheManager>();
var searchKey = new SearchKey
{
KeyValue = keyValue,
KeyType = kt,
DocumentUdlType =
doc != null && doc.DocumentType != null
? conceptCacheManager.GetById(doc.DocumentType.Id)
: null
};
result.Add(searchKey);
}
}
return(result);
}
string ConvertObjectToXmlStr()
{
List <AmloToCustomer> customerResultList = null;
AmloToCustomer customerData = null;
customerData = new AmloToCustomer();
List <reportingdetail> reportingDetailList = new List <reportingdetail>();
List <report> reportList = new List <report>();
reportingdetail reportingdetailData = null;
List <person> personList = new List <person>();
person personData = null;
List <contact> contactList = new List <contact>();
contact contactData = null;
address addressData = null;
// #1
report report = null;
//<reportingdetail orgid="0107557000420" orgname="ธนาคารเอเอ็นแซด (ไทย) จำกัด (มหาชน)"/>
reportingdetailData = new reportingdetail()
{
orgid = "0107557000420", orgname = "ธนาคารเอเอ็นแซด (ไทย) จำกัด (มหาชน)"
};
reportingDetailList.Add(reportingdetailData);
customerData.reportingdetail = reportingDetailList;
//<report>
report = new report();
//<reportorgdetail branchcode="00000" orgname="ธนาคารเอเอ็นแซด (ไทย) จำกัด (มหาชน)" telno="022639700"/>
report.reportingdetail = new reportingdetail()
{
branchcode = "00000", orgname = "ธนาคารเอเอ็นแซด (ไทย) จำกัด (มหาชน)", telno = "022639700"
};
//<dcn value="09-00107557000420-00000-255912-000084" doctype="1-05-9" revision="" date="" refdocno="" refdoctype=""/>
report.dcn = new dcn()
{
value = "09-00107557000420-00000-255912-000084", doctype = "1-05-9", revision = "", date = "", refdocno = "", refdoctype = ""
};
//<reporttype value="2"/>
report.reportType = new reportType()
{
value = "2"
};
//--------------------------------------------------- ส่วนที่ 1 --------------------------------------------//
//<person anothermethod="TRUE" am_transactionmethod="DOCUMENT" am_customeraccno="100032" value="TRANSACTING-PERSON" relationship="SELF" relationshipdesc="">
personData = new person()
{
anothermethod = "TRUE",
am_transactionmethod = "DOCUMENT",
value = "TRANSACTING-PERSON",
relationship = "SELF",
relationshipdesc = ""
};
//<name type="LEGAL" title="" firstname="[NAV]" middlename="" lastname="" dateofbirth="" nationality="STATELESS" legalpersonid="[NAV]"/>
personData.personName = new personName()
{
type = "LEGAL",
title = "",
firstname = "[NAV]",
middlename = "",
lastname = "",
dateofbirth = "",
nationality = "STATELESS",
legalpersonid = "[NAV]"
};
//<occupation companyname="" businesstype="" businesstype_desc="" occ_type="99" occ_desc="[NAV]"/>
personData.occupation = new occupation()
{
companyname = "", businesstype = "", businesstype_desc = "", occ_type = "99", occ_desc = "[NAV]",
};
addressData = new address()
{
no = "[NAV]",
moo = "",
building = "",
soi = "",
road = "",
subdistrict = "[NAV]",
address1 = "",
address2 = "",
district = "[NAV]",
province = "[NAV]",
zipcode = "[NAV]",
countrycode = "TH"
};
contactData = new contact()
{
type = "ADDR", address = addressData
};
contactList.Add(contactData);
contactData = new contact()
{
type = "COMPANY-ADDR", noinfo = "TRUE"
};
contactList.Add(contactData);
contactData = new contact()
{
type = "CONTACT-ADDR", noinfo = "TRUE"
};
contactList.Add(contactData);
personData.contact = contactList;
personList.Add(personData);
//--------------------------------------------------- ส่วนที่ 2 --------------------------------------------//
//<person value="RELATED-PERSON" relationship="DELEGATOR" relationshipdesc="">
personData = new person()
{
value = "RELATED-PERSON",
relationship = "DELEGATOR",
relationshipdesc = ""
};
//<name type="LEGAL" title="" firstname="MINOR INTERNATIONAL PUBLIC CO LTD" middlename="" lastname="" dateofbirth="" nationality="TH" legalpersonid="0107536000919"/>
//< occupation companyname = "" businesstype = "" businesstype_desc = "" occ_type = "0" occ_desc = "" />
personData.personName = new personName()
{
type = "LEGAL",
title = "",
firstname = "MINOR INTERNATIONAL PUBLIC CO LTD",
middlename = "",
lastname = "",
dateofbirth = "",
nationality = "TH",
legalpersonid = "0107536000919"
};
//<occupation companyname="" businesstype="" businesstype_desc="" occ_type="0" occ_desc=""/>
personData.occupation = new occupation()
{
companyname = "", businesstype = "", businesstype_desc = "", occ_type = "0", occ_desc = "",
};
/*<contact type="ADDR">
* <address no="99" moo="" building="BERLI JUCKER BUILDING 16TH FLOOR" soi="SOI RUBIA" road="SUKHUMVIT 42" subdistrict="PRAKANONG" address1="" address2="" district="KLONGTOEY" province="BANGKOK" zipcode="10110" countrycode="TH"/>
* </contact>*/
addressData = new address()
{
no = "99",
moo = "",
building = "BERLI JUCKER BUILDING 16TH FLOOR",
soi = "SOI RUBIA",
road = "SUKHUMVIT 42",
subdistrict = "PRAKANONG",
address1 = "",
address2 = "",
district = "KLONGTOEY",
province = "BANGKOK",
zipcode = "10110",
countrycode = "TH"
};
contactData = new contact()
{
type = "ADDR", address = addressData
};
contactList.Add(contactData);
contactData = new contact()
{
type = "COMPANY-ADDR", noinfo = "TRUE"
};
contactList.Add(contactData);
contactData = new contact()
{
type = "CONTACT-ADDR", noinfo = "TRUE"
};
contactList.Add(contactData);
personData.contact = contactList;
personData.iddoc = new iddoc()
{
type = "99", typedesc = "[NAV]", idno = "[NAV]", issueby = "[NAV]", issuedate = "[NAV]", expiredate = "[NAV]"
};
personList.Add(personData);
//--------------------------------------------------- ส่วนที่ 3 --------------------------------------------//
report.person = personList;
reportList.Add(report);
customerData.report = reportList;
/*<ersreport version="1.0">
* <reportingdetail orgid="0107557000420" orgname="ธนาคารเอเอ็นแซด (ไทย) จำกัด (มหาชน)"/>
* <report>
* <reportorgdetail branchcode="00000" orgname="ธนาคารเอเอ็นแซด (ไทย) จำกัด (มหาชน)" telno="022639700"/>
* <dcn value="09-00107557000420-00000-255912-000084" doctype="1-05-9" revision="" date="" refdocno="" refdoctype=""/>
* <reporttype value="2"/>
* <!-- ข้อมูลผู้ทำธุรกรรม -->
* <!-- ส่วนที่ 1 -->
*
* <person anothermethod="TRUE" am_transactionmethod="DOCUMENT" am_customeraccno="100032" value="TRANSACTING-PERSON" relationship="SELF" relationshipdesc="">
* <name type="LEGAL" title="" firstname="[NAV]" middlename="" lastname="" dateofbirth="" nationality="STATELESS" legalpersonid="[NAV]"/>
* <occupation companyname="" businesstype="" businesstype_desc="" occ_type="99" occ_desc="[NAV]"/>
*
* <contact type="ADDR">
* <address no="[NAV]" moo="" building="" soi="" road="" subdistrict="[NAV]" address1="" address2="" district="[NAV]" province="[NAV]" zipcode="[NAV]" countrycode="TH"/>
* </contact>
* <contact type="COMPANY-ADDR" noinfo="TRUE"/>
* <contact type="CONTACT-ADDR" noinfo="TRUE"/>
* <iddoc type="99" typedesc="[NAV]" idno="[NAV]" issueby="[NAV]" issuedate="[NAV]" expiredate="[NAV]"/>
* </person>
* <!--
* ส่วนที่ 2 ข้อมูลผู้ร่วมทำธุรกรรม,ผู้มอบหมาย,ผู้มอบอำนาจ
* -->
*
* <person value="RELATED-PERSON" relationship="DELEGATOR" relationshipdesc="">
* <name type="LEGAL" title="" firstname="MINOR INTERNATIONAL PUBLIC CO LTD" middlename="" lastname="" dateofbirth="" nationality="TH" legalpersonid="0107536000919"/>
* <occupation companyname="" businesstype="" businesstype_desc="" occ_type="0" occ_desc=""/>
*
* <contact type="ADDR">
* <address no="99" moo="" building="BERLI JUCKER BUILDING 16TH FLOOR" soi="SOI RUBIA" road="SUKHUMVIT 42" subdistrict="PRAKANONG" address1="" address2="" district="KLONGTOEY" province="BANGKOK" zipcode="10110" countrycode="TH"/>
* </contact>
*
* <contact type="COMPANY-ADDR">
* <address no="99" moo="" building="BERLI JUCKER BUILDING 16TH FLOOR" soi="SOI RUBIA" road="SUKHUMVIT 42" subdistrict="PRAKANONG" address1="" address2="" district="KLONGTOEY" province="BANGKOK" zipcode="10110" countrycode="TH"/>
* </contact>
*
* <contact type="CONTACT-ADDR">
* <address no="99" moo="" building="BERLI JUCKER BUILDING 16TH FLOOR" soi="SOI RUBIA" road="SUKHUMVIT 42" subdistrict="PRAKANONG" address1="" address2="" district="KLONGTOEY" province="BANGKOK" zipcode="10110" countrycode="TH"/>
* </contact>
* <iddoc type="99" typedesc="AFFIDAVIT" idno="0107536000919" issueby="MINISTRY OF COMMERCE" issuedate="2559-10-13" expiredate="[NOEXP]"/>
* </person>
* <!-- ส่วนที่ 3 ข้อเท็จจริงเกี่ยวกับการทำธุรกรรม -->
*
* <tsc date="2559-12-22">
* <tscentry>
* <typeoftsc transtype="DOMESTIC" type="SEND" desc=""/>
* <transferdetail type="SEND" accountno="100032" refno="FTB1612220002" org="ANZ BANK (THAI) PUBLIC CO LTD" orgcountry="TH">
* <td fullname="MINOR INTERNATIONAL PUBLIC CO LTD" address="99 BERLI JUCKER BUILDING 16TH FLOOR SOI RUBIA" contactaddress="SUKHUMVIT 42 PRAKANONG KLONGTOEY BANGKOK 10110" idtype="OTHER" idtypedesc="AFFIDAVIT" idno="0107536000919" idissuer="MINISTRY OF COMMERCE" idexpiredate="" dateofbirth="" placeofbirth=""/>
* </transferdetail>
* <transferdetail type="REC" accountno="0126321007" refno="FTB1612220002" org="CITIBANK N.A." orgcountry="TH">
* <td fullname="MINOR INTERNATIONAL PUBLIC CO LTD" address="BANGKOK" contactaddress="" idtype="OTHER" idtypedesc="AFFIDAVIT" idno="0107536000919" idissuer="MINISTRY OF COMMERCE" idexpiredate="" dateofbirth="" placeofbirth=""/>
* </transferdetail>
* <amount valueinbaht="199999850.00" valueinbahttxt="หนึ่งร้อยเก้าสิบเก้าล้านเก้าแสนเก้าหมื่นเก้าพันแปดร้อยห้าสิบบาทถ้วน"/>
* </tscentry>
* <totalamount valueinbaht="199999850.00" valueinbahttxt="หนึ่งร้อยเก้าสิบเก้าล้านเก้าแสนเก้าหมื่นเก้าพันแปดร้อยห้าสิบบาทถ้วน"/>
* <!-- Data From Head -->
* <benfperson firstname="[NAV]" middlename="" lastname=""/>
* <objective type=""> NEW LOAN DRAWDOWN ON 22 DECEMBER 2016. </objective>
* <!-- ส่วนที่ 4 -->
* </tsc>
* <record date="2559-12-22"/>
* </report>*/
// customerResultList.Add(customerData);
string data = string.Format("{0}", DTO.Util.XmlSerializerHelper.SerializeObjectToString(customerData));
return(data);
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (!validator.Validate())
return;
//try
// {
//validações
if (!Validations.isCPFCNPJ(tfCNPJ.EditValue.ToString(), false))
{
XtraMessageBox.Show("CNPJ incorreto, verifique!");
return;
}
var countcnpj = customer.repo.ExecuteScalar<string>("SELECT COUNT(id) FROM customers WHERE document=@0",
tfCNPJ.EditValue);
if (!countcnpj.Equals(DBNull.Value) && !String.IsNullOrEmpty(countcnpj))
{
if (Convert.ToInt32(countcnpj) >= 1)
{
XtraMessageBox.Show("CNPJ já cadastrado, verifique!", "Cadore Tecnologia");
return;
}
}
SearchCPFCNPJUtil cc = new SearchCPFCNPJUtil();
if (cc.Search(Document.CNPJ, tfCNPJ.Text))
{
customer cre = new customer();
address d = new address();
cre.document = cc.NCNPJ;
if (cre.document.Length == 18)
cre.type = 0;
else
cre.type = 1;
cre.inactive = false;
cre.corporate_name = cc.RAZAOSOCIAL;
cre.fantasy_name = cc.FANTASIA;
d.name = cc.ENDERECO;
d.number = cc.NUMERO;
d.complement = cc.COMPLEMENTO;
d.district = cc.BAIRRO;
d.cep = cc.CEP;
// para evitar problemas com estados e cidades try para ignorar esta etapa caso haja erros!
try
{
state st = state.SingleOrDefault("WHERE symbol=@0", cc.UF);
d.state_id = st != null ? st.id : 0;
List<city> lci = city.Fetch("WHERE remove_character(name) ILIKE @0 AND state_id=@1",
city.Concat(cc.CIDADE), st.id);
d.city_id = lci != null ? lci[0].id : 0;
} catch (Exception) { }
if (!String.IsNullOrEmpty(cc.TELEFONE))
{
string[] f = cc.TELEFONE.Replace(" ", "").Split('/');
if (f.Length >= 1)
cre.phone_fixed = f[0];
if (f.Length >= 2)
cre.phone_mobile = f[1];
}
bdgAddress.DataSource = d;
bdgCustomer.DataSource = cre;
tfCNPJ.Properties.ReadOnly = true;
tfType.EditValue = cc.TIPO;
tfSituation.EditValue = cc.SITUACAOCNPJ;
tfDateOpening.EditValue = cc.ABERTURA;
tfCnae1.EditValue = cc.CNAE1;
tfCnae2.EditValue = cc.CNAE2;
tfJuridic.EditValue = cc.NATUREZA;
}
//}
//catch (Exception ex)
//{
// XtraMessageBox.Show(String.Format("Ocorreu um erro:\n\n{0}\n{1}", ex.Message, ex.InnerException));
//}
}
