public DeliveryAddressViewModel() { selectDelivery = new DeliveryAddressModel(); selectDelivery.CUSTOMER_NAME = App.Current.Properties["Customer_Name"].ToString(); selectDelivery.CUSTOMER_CODE = App.Current.Properties["Customer_Code"].ToString(); // var comp = Convert.ToInt32(App.Current.Properties["Company_Id"].ToString()); //if (App.Current.Properties["Action"] == "Edit") //{ // selectDelivery = App.Current.Properties["CatagoryEdit"] as DeliveryAddressModel; // App.Current.Properties["Action"] = ""; //} //else { CreatVisible = "Visible"; UpdVisible = "Collapsed"; AddVisible = "Visible"; //var comp = 1; GetDeliveryAddress(comp); } }
public HttpResponseMessage CreateDelivery(DeliveryAddressModel _DeliveryAddressModel) { try { CUSTOMER_DELIVERY_ADDRESS cus = new CUSTOMER_DELIVERY_ADDRESS(); cus.DELIVERY_CODE = _DeliveryAddressModel.DELIVERY_CODE; cus.CUSTOMER_CODE = _DeliveryAddressModel.CUSTOMER_CODE; cus.DELIVERY_COMPANY_NAME = _DeliveryAddressModel.DELIVERY_COMPANY_NAME; cus.ADDRESS = _DeliveryAddressModel.ADDRESS; cus.COUNTRY = _DeliveryAddressModel.COUNTRY; //cus.COUNTRY = _DeliveryAddressModel.COUNTRY; cus.CONTACTS = _DeliveryAddressModel.CONTACTS; cus.POSTCODE = _DeliveryAddressModel.POSTCODE; //cus.TELEPHONE = _DeliveryAddressModel.TELEPHONE; //cus.FAX = _DeliveryAddressModel.FAX; cus.TELEPHONE = _DeliveryAddressModel.TELEPHONE; cus.FAX = _DeliveryAddressModel.FAX; cus.CUSTOMER_CODE = _DeliveryAddressModel.CUSTOMER_CODE; cus.IS_DELETE = false; cus.STATUS = "UnSaved"; cus.COMPANY_ID = 1; db.CUSTOMER_DELIVERY_ADDRESS.Add(cus); db.SaveChanges(); } catch (Exception) { throw; } return(Request.CreateResponse(HttpStatusCode.OK, "success")); }
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { DeliveryAddressModel address = new DeliveryAddressModel(); GridViewRow row = dgvdeliveryaddress.Rows[e.RowIndex]; address.ID = Convert.ToInt32(dgvdeliveryaddress.DataKeys[e.RowIndex].Values[0]); //dish.ID = Convert.ToInt32(dgvDishDetail.DataKeys[e.RowIndex].Values[0]); address.Address = (row.Cells[2].Controls[0] as TextBox).Text; address.Latitude = Convert.ToDecimal((row.Cells[3].Controls[0] as TextBox).Text); address.Longitude = Convert.ToDecimal((row.Cells[4].Controls[0] as TextBox).Text); address.ZipCode = int.Parse((row.Cells[5].Controls[0] as TextBox).Text); using (OracleConnection con = new OracleConnection(connectionString)) { using (OracleCommand cmd = new OracleCommand("update deliveryaddress set address_Name = '" + address.Address + "',Latitude = '" + address.Latitude + "',Longitude='" + address.Longitude + "',Zip_Code='" + address.ZipCode + "' where address_ID = " + address.ID)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } dgvdeliveryaddress.EditIndex = -1; this.bindGrid(); }
private void bindGrid() { List <DeliveryAddressModel> addressslst = new List <DeliveryAddressModel>(); OracleConnection conn = new OracleConnection(connectionString); string query = "Select * from deliveryaddress"; OracleCommand cmd = new OracleCommand(query, conn); conn.Open(); OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { DeliveryAddressModel address = new DeliveryAddressModel(); address.ID = int.Parse(reader["address_ID"].ToString()); address.Address = reader["address_Name"].ToString(); address.Latitude = Convert.ToDecimal(reader["Latitude"].ToString()); address.Longitude = Convert.ToDecimal(reader["Longitude"].ToString()); address.ZipCode = int.Parse(reader["Zip_Code"].ToString()); addressslst.Add(address); } conn.Close(); dgvdeliveryaddress.DataSource = null; dgvdeliveryaddress.DataSource = addressslst; dgvdeliveryaddress.DataBind(); }
protected void btnAdd_Click(object sender, EventArgs e) { DeliveryAddressModel addressModel = new DeliveryAddressModel(); addressModel.Address = txtaddressname.Text.ToString(); addressModel.Latitude = Convert.ToDecimal(txtlatitude.Text.ToString()); addressModel.Longitude = Convert.ToDecimal(txtlongitude.Text.ToString()); addressModel.ZipCode = int.Parse(txtzipcode.Text.ToString()); using (OracleConnection con = new OracleConnection(connectionString)) { using (OracleCommand cmd = new OracleCommand("Insert into deliveryaddress(Address_Name, Latitude, Longitude, Zip_Code)Values('" + addressModel.Address + "','" + addressModel.Latitude + "','" + addressModel.Longitude + "'," + addressModel.ZipCode + ")")) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); txtaddressname.Text = ""; txtlatitude.Text = ""; txtlongitude.Text = ""; txtzipcode.Text = ""; } this.bindGrid(); } }
public HttpResponseMessage AddressUpdate(DeliveryAddressModel _DeliveryAddressModel) { var str = (from a in db.CUSTOMER_DELIVERY_ADDRESS where a.DELIVERY_ID == _DeliveryAddressModel.DELIVERY_ID select a).FirstOrDefault(); str.DELIVERY_CODE = _DeliveryAddressModel.DELIVERY_CODE; str.DELIVERY_COMPANY_NAME = _DeliveryAddressModel.DELIVERY_COMPANY_NAME; str.ADDRESS = _DeliveryAddressModel.ADDRESS; str.COUNTRY = _DeliveryAddressModel.COUNTRY; str.CONTACTS = _DeliveryAddressModel.CONTACTS; str.TELEPHONE = _DeliveryAddressModel.TELEPHONE; str.POSTCODE = _DeliveryAddressModel.POSTCODE; str.FAX = _DeliveryAddressModel.FAX; str.DELIVERY_MODE = _DeliveryAddressModel.DELIVERY_MODE; str.DELIVERY_TIME = _DeliveryAddressModel.DELIVERY_TIME; str.EC_COUNTRY = _DeliveryAddressModel.EC_COUNTRY; str.SAME_STATEMENT = _DeliveryAddressModel.SAME_STATEMENT; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "success")); }