public OwnerTenantRegistrationModel GetDesigination() { OwnerTenantRegistrationModel desigination = new OwnerTenantRegistrationModel(); using (SqlConnection cn = new SqlConnection(cns)) { using (SqlCommand cmd = new SqlCommand("getdesigination", cn)) { cmd.CommandType = CommandType.StoredProcedure; try { cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { desigination.lstdesigination.Add(dr["role"].ToString()); } dr.Close(); } } catch (SqlException ex) { throw ex; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } } } return(desigination); }
public OwnerTenantRegistrationModel GetDropdownList() { string cns = ConfigurationManager.ConnectionStrings["scn"].ConnectionString; OwnerTenantRegistrationModel getlist = new OwnerTenantRegistrationModel(); using (SqlConnection cn = new SqlConnection(cns)) { using (SqlCommand cmd = new SqlCommand("getblock", cn)) { cmd.CommandType = CommandType.StoredProcedure; try { cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { getlist.lstblock.Add(dr["block"].ToString()); } } } catch (SqlException ex) { throw ex; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } } } return(getlist); }
public void UpdateOwnerTenant(OwnerTenantRegistrationModel updatemodel) { string cns = ConfigurationManager.ConnectionStrings["scn"].ConnectionString; using (SqlConnection cn = new SqlConnection()) { using (SqlCommand cmd = new SqlCommand()) { } } }
public List <OwnerTenantRegistrationModel> GetAllOwnerTenant() { List <OwnerTenantRegistrationModel> getalllist = new List <OwnerTenantRegistrationModel>(); using (SqlConnection cn = new SqlConnection(cns)) { using (SqlCommand cmd = new SqlCommand("getallownertenant", cn)) { cmd.CommandType = CommandType.StoredProcedure; try { cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { OwnerTenantRegistrationModel model = new OwnerTenantRegistrationModel(); model.Id = Convert.ToInt32(dr["member_id"]); model.Fname = dr["fname"].ToString(); model.Lname = dr["lname"].ToString(); model.Age = (int)dr["age"]; model.Cell = dr["cell_no"].ToString(); model.Email = dr["email"].ToString(); model.Occupation = dr["occupation"].ToString(); model.Company = dr["company"].ToString(); model.Office_address = dr["office_address"].ToString(); DateTime date = Convert.ToDateTime(dr["on_date"]); model.On_date = date.ToShortDateString(); model.Block = dr["block"].ToString(); model.Flat_no = (int)dr["flat_no"]; model.Member_type = dr["member_type"].ToString(); getalllist.Add(model); } } } catch (SqlException ex) { throw ex; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } } } return(getalllist); }
public bool CreateOwnerTenant(OwnerTenantRegistrationModel createmodel) { string cns = ConfigurationManager.ConnectionStrings["scn"].ConnectionString; bool is_success = false; using (SqlConnection cn = new SqlConnection(cns)) { using (SqlCommand cmd = new SqlCommand("insertownertenant", cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@fname", createmodel.Fname); cmd.Parameters.AddWithValue("@lname", createmodel.Lname); cmd.Parameters.AddWithValue("@age", createmodel.Age); cmd.Parameters.AddWithValue("@gender", createmodel.Gender); cmd.Parameters.AddWithValue("@cell_no", createmodel.Cell); cmd.Parameters.AddWithValue("@email", createmodel.Email); cmd.Parameters.AddWithValue("@password", createmodel.Password); cmd.Parameters.AddWithValue("@maritalstatus", createmodel.Marital_status); cmd.Parameters.AddWithValue("@occupation", createmodel.Occupation); cmd.Parameters.AddWithValue("@company", createmodel.Company); cmd.Parameters.AddWithValue("@office_address", createmodel.Office_address); cmd.Parameters.AddWithValue("@On_date", createmodel.On_date); cmd.Parameters.AddWithValue("@block", createmodel.Block); cmd.Parameters.AddWithValue("@flat_no", createmodel.Flat_no); cmd.Parameters.AddWithValue("@membertype", createmodel.Member_type); try { cn.Open(); int count = cmd.ExecuteNonQuery(); if (count > 0) { is_success = true; } } catch (SqlException ex) { throw ex; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } } return(is_success); } }
public List <OwnerTenantRegistrationModel> GetAllAssociationMember() { List <OwnerTenantRegistrationModel> getalllist = new List <OwnerTenantRegistrationModel>(); using (SqlConnection cn = new SqlConnection(cns)) { using (SqlCommand cmd = new SqlCommand("getassociationmember", cn)) { cmd.CommandType = CommandType.StoredProcedure; try { cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { OwnerTenantRegistrationModel model = new OwnerTenantRegistrationModel(); model.Id = Convert.ToInt32(dr["id"]); model.Fname = dr["fname"].ToString(); model.Lname = dr["lname"].ToString(); model.Age = (int)dr["age"]; model.Gender = dr["gender"].ToString(); model.Cell = dr["cell_no"].ToString(); model.Email = dr["email"].ToString(); model.Block = dr["block"].ToString(); model.Flat_no = (int)dr["flat_no"]; model.Desigination = dr["role"].ToString(); getalllist.Add(model); } } } catch (SqlException ex) { throw ex; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } } } return(getalllist); }
public OwnerTenantRegistrationModel SearchMember(OwnerTenantRegistrationModel model) { OwnerTenantRegistrationModel getmember = new OwnerTenantRegistrationModel(); using (SqlConnection cn = new SqlConnection(cns)) { using (SqlCommand cmd = new SqlCommand("searchmember", cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@email", model.Email); try { cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { getmember.Fname = dr["fname"].ToString(); getmember.Lname = dr["lname"].ToString(); getmember.Age = (int)dr["age"]; getmember.Gender = dr["gender"].ToString(); getmember.Cell = dr["cell_no"].ToString(); getmember.Email = dr["email"].ToString(); getmember.Password = dr["password"].ToString(); getmember.Block = dr["block"].ToString(); getmember.Flat_no = (int)dr["flat_no"]; } dr.Close(); } } catch (SqlException ex) { throw ex; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } } } return(getmember); }
public bool AddAssociationMember(OwnerTenantRegistrationModel model) { bool is_added = false; using (SqlConnection cn = new SqlConnection(cns)) { using (SqlCommand cmd = new SqlCommand("addassociationmember", cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@fname", model.Fname); cmd.Parameters.AddWithValue("@lname", model.Lname); cmd.Parameters.AddWithValue("@age", model.Age); cmd.Parameters.AddWithValue("@gender", model.Gender); cmd.Parameters.AddWithValue("@cell_no", model.Cell); cmd.Parameters.AddWithValue("@email", model.Email); cmd.Parameters.AddWithValue("@password", model.Password); cmd.Parameters.AddWithValue("@block", model.Block); cmd.Parameters.AddWithValue("@flat_no", model.Flat_no); cmd.Parameters.AddWithValue("@role", model.Desigination); try { cn.Open(); int count = cmd.ExecuteNonQuery(); if (count > 0) { is_added = true; } } catch (SqlException ex) { throw ex; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } } } return(is_added); }
public void DeleteOwnerTenant(OwnerTenantRegistrationModel deletemodel) { }