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