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