Here, I’ve merely thought to write my thoughts about hands-on Angular. This is my first article which tells you how to get your hands dirty with AngularJS & ASP.NET WEBAPI and SQL Server BookMySeat Application Tutorials.

This is the technology stack for this BookMySeat library application, as shown below:

BookMySeat application

In the first article, I shared the technology and other brief information about components used. In this article, will look into WebApi creation and route to configure that.

This is an initial look at the WebAPI controller defined in Solution Explorer as depicted below:

WebAPI


If you open this file, you will have around 6 methods which have generic names to perform the operations and easy to understand.These WebAPI methods are given below:

WebAPI


WebAPI

The complete code for all APIs is given below.

  1. public class BookMySeatAPIController : ApiController
  2. {
  3. //
  4. // GET: /BookMySeatAPI/
  5. SqlConnection objConnection = new SqlConnection();
  6. public void SqlConnection()
  7. {
  8. objConnection.Dispose();
  9. objConnection.ConnectionString = "server=.;database=BookMySeat;uid=sa;pwd=Tpg@1234;";
  10. objConnection.Open();
  11. }
  13. [HttpGet]
  14. public int[] GetSeatCount([FromUri] int slot)
  15. {
  16. try
  17. {
  19. SqlConnection();
  20. SqlCommand SqlCommand = new SqlCommand("sp_GetMySeat", objConnection);
  21. SqlCommand.CommandType = CommandType.StoredProcedure;
  22. SqlCommand.Parameters.AddWithValue("@timeslotid", slot);
  23. SqlDataAdapter da = new SqlDataAdapter(SqlCommand);
  24. da.SelectCommand = SqlCommand;
  25. DataSet ds = new DataSet();
  26. da.Fill(ds);
  27. int[] result = new int[ds.Tables[0].Rows.Count];
  28. for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
  29. {
  30. result[i] = Convert.ToInt16(ds.Tables[0].Rows[i][0].ToString());
  31. }
  32. return result;
  33. }
  34. finally
  35. {
  36. objConnection.Close();
  37. objConnection.Dispose();
  39. }
  40. }
  44. [HttpPost]
  45. [ActionName("SeatBook")]
  46. public int[] PostBookSeat(BookSeat objBookSeat)
  47. {
  48. try
  49. {
  50. SqlConnection();
  51. SqlCommand SqlCommand = new SqlCommand("sp_BookMySeat", objConnection);
  52. SqlCommand.CommandType = CommandType.StoredProcedure;
  53. SqlCommand.Parameters.AddWithValue("@UserName", objBookSeat.UserName);
  54. SqlCommand.Parameters.AddWithValue("@TimeSlot", objBookSeat.TimeSlot);
  55. SqlCommand.Parameters.AddWithValue("@SeatNo", objBookSeat.SeatNo);
  56. SqlDataAdapter da = new SqlDataAdapter(SqlCommand);
  57. da.SelectCommand = SqlCommand;
  58. DataSet ds = new DataSet();
  59. da.Fill(ds);
  60. int[] result = new int[ds.Tables[0].Rows.Count];
  61. for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
  62. {
  63. result[i] = Convert.ToInt16(ds.Tables[0].Rows[i][0].ToString());
  64. }
  65. return result;
  66. }
  67. finally
  68. {
  69. objConnection.Close();
  70. objConnection.Dispose();
  72. }
  73. }
  75. [HttpPost]
  76. [ActionName("ValidateUser")]
  77. public string ValidateUser(ValidateUser objValidateUser)
  78. {
  79. try
  80. {
  81. SqlConnection();
  82. SqlCommand SqlCommand = new SqlCommand("ValidateUser", objConnection);
  83. SqlCommand.CommandType = CommandType.StoredProcedure;
  84. SqlCommand.Parameters.AddWithValue("@UserName", objValidateUser.UserName);
  85. SqlDataAdapter da = new SqlDataAdapter(SqlCommand);
  86. da.SelectCommand = SqlCommand;
  87. DataSet ds = new DataSet();
  88. da.Fill(ds);
  89. return ds.Tables[0].Rows[0][0].ToString();
  90. }
  91. finally
  92. {
  93. objConnection.Close();
  94. objConnection.Dispose();
  95. }
  96. }
  97. [HttpPost]
  98. [ActionName("SeatDetail")]
  99. public string GetSeatDetail(GetSeatDetail objGetSeatDetail)
  100. {
  101. try
  102. {
  103. SqlConnection();
  104. SqlCommand SqlCommand = new SqlCommand("sp_GetSeatDetail", objConnection);
  105. SqlCommand.CommandType = CommandType.StoredProcedure;
  106. // SqlCommand.Parameters.AddWithValue("@UserName", objBookSeat.UserName);
  107. SqlCommand.Parameters.AddWithValue("@TimeSlot", objGetSeatDetail.TimeSlot);
  108. SqlCommand.Parameters.AddWithValue("@SeatNo", objGetSeatDetail.SeatNo);
  109. SqlDataAdapter da = new SqlDataAdapter(SqlCommand);
  110. da.SelectCommand = SqlCommand;
  111. DataSet ds = new DataSet();
  112. da.Fill(ds);
  113. return ds.Tables[0].Rows[0][0].ToString();
  114. }
  115. finally
  116. {
  117. objConnection.Close();
  118. objConnection.Dispose();
  120. }
  121. }
  122. [HttpPost]
  123. [ActionName("DeleteSeat")]
  124. public string DeleteSeat(DeleteSeat objDeleteSeat)
  125. {
  126. try
  127. {
  128. SqlConnection();
  129. SqlCommand SqlCommand = new SqlCommand("sp_DeleteSeat", objConnection);
  130. SqlCommand.CommandType = CommandType.StoredProcedure;
  131. // SqlCommand.Parameters.AddWithValue("@UserName", objBookSeat.UserName);
  132. SqlCommand.Parameters.AddWithValue("@SeatNo", objDeleteSeat.SeatNo);
  133. SqlCommand.Parameters.AddWithValue("@SlotNo", objDeleteSeat.TimeSlot);
  134. SqlDataAdapter da = new SqlDataAdapter(SqlCommand);
  135. da.SelectCommand = SqlCommand;
  136. DataSet ds = new DataSet();
  137. da.Fill(ds);
  138. return ds.Tables[0].Rows[0][0].ToString();
  139. }
  140. finally
  141. {
  142. objConnection.Close();
  143. objConnection.Dispose();
  145. }
  146. }
  148. [HttpGet]
  150. public List<ShowBookSeat> ShowBookSeat()
  151. {
  152. try
  153. {
  154. SqlConnection();
  155. List<ShowBookSeat> list = new List<ShowBookSeat>();
  156. SqlCommand SqlCommand = new SqlCommand("sp_ShowBookDetail", objConnection);
  157. SqlCommand.CommandType = CommandType.StoredProcedure;
  158. // SqlCommand.Parameters.AddWithValue("@UserName", objBookSeat.UserName);
  159. //SqlCommand.Parameters.AddWithValue("@UserName", objDeleteSeat.SeatNo);
  160. //SqlCommand.Parameters.AddWithValue("@SlotNo", objDeleteSeat.TimeSlot);
  161. SqlDataAdapter da = new SqlDataAdapter(SqlCommand);
  162. da.SelectCommand = SqlCommand;
  163. DataSet ds = new DataSet();
  164. da.Fill(ds);
  165. for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
  166. {
  167. ShowBookSeat ShowBookSeat = new ShowBookSeat();
  168. ShowBookSeat.UserName = (ds.Tables[0].Rows[i]["username"]).ToString();
  169. ShowBookSeat.Date =Convert.ToDateTime(ds.Tables[0].Rows[i]["currentday"]);
  170. ShowBookSeat.TimeSlot = Convert.ToInt32(ds.Tables[0].Rows[i]["timeslot"]);
  171. ShowBookSeat.SeatNo = Convert.ToInt32(ds.Tables[0].Rows[i]["seatno"]);
  172. list.Add(ShowBookSeat);
  173. }
  174. return list;
  175. }
  176. finally
  177. {
  178. objConnection.Close();
  179. objConnection.Dispose();
  181. }
  182. }
  184. }
