public void DeletePLace(PLace objRecord) { ConnectionStringSettings objCSS = ConfigurationManager.ConnectionStrings["EventRegConnectionString"]; using (SqlConnection objCnn = new SqlConnection(objCSS.ConnectionString)) { objCnn.Open(); using (SqlCommand objCmd = objCnn.CreateCommand()) { objCmd.CommandType = System.Data.CommandType.StoredProcedure; objCmd.CommandText = "[DeletePLace]"; objCmd.Parameters.Add(new SqlParameter("@PLace_ID", objRecord.PLace_ID)); objCmd.ExecuteNonQuery(); } } }
public List <PLace> GetPLaces() { List <PLace> objRet = new List <PLace>(); ConnectionStringSettings objCSS = ConfigurationManager.ConnectionStrings["EventRegConnectionString"]; using (SqlConnection objCnn = new SqlConnection(objCSS.ConnectionString)) { objCnn.Open(); using (SqlCommand objCmd = objCnn.CreateCommand()) { objCmd.CommandType = System.Data.CommandType.StoredProcedure; objCmd.CommandText = "[GetAllPLace]"; using (SqlDataReader objDR = objCmd.ExecuteReader()) { while (objDR.Read()) { PLace objRec = new PLace(); if (objDR.IsDBNull(objDR.GetOrdinal("PLace_ID"))) { objRec.PLace_ID = 0; } else { objRec.PLace_ID = objDR.GetInt32(objDR.GetOrdinal("PLace_ID")); } if (objDR.IsDBNull(objDR.GetOrdinal("Place"))) { objRec.Place = ""; } else { objRec.Place = objDR.GetString(objDR.GetOrdinal("Place")); } objRet.Add(objRec); } } } } return(objRet); }
public Int32 InsertPLace(PLace objRecord) { Int32 objRet = 0; ConnectionStringSettings objCSS = ConfigurationManager.ConnectionStrings["EventRegConnectionString"]; using (SqlConnection objCnn = new SqlConnection(objCSS.ConnectionString)) { objCnn.Open(); using (SqlCommand objCmd = objCnn.CreateCommand()) { objCmd.CommandType = System.Data.CommandType.StoredProcedure; objCmd.CommandText = "[AddPLace]"; objCmd.Parameters.Add(new SqlParameter("@PLace_ID", objRecord.PLace_ID)); objCmd.Parameters.Add(new SqlParameter("@Place", objRecord.Place)); object obj = objCmd.ExecuteScalar(); if (obj != null) { objRet = Convert.ToInt32(obj); } } } return(objRet); }