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;
}
