private static void GetDataFromDatabase(MainBook mainBook, SqlDataReader reader) { mainBook.MainBookId = int.Parse(reader["id"].ToString()); mainBook.MainBookCode = reader["main_book_code"].ToString(); mainBook.MainBookName = reader["main_book_name"].ToString(); mainBook.MainBookClass = reader["main_book_class"].ToString(); }
protected void firstButton_Click(object sender, EventArgs e) { MainBook mainBook = mainBookManager.GetMainBooks(0); GetValueFromDatabase(mainBook); Session["active"] = 0; }
public string Save(MainBook mainBook) { if (mainBookGateway.Insert(mainBook) > 0) { return("Saved Successfully!!"); } return("Could Not Save Data in Database!!"); }
protected void lastButton_Click(object sender, EventArgs e) { List <MainBook> mainBookList = (List <MainBook>)Session["mainBooks"]; int x = mainBookList.Count - 1; MainBook mainBook = mainBookManager.GetMainBooks(x); GetValueFromDatabase(mainBook); Session["active"] = x; }
public int Insert(MainBook mainBook) { SqlConnection connection = new SqlConnection(connectionString); string query = "INSERT INTO tbl_main_book VALUES('" + mainBook.MainBookCode + "','" + mainBook.MainBookName + "','" + mainBook.MainBookClass + "')"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return(rowAffected); }
protected void saveButton_Click(object sender, EventArgs e) { MainBook mainBook = new MainBook(groupCodeTextBox.Text, groupNameTextBox.Text, classTextBox.Text); if (groupCodeTextBox.Text == "" || groupNameTextBox.Text == "" || classTextBox.Text == "") { message.InnerText = "All Fields are Required!!"; messageLabel.InnerText = ""; } else { messageLabel.InnerText = mainBookManager.Save(mainBook); } }
protected void previousButton_Click(object sender, EventArgs e) { int active = (int)Session["active"]; active--; List <MainBook> mainBookList = (List <MainBook>)(Session["mainBooks"]); if (active <= -1) { active = mainBookList.Count - 1; } MainBook mainBook = mainBookManager.GetMainBooks(active); GetValueFromDatabase(mainBook); Session["active"] = active; }
public MainBook GetMainBooks(int i) { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM tbl_main_book ORDER BY id ASC OFFSET " + i + " ROWS FETCH NEXT 1 ROWS ONLY"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); MainBook mainBook = new MainBook(); while (reader.Read()) { GetDataFromDatabase(mainBook, reader); } reader.Close(); connection.Close(); return(mainBook); }
private string LoadNextCode() { MainBook mainBook = mainBookManager.GetNextCode(); string mBookCode = mainBook.MainBookCode; int c; if (mBookCode == null) { c = 1; } else { c = (mBookCode[3] - '0') * 10 + (mBookCode[4] - '0') + 1; } string nextCode = "MBC" + c.ToString("00"); return(nextCode); }
public MainBook GetNextCode() { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT TOP 1 * FROM tbl_main_book ORDER BY id DESC"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); MainBook mainBook = new MainBook(); while (reader.Read()) { mainBook.MainBookId = int.Parse(reader["id"].ToString()); mainBook.MainBookCode = reader["main_book_code"].ToString(); } reader.Close(); connection.Close(); return(mainBook); }
public List <MainBook> GetAllMainBook() { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM tbl_main_book"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <MainBook> mainBookList = new List <MainBook>(); while (reader.Read()) { MainBook mainBook = new MainBook(); GetDataFromDatabase(mainBook, reader); mainBookList.Add(mainBook); } reader.Close(); connection.Close(); return(mainBookList); }
public List <MainBook> GetAllMainBookByDropDownList() { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM tbl_main_book"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <MainBook> mainBookList = new List <MainBook>(); while (reader.Read()) { MainBook mainBook = new MainBook(); mainBook.MainBookId = int.Parse(reader["id"].ToString()); mainBook.MainBookCode = reader["main_book_code"].ToString(); mainBookList.Add(mainBook); } reader.Close(); connection.Close(); return(mainBookList); }
public HttpResponseMessage Post([FromBody] MainBook value) { if (value.EndDate == DateTime.MinValue) { value.EndDate = Function.GetTime().AddDays(365); } ; if (value.StartDate == DateTime.MinValue) { value.StartDate = Function.GetTime(); } ; if (value.PublicationDate == DateTime.MinValue) { value.PublicationDate = Function.GetTime().AddDays(-365); } ; var response = (int)DapperHelper.InsertSQL <MainBook>(connectionString, TableName, value); value.SeqNo = response; return(Request.CreateResponse(HttpStatusCode.OK, value)); }
public HttpResponseMessage Delete([FromBody] MainBook value) { var response = DapperHelper.DeleteSQL(connectionString, TableName, value.SeqNo); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public HttpResponseMessage Put([FromBody] MainBook value) { var response = DapperHelper.UpdateSQL <MainBook>(connectionString, TableName, value); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
private void GetValueFromDatabase(MainBook mainBook) { groupCodeTextBox.Text = mainBook.MainBookCode; groupNameTextBox.Text = mainBook.MainBookName; classTextBox.Text = mainBook.MainBookClass; }