public void deleteData(ry_CountrySideProject obj)
{
using (SqlConnection sqlConn = new SqlConnection(connString))
{
using (SqlCommand cmd = new SqlCommand("usp_DeleteCSP", sqlConn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlConn.Open();
cmd.Parameters.AddWithValue("@csPropertyId", obj.csPropertyId);
cmd.Parameters.AddWithValue("@Cnic", obj.Cnic);
cmd.ExecuteNonQuery();
}
}
}
protected void ListView_CSP_ItemDeleting(object sender, ListViewDeleteEventArgs e)
{
Label csPropertyId = ((Label)ListView_CSP.Items[e.ItemIndex].FindControl("lbl_csPropertyId"));
Label cnic = ((Label)ListView_CSP.Items[e.ItemIndex].FindControl("lbl_Cnic"));
ry_CountrySideProject objCSP = new ry_CountrySideProject();
objCSP.Cnic = cnic.Text;
objCSP.csPropertyId = Convert.ToInt32(csPropertyId.Text);
objCSP.delete(objCSP);
ry_Client objClient = new ry_Client();
objClient.Cnic = cnic.Text;
objClient.delete(objClient);
ListView_CSP.EditIndex = -1;
Response.Redirect("AdminPanel.aspx");
}
protected void btn_CountrySidePropertiesInformation_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
ry_CountrySideProject CountrySideProperty = new ry_CountrySideProject();
CountrySideProperty.propertyType = propertyType.SelectedItem.Value;
CountrySideProperty.areaSize = areaSize.Text;
CountrySideProperty.location = location.Text;
CountrySideProperty.demand = demand.Text;
CountrySideProperty.Status = status.Text;
CountrySideProperty.rentOrSale = rentOrSale.SelectedItem.Value;
CountrySideProperty.propertyDescription = propertyDescription.Text;
CountrySideProperty.agentName = agentName.Text;
CountrySideProperty.agentContactNumber = agentContactNumber.Text;
CountrySideProperty.Image = ImageBytes(CountrySidepropertyImage);
CountrySidePropertyBL.Add(CountrySideProperty);
Response.Redirect("ClientInformation.aspx");
}
}
public void updateData(ry_CountrySideProject obj)
{
using (SqlConnection sqlConn = new SqlConnection(connString))
{
using (SqlCommand cmd = new SqlCommand("usp_UpdateCSP", sqlConn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlConn.Open();
cmd.Parameters.AddWithValue("@Cnic", obj.Cnic);
cmd.Parameters.AddWithValue("@location", obj.location);
cmd.Parameters.AddWithValue("@propertyType", obj.propertyType);
cmd.Parameters.AddWithValue("@areaSize", obj.areaSize);
cmd.Parameters.AddWithValue("@demand", obj.demand);
cmd.Parameters.AddWithValue("@Status", obj.Status);
cmd.Parameters.AddWithValue("@rentOrSale", obj.rentOrSale);
cmd.Parameters.AddWithValue("@propertyDescription", obj.propertyDescription);
cmd.Parameters.AddWithValue("@agentName", obj.agentName);
cmd.Parameters.AddWithValue("@agentContactNumber", obj.agentContactNumber);
cmd.Parameters.AddWithValue("@Image", obj.Image);
cmd.ExecuteNonQuery();
}
}
}
protected void ListView_CSP_ItemUpdating(object sender, ListViewUpdateEventArgs e)
{
Label cnic = ((Label)ListView_CSP.Items[e.ItemIndex].FindControl("lbl_Cnic"));
TextBox firstName = ((TextBox)ListView_CSP.Items[e.ItemIndex].FindControl("tb_firstName"));
TextBox lastName = ((TextBox)ListView_CSP.Items[e.ItemIndex].FindControl("tb_lastName"));
TextBox email = ((TextBox)ListView_CSP.Items[e.ItemIndex].FindControl("tb_email"));
TextBox contactNumber = ((TextBox)ListView_CSP.Items[e.ItemIndex].FindControl("tb_contactNumber"));
TextBox postalAddress = ((TextBox)ListView_CSP.Items[e.ItemIndex].FindControl("tb_postalAddress"));
TextBox permenantAddress = ((TextBox)ListView_CSP.Items[e.ItemIndex].FindControl("tb_permenantAddress"));
Label csPropertyId = ((Label)ListView_CSP.Items[e.ItemIndex].FindControl("lbl_csPropertyId"));
TextBox location = ((TextBox)ListView_CSP.Items[e.ItemIndex].FindControl("tb_location"));
RadioButtonList propertyType = ((RadioButtonList)ListView_CSP.Items[e.ItemIndex].FindControl("propertyType"));
TextBox areaSize = ((TextBox)ListView_CSP.Items[e.ItemIndex].FindControl("tb_areaSize"));
TextBox demand = ((TextBox)ListView_CSP.Items[e.ItemIndex].FindControl("tb_demand"));
RadioButtonList rentOrSale = ((RadioButtonList)ListView_CSP.Items[e.ItemIndex].FindControl("rentOrSale"));
TextBox Status = ((TextBox)ListView_CSP.Items[e.ItemIndex].FindControl("tb_status"));
TextBox propertyDescription = ((TextBox)ListView_CSP.Items[e.ItemIndex].FindControl("tb_propertyDescription"));
TextBox agentName = ((TextBox)ListView_CSP.Items[e.ItemIndex].FindControl("tb_agentName"));
TextBox agentContactNumber = ((TextBox)ListView_CSP.Items[e.ItemIndex].FindControl("tb_agentContactNumber"));
FileUpload Image_CSP = ((FileUpload)ListView_CSP.Items[e.ItemIndex].FindControl("CountrySidepropertyImage"));
Image Image_CSP_ASP = ((Image)ListView_CSP.Items[e.ItemIndex].FindControl("img"));
ry_Client objClient = new ry_Client();
objClient.Cnic = cnic.Text;
objClient.firstName = firstName.Text;
objClient.lastName = lastName.Text;
objClient.email = email.Text;
objClient.contactNumber = contactNumber.Text;
objClient.postalAddress = postalAddress.Text;
objClient.permenantAddress = permenantAddress.Text;
objClient.update(objClient);
ry_CountrySideProject objCSP = new ry_CountrySideProject();
objCSP.Cnic = cnic.Text;
objCSP.csPropertyId = Convert.ToInt32(csPropertyId.Text);
objCSP.location = location.Text;
objCSP.propertyType = propertyType.SelectedValue;
objCSP.areaSize = areaSize.Text;
objCSP.demand = demand.Text;
objCSP.rentOrSale = rentOrSale.SelectedValue;
objCSP.Status = Status.Text;
objCSP.propertyDescription = propertyDescription.Text;
objCSP.agentName = agentName.Text;
objCSP.agentContactNumber = agentContactNumber.Text;
if (Image_CSP.HasFile)
{
objCSP.Image = ImageBytes(Image_CSP);
}
else
{
objCSP.Image = new byte[0];
}
objCSP.update(objCSP);
ListView_CSP.EditIndex = -1;
Response.Redirect("AdminPanel.aspx");
}