Code segment for WebApiConfig under App_start folder is given below.
  1. public static class WebApiConfig
  2. {
  3. public static void Register(HttpConfiguration config)
  4. {
  5. config.Routes.MapHttpRoute(
  6. name: "DefaultApi",
  7. routeTemplate: "api/{controller}/{id}",
  8. defaults: new { id = RouteParameter.Optional }
  9. );
  10. config.Routes.MapHttpRoute(
  11. name: "seatbook",
  12. routeTemplate: "api/seat/{controller}/{action}/{id}",
  13. defaults: new { id = RouteParameter.Optional }
  14. );
  15. config.Routes.MapHttpRoute(
  16. name: "seatDetail",
  17. routeTemplate: "api/seatdetail/{controller}/{action}/{id}",
  18. defaults: new { id = RouteParameter.Optional }
  19. );
  20. config.Routes.MapHttpRoute(
  21. name: "ValidateUser",
  22. routeTemplate: "api/ValidateUser/{controller}/{action}/{id}",
  23. defaults: new { id = RouteParameter.Optional }
  24. );
  25. config.Routes.MapHttpRoute(
  26. name: "DeleteSeat",
  27. routeTemplate: "api/DeleteSeat/{controller}/{action}/{id}",
  28. defaults: new { id = RouteParameter.Optional }
  29. );
  30. }
  31. }
The application which we are about to build consists almost all of the above defined keywords and the initial look of the application is as shown below.



Hope it’ll help you someday. Enjoy Coding.
Third Part>>