Beispiel #1
0
        public bool AddOrUpdateWard(Ward record, string sp)
        {
            bool isAddedOrUpdatedSuccessfully = false;

            using (SqlConnection con = GetConnection())
            {
                con.Open();

                SqlCommand command = new SqlCommand(sp, con);
                command.CommandType = CommandType.StoredProcedure;

                SqlParameter wardCode = GetParameter("@WardCode", SqlDbType.VarChar, record.WardCode);
                SqlParameter name     = GetParameter("@WardName", SqlDbType.VarChar, record.WardName);
                SqlParameter beds     = GetParameter("@Beds", SqlDbType.Int, record.NoOfBeds);
                SqlParameter division = GetParameter("@Division", SqlDbType.VarChar, record.Division);

                command.Parameters.Add(wardCode);
                command.Parameters.Add(name);
                command.Parameters.Add(beds);
                command.Parameters.Add(division);

                var results = command.ExecuteNonQuery();

                if (results > -1)
                {
                    isAddedOrUpdatedSuccessfully = true;
                }
            }

            return(isAddedOrUpdatedSuccessfully);
        }
Beispiel #2
0
        public IList <Ward> GetAllWard()
        {
            List <Ward> allWards = new List <Ward>();

            using (SqlConnection con = GetConnection())
            {
                con.Open();

                SqlCommand command = new SqlCommand("GetAllWards", con);
                command.CommandType = CommandType.StoredProcedure;

                var results = command.ExecuteReader();

                if (results.HasRows)
                {
                    Ward ward;
                    int  tempInt;

                    while (results.Read())
                    {
                        ward          = new Ward();
                        ward.WardCode = results["WardCode"].ToString();
                        ward.WardName = results["WardName"].ToString();
                        ward.Division = results["Division"].ToString();
                        int.TryParse(results["Beds"].ToString(), out tempInt);
                        ward.NoOfBeds = tempInt;

                        allWards.Add(ward);
                    }
                }
            }

            return(allWards);
        }
Beispiel #3
0
        public bool DeleteWard(Ward record)
        {
            bool isAddedOrUpdatedSuccessfully = false;

            using (SqlConnection con = GetConnection())
            {
                con.Open();

                SqlCommand command = new SqlCommand("DeleteWard", con);
                command.CommandType = CommandType.StoredProcedure;
                SqlParameter wardCode = GetParameter("@WardCode", SqlDbType.VarChar, record.WardCode);
                command.Parameters.Add(wardCode);

                var results = command.ExecuteNonQuery();

                if (results > -1)
                {
                    isAddedOrUpdatedSuccessfully = true;
                }
            }

            return(isAddedOrUpdatedSuccessfully);
        }
Beispiel #4
0
 public bool UpdateWard(Ward record)
 {
     return(AddOrUpdateWard(record, "UpdateWard"));
 }
Beispiel #5
0
 public bool AddWard(Ward record)
 {
     return(AddOrUpdateWard(record, "InsertWard"));
 }