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"));
}
