public static int InsertNewFormInfo(FormInfo formInfo) { int numberAffectedRows = 0; SqlCeConnection conn = BackEndUtils.GetSqlConnection(); try { conn.Open(); SqlCeCommand command = new SqlCeCommand(Form_Updated_SQL.commandInsertIntoFormInfo, conn); command.Parameters.Add("@formName", formInfo.localFormName); command.Parameters.Add("@formStatus", FormInfo.formStatus.Active); command.Parameters.Add("@formUpdated", "True"); numberAffectedRows = Convert.ToInt32(command.ExecuteNonQuery()); } finally { conn.Close(); } return numberAffectedRows; }
public static int InsertFormInfoCheckForFirstUse(string formName) { FormInfo formInfo = new FormInfo(formName, (int)FormInfo.formStatus.Active, "True"); SqlCeConnection conn = BackEndUtils.GetSqlConnection(); int returnedFormStatus = -1; try { conn.Open(); int foundRows = GetFoundRowsForExistingForm(formName, conn); if (foundRows > 0) { returnedFormStatus = GetFormStatus(formName, conn); } else { InsertNewFormInfo(formInfo); } } finally { conn.Close(); } return returnedFormStatus; }