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