public void deleteData(ry_Client obj)
{
using (SqlConnection sqlConn = new SqlConnection(connString))
{
using (SqlCommand cmd = new SqlCommand("usp_DeleteClient", sqlConn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlConn.Open();
cmd.Parameters.AddWithValue("@Cnic", obj.Cnic);
cmd.ExecuteNonQuery();
}
}
}
protected void ListView_Property_ItemDeleting(object sender, ListViewDeleteEventArgs e)
{
Label PropertyId = ((Label)ListView_Property.Items[e.ItemIndex].FindControl("lbl_PropertyId"));
Label cnic = ((Label)ListView_Property.Items[e.ItemIndex].FindControl("lbl_Cnic"));
ry_Property objProperty = new ry_Property();
objProperty.Cnic = cnic.Text;
objProperty.propertyID = Convert.ToInt32(PropertyId.Text);
objProperty.delete(objProperty);
ry_Client objClient = new ry_Client();
objClient.Cnic = cnic.Text;
objClient.delete(objClient);
ListView_Property.EditIndex = -1;
Response.Redirect("AdminPanel.aspx");
}
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");
}
public void updateData(ry_Client obj)
{
using (SqlConnection sqlConn = new SqlConnection(connString))
{
using (SqlCommand cmd = new SqlCommand("usp_UpdateClient", sqlConn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlConn.Open();
cmd.Parameters.AddWithValue("@Cnic", obj.Cnic);
cmd.Parameters.AddWithValue("@firstName", obj.firstName);
cmd.Parameters.AddWithValue("@lastName", obj.lastName);
cmd.Parameters.AddWithValue("@email", obj.email);
cmd.Parameters.AddWithValue("@contactNumber", obj.contactNumber);
cmd.Parameters.AddWithValue("@postalAddress", obj.postalAddress);
cmd.Parameters.AddWithValue("@permenantAddress", obj.permenantAddress);
cmd.ExecuteNonQuery();
}
}
}
protected void ListView_Property_ItemUpdating(object sender, ListViewUpdateEventArgs e)
{
Label cnic = ((Label)ListView_Property.Items[e.ItemIndex].FindControl("lbl_Cnic"));
TextBox firstName = ((TextBox)ListView_Property.Items[e.ItemIndex].FindControl("tb_firstName"));
TextBox lastName = ((TextBox)ListView_Property.Items[e.ItemIndex].FindControl("tb_lastName"));
TextBox email = ((TextBox)ListView_Property.Items[e.ItemIndex].FindControl("tb_email"));
TextBox contactNumber = ((TextBox)ListView_Property.Items[e.ItemIndex].FindControl("tb_contactNumber"));
TextBox postalAddress = ((TextBox)ListView_Property.Items[e.ItemIndex].FindControl("tb_postalAddress"));
TextBox permenantAddress = ((TextBox)ListView_Property.Items[e.ItemIndex].FindControl("tb_permenantAddress"));
Label PropertyId = ((Label)ListView_Property.Items[e.ItemIndex].FindControl("lbl_PropertyId"));
TextBox location = ((TextBox)ListView_Property.Items[e.ItemIndex].FindControl("tb_location"));
RadioButtonList propertyType = ((RadioButtonList)ListView_Property.Items[e.ItemIndex].FindControl("propertyType"));
TextBox areaSize = ((TextBox)ListView_Property.Items[e.ItemIndex].FindControl("tb_areaSize"));
TextBox demand = ((TextBox)ListView_Property.Items[e.ItemIndex].FindControl("tb_demand"));
RadioButtonList rentOrSale = ((RadioButtonList)ListView_Property.Items[e.ItemIndex].FindControl("rentOrSale"));
TextBox Status = ((TextBox)ListView_Property.Items[e.ItemIndex].FindControl("tb_status"));
TextBox propertyDescription = ((TextBox)ListView_Property.Items[e.ItemIndex].FindControl("tb_propertyDescription"));
TextBox agentName = ((TextBox)ListView_Property.Items[e.ItemIndex].FindControl("tb_agentName"));
TextBox agentContactNumber = ((TextBox)ListView_Property.Items[e.ItemIndex].FindControl("tb_agentContactNumber"));
FileUpload Image_Property = ((FileUpload)ListView_Property.Items[e.ItemIndex].FindControl("CountrySidepropertyImage"));
Image Image_CSP_ASP = ((Image)ListView_Property.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_Property objProperty = new ry_Property();
objProperty.Cnic = cnic.Text;
objProperty.propertyID = Convert.ToInt32(PropertyId.Text);
objProperty.location = location.Text;
objProperty.propertyType = propertyType.SelectedValue;
objProperty.areaSize = areaSize.Text;
objProperty.demand = demand.Text;
objProperty.rentOrSale = rentOrSale.SelectedValue;
objProperty.Status = Status.Text;
objProperty.propertyDescription = propertyDescription.Text;
objProperty.agentName = agentName.Text;
objProperty.agentContactNumber = agentContactNumber.Text;
if (Image_Property.HasFile)
{
objProperty.Image = ImageBytes(Image_Property);
}
else
{
objProperty.Image = new byte[0];
}
objProperty.update(objProperty);
ListView_Property.EditIndex = -1;
Response.Redirect("AdminPanel.aspx");
}
