private static void GetAllInfoFromDatabase(PPLimination ppLimination, SqlDataReader reader) { ppLimination.PPLiminationId = int.Parse(reader["id"].ToString()); ppLimination.PPLiminationCode = reader["pplimination_code"].ToString(); ppLimination.PPLiminationName = reader["pplimination_name"].ToString(); ppLimination.PPLiminationAddress = reader["pplimination_address"].ToString(); ppLimination.PPLiminationOpeningBalance = Convert.ToDouble(reader["pplimination_opening_balance"].ToString()); }
public string Save(PPLimination ppLimination) { if (ppLiminationGateway.Insert(ppLimination) > 0) { return("Saved Successfully!!"); } else { return("Could Not Save data in Database!!"); } }
public int Insert(PPLimination ppLimination) { SqlConnection connection = new SqlConnection(connectionString); string query = "INSERT INTO tbl_ppLimination VALUES('" + ppLimination.PPLiminationCode + "','" + ppLimination.PPLiminationName + "','" + ppLimination.PPLiminationAddress + "','" + ppLimination.PPLiminationOpeningBalance + "')"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return(rowAffected); }
public PPLimination GetPpLiminations(int rowNo) { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM tbl_ppLimination ORDER BY id ASC OFFSET " + rowNo + " ROWS FETCH NEXT 1 ROWS ONLY"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); PPLimination ppLimination = new PPLimination(); while (reader.Read()) { GetAllInfoFromDatabase(ppLimination, reader); } reader.Close(); connection.Close(); return(ppLimination); }
protected void nextButton_Click(object sender, EventArgs e) { int active = (int)Session["active"]; List <PPLimination> ppLiminationList = (List <PPLimination>)(Session["liminations"]); if (active == ppLiminationList.Count) { active = 0; } PPLimination ppl = ppLiminationManager.GetPpLiminations(active); ppLiminationCodeTextBox.Text = ppl.PPLiminationCode; ppLiminationNameTextBox.Text = ppl.PPLiminationName; ppLiminationAddressTextArea.InnerText = ppl.PPLiminationAddress; ppLiminationOpeningBalanceTextBox.Text = ppl.PPLiminationOpeningBalance.ToString(); active++; Session["active"] = active; }
private string LoadNextppLiminationCode() { PPLimination ppl = ppLiminationManager.GetNextPPLiminationCode(); string pplCode = ppl.PPLiminationCode; int count; if (pplCode == null) { count = 1; } else { count = (pplCode[3] - '0') * 10 + (pplCode[4] - '0') + 1; } string nextCode = "PPL" + count.ToString("00"); return(nextCode); }
public PPLimination GetNextPPLiminationCode() { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT TOP 1 * FROM tbl_ppLimination ORDER BY id DESC"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); PPLimination ppLimination = new PPLimination(); while (reader.Read()) { ppLimination.PPLiminationId = int.Parse(reader["id"].ToString()); ppLimination.PPLiminationCode = reader["pplimination_code"].ToString(); } reader.Close(); connection.Close(); return(ppLimination); }
public List <PPLimination> GetAllPpLiminationInfo() { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM tbl_ppLimination"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <PPLimination> ppLiminationList = new List <PPLimination>(); while (reader.Read()) { PPLimination ppLimination = new PPLimination(); GetAllInfoFromDatabase(ppLimination, reader); ppLiminationList.Add(ppLimination); } reader.Close(); connection.Close(); return(ppLiminationList); }
protected void saveButton_Click(object sender, EventArgs e) { PPLimination ppLimination = new PPLimination(); ppLimination.PPLiminationCode = ppLiminationCodeTextBox.Text; ppLimination.PPLiminationName = ppLiminationNameTextBox.Text; ppLimination.PPLiminationAddress = ppLiminationAddressTextArea.InnerText; string PPOpeningBalance = ppLiminationOpeningBalanceTextBox.Text; if (ppLiminationCodeTextBox.Text == "" || ppLiminationNameTextBox.Text == "" || ppLiminationAddressTextArea.InnerText == "" || ppLiminationOpeningBalanceTextBox.Text == "") { message.InnerText = "All Fields are Required!!"; } else { ppLimination.PPLiminationOpeningBalance = Convert.ToDouble(PPOpeningBalance); message.InnerText = ppLiminationManager.Save(ppLimination); } }