internal static bool SaveMaterialIssuanceItems(int id, string issue_id, string code, string l_no, string qty, string status, string address)
{
bool returns = false;
sqlCe = new CE();
using (SqlCeConnection sqlCon = sqlCe.Open())
{
string query = "INSERT INTO GetMaterialIssuanceItems" +
"(id, issue_id, code, lot_no, qty, status, address) " +
"VALUES (@id, @issue_id, @code, @l_no, @qty, @status, @address);";
using (SqlCeCommand sqlCom = new SqlCeCommand(query, sqlCon))
{
sqlCon.Open();
sqlCom.Parameters.AddWithValue("@id", id);
sqlCom.Parameters.AddWithValue("@issue_id", issue_id);
sqlCom.Parameters.AddWithValue("@code", code);
sqlCom.Parameters.AddWithValue("@l_no", l_no);
sqlCom.Parameters.AddWithValue("@qty", qty);
sqlCom.Parameters.AddWithValue("@status", status);
sqlCom.Parameters.AddWithValue("@address", address);
sqlCom.ExecuteNonQuery();
sqlCon.Close();
returns = true;
}
}
return returns;
}
internal static bool SaveMaterialIssuance(int id, string r_no, string b_no, string r_date, string e_date, string remarks, string c_status)
{
bool returns = false;
sqlCe = new CE();
using (SqlCeConnection sqlCon = sqlCe.Open())
{
string query = "INSERT INTO GetMaterialIssuance" +
"(id, request_no, batch_no, requested_date, expected_date, remarks, completion_status) " +
"VALUES (@id, @request_no, @batch_no, @requested_date, @expected_date, @remarks, @completion_status);";
using (SqlCeCommand sqlCom = new SqlCeCommand(query, sqlCon))
{
sqlCon.Open();
sqlCom.Parameters.AddWithValue("@id", id);
sqlCom.Parameters.AddWithValue("@request_no", r_no);
sqlCom.Parameters.AddWithValue("@batch_no", b_no);
sqlCom.Parameters.AddWithValue("@requested_date", config.DefaultDateTimeFormat(Convert.ToDateTime(r_date)));
sqlCom.Parameters.AddWithValue("@expected_date", config.DefaultDateTimeFormat(Convert.ToDateTime(e_date)));
sqlCom.Parameters.AddWithValue("@remarks", remarks);
sqlCom.Parameters.AddWithValue("@completion_status", c_status);
sqlCom.ExecuteNonQuery();
sqlCon.Close();
returns = true;
}
}
return returns;
}